MySQL 5.6 includes a host of enhancements to replication, enabling DevOps teams to reliably scale-out their MySQL infrastructure across commodity hardware, on-premise or in the cloud.
One of the most significant enhancements is the introduction of Global Transaction Identifiers (GTIDs) where the primary development motivation was:
- enabling seamless failover or switchover from a replication master to slave
- promoting that slave to the new master
- without manual intervention and with minimal service disruption.
You can download the new MySQL Replication High Availability Guide to learn more. …[Read more]