[jira] [Created] (COTTON-5) Leverage GTID to properly failover MySQL master instances.

["Yan Xu (JIRA)" <ji...@apache.org>]

Yan Xu created COTTON-5:
---------------------------

             Summary: Leverage GTID to properly failover MySQL master instances.
                 Key: COTTON-5
                 URL: https://issues.apache.org/jira/browse/COTTON-5
             Project: COTTON
          Issue Type: Task
            Reporter: Yan Xu


The current Cotton master failover code is capable of reliably detecting the dead instance, sending queries to find the "most current" slave and sending the commands to promote the new master and reparent the slaves. However without GTID our current scripts that Cotton invokes to do these things aren't sufficient because some files need to be copied out of band by tools such as [MHA|https://code.google.com/p/mysql-master-ha/].

If we leverage GTID in MySQL 5.6 we can make failover really work without relying on external tools.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)