Global Transaction Identifiers – why, what, and howNext post: Advanced use of Global Transaction Identifiers
This post was kindly translated to Japanese by Ryusuke Kajiyama.
In MySQL 5.6 we introduced a new replication feature called Global Transaction Identifiers, or GTIDs. While there are many use cases, our primary motivation for introducing GTIDs is that it allows for seamless failover. By this, we mean promoting one of the slaves to be come a master, if the master crashes, with minimal manual intervention and service disruption.
This is the first in a series of several blog posts. We will go through several use cases and show how [Read more...]