In MySQL 5.6 we introduced
GTID_MODE as a new server option. A globalÂ transaction identifier (GTID) is a unique identifier created and associatedÂ with each transaction when it is committed on the server of origin (master).Â This identifier is unique not only to the server on which it originated, butÂ is unique across all servers in a given replication setup. There is a 1-to-1Â mapping between all transactions and all GTIDs. For additional information, please refer to the MySQL manual.
Prior to 5.6.17 and 5.7.4, we had GTID specific replication (referred to as “rpl” within the MTR suite) regression tests, and we had to[Read more...]