Group Replicaton - Lagging Slave
I've setup a Group Replication with two servers and I have a third that will be joining the cluster shortly. I have it setup with a single primary, so right now there is one writer and one reader. Both systems are the exact same hardware (they were ordered together) ... the primary is keeping up with the load with no problem. However the reader is falling more and more behind ... the difference between the last received GTID and the last executed GTID is growing at a very large rate .... in a few hours it has gone over 7 million and it's still growing. According to the replication_group_member_stats the reader has 0 transactions in the queue ... but the last executed vs the last received is showing a large backup. I'm not sure where to even begin to troubleshoot this. Does anyone have any suggestions?
Subject
Views
Written By
Posted
Group Replicaton - Lagging Slave
872
August 31, 2017 04:15PM
897
September 01, 2017 07:38AM
507
September 01, 2017 01:34PM
488
September 01, 2017 01:46PM
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.