In the previous post of this series we saw how you could use
mysqlrpladmin to perform manual failover/switchover when GTID replication is enabled in MySQL 5.6. Now we will review
mysqlfailover (version 1.4.3), another tool from the MySQL Utilities that can be used for automatic failover.
mysqlfailovercan perform automatic failover if MySQL 5.6′s GTID-replication is enabled.
- All slaves must use
- The monitoring node