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: 
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.


MySQL Consultant, Percona
Software architect Stéphane Combaudon joined Percona in July 2012 after working as a MySQL DBA for leading French companies such as Dailymotion (a video streaming service) and France Telecom. He uses the experience he’s acquired over the past 11 years to not only solve challenges and objectives, but also contribute new and innovating solutions to every project he works on. His constant search for learning new things keeps his skills sharp, knowledge he often shares via the MySQL Performance Blog. A prolific blogger, Stéphane’s posts routinely receive hundreds of Facebook “Likes,” tweets and social shares, mainly because so many readers find them helpful to what they are currently working on as DBAs and developers. That desire to give back to the MySQL community is why he enjoys speaking at conferences around the world, including Fosdem, Froscon and the Percona Live MySQL conferences each year in both London and Santa Clara, Calif. Stéphane, who lives in Paris with his wife and their twin daughters, enjoys spending time with his family when not working. He’s also an avid chess player, participating in several tournaments annually.