Re: How to remove a bad GTID from GTID set?
Posted by:
Van Stokes
Date: April 03, 2017 07:41AM
For those who find this later in life..
This was a catastrophic mistake. There is no way to fix this problem. A RESET MASTER / CHANGE MASTER TO must be performed farm wide. Why is it so catastrophic? Because, in a Multi-Master circular replication, ALL the MySQL servers need to have the RESET MASTER / CHANGE MASTER TO performed.
In MySQL 5.6, the GTID sets are stored in the master BINLOG files - hence why the RESET MASTER must be done. However, when you do a RESET MASTER the command also resets the servers last used GTID to 0. Now the slaves have GTID's larger than the master server. The slave will not skip transactions until the GTID exceeds the slaves GTID_EXECUTED_SET value for the master server. That is why you have to perform RESET MASTER / CHANGE MASTER TO on all the slave servers too.
After performing the RESET MASTER / CHANGE MASTER TO we only need to dump/restore the databases that were being updated on the affected master server so that they slaves can be synced up.
Subject
Views
Written By
Posted
2150
April 03, 2017 06:23AM
Re: How to remove a bad GTID from GTID set?
3415
April 03, 2017 07:41AM
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.