GTID Replication - Implementation and Troubleshooting

Replication & Backup
4 November 4:30pm - 5:20pm @ Sentosa 5-8

Duration: 
50 minutes conference
My talk will be mainly about GTID replication, how to implement and troubleshoot it. I'll start by explaining what is GTID passing in brief about the GTID concept and what benefits are there when using GTID instead of the classic method. Then I'll go though the most important MySQL system variables which should be used in GTID Replication setup. Then I'll move to how to implement a GTID replication from scratch and how to add a new slave to an already running replication setup explaining the trick of the two system variables gtid_executed and gtid_purged. After that I'll go through the migration process from a replication setup using the classic method (based on binary logs information) to the transaction-based replication (based on GTID). Finally, I'll move to a very important topic which is how to troubleshoot GTID replication. Of course, no MySQL user should deploy GTID replication in production unless knowing how to troubleshoot it and how to fix most of the expected errors. I'll focus on the following two operations which are mostly expected in the replication setup: 1- How to inject an empty transaction (which is a replacement to SQL_SLAVE_SKIP_COUNTER in the classic replication). 2- How to re-initialize a slave when the replication is broke and could not be started anymore (which needs special interaction from the DBA in regards to the system variables gtid_executed and gtid_purged and that is not needed in the classic replication). For each issue I'll make a small comparison on how it should be solved in the classic replication and in GTID replication so that you will have a complete idea on how to cope with the new fixes.


Speakers

Senior Database Administrator, Rakuten, Inc.
Biography: 
Abdel-Mawla joined Rakuten, Inc. as a Senior Database Administrator in 2014. Main specialities include MySQL operations, performance tuning, backup and recovery, replication and HA. Before Rakuten, he was working at FromDual as a MySQL support engineer and The BookDepository as a MySQL DBA for about 10 years of total experience. He also blogs at https://mysqlstepbystep.com/ .

Slides