Using MySQL Global Transaction IDs in Production

Aug 27, 2014

MySQL Technical Webinar

Stephane Combaudon, Architect

Watch the recording of this webinar at: http://www.percona.com/resources/mysql-webinars/using-mysql-global-trans...

MySQL 5.6 introduced Global Transaction IDs (GTIDs) to make the reconfiguration of replication straightforward. The key benefit is that you can instantly and reliably change your replication topology if a node goes down or if the current topology no longer fits your needs. But of course operating a GTID-based cluster brings new challenges: old habits no longer work, tools have changed, and new issues have appeared.

In this webinar, you will learn about using GTIDs in production, including:

  • How to execute the daily DBA tasks related to GTID-based replication, such as monitoring replication status or recovering from replication errors
  • The new options for high availability and the tools that can help you
  • What can go wrong when using GTIDs