<< Previous Post: Advanced use of Global Transaction Identifiers
As we saw in my previous posts
, Global Transaction Identifiers in MySQL 5.6 allow you to change the replication topology arbitrarily. You don't even need to specify the positions in the replication stream – when you turn on auto-positioning, the master automatically sends only those transactions that are missing on the slave.
When you do a fail-over, you want to make sure that the new master is up-to-date. For instance, consider the following scenario: [Read more...]