How R/O node catch up global.gtid_executed of R/W master's?
HI,
Currently, I have deployed community version Ver 14.14 Distrib 5.7.18, for Linux (x86_64) mysql innodb cluster setup (3 nodes). db01, db02, db03
db01 being the master (R/W) while the other two are (R/O).
my questions are:
1) when db02 goes down (powered off) for a day, and then it was brought up (powered on), the db02 global.gtid_executed and db01 global.gtid_executed were in difference of 1000000. while db01's gtid is still constantly going up in numbers, how does db02 catches up with the master's?
2) suppose there is no Write operations from applications, why does db01's gtid still increasing?
3) would there be timeout when db02 keeps recovering?
group_replication_applier | e45439a-80fb-11e7-8cd2-000d3aa1a40b | db02 | 3306 | RECOVERING |
Many thanks in advance.
Subject
Views
Written By
Posted
How R/O node catch up global.gtid_executed of R/W master's?
688
August 17, 2017 08:14PM
491
September 13, 2017 08:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.