I have previously written about the new replication protocol that comes with GTIDs in MySQL 5.6. Because of this new replication protocol, you can inadvertently create errant transactions that may turn any failover to a nightmare. Let’s see the problems and the potential solutions.
- Errant transactions may cause all kinds of data corruption/replication errors when failing over.
- Detection of errant transactions can be …