Handling failover with MySQL 5.6 and Global Transaction IDs

Replication and High Availability Strategies
4 April 11:00AM - 11:50AM @ Ballroom E

Experience level: 
Intermediate
Duration: 
50 minutes conference
Replication has been used for a long time to provide high availability. However the traditional position-based replication has a serious drawback: a same transaction will never have the same position on two different servers. Reconfiguring replication is then difficult and error-prone, which is bad when you want to make failovers as graceful and reliable as possible. Enter MySQL 5.6 and Global Transaction IDs (GTIDs): a transaction is guaranteed to have the same identifiers across all servers of a given replication topology. This opens up new ways to handle failover, for instance when used in combination with Oracle's MySQL Utilities. But are GTIDs ready for production usage? How do you set up GTIDs and the MySQL Utilities to provide high availability and automatic failover to your replication cluster? What are the limitations of the MySQL Utilities? How do they compare to existing tools, for instance with MHA which is a robust and widely used tool? Come to this session to get a sense of the benefits and challenges of the high-availability solutions available with MySQL 5.6.


Speakers

MySQL Consultant, Percona
Biography: 
Stephane is working as a MySQL consultant for Percona. Before this role he was a MySQL DBA for leading French companies such as Dailymotion and France Telecom. He has been using the LAMP platform for more than 10 years and he is a regular speaker at conferences on MySQL and free software.