MySQL GTID Implementation, Maintenance, and Best Practices - The Short Version

on YouTube ↗49m

" summary

GTID adoption is practical and concrete: Percona Server 5.6 uses gtid_deployment_step to enable GTIDs online without full downtime while the conversion sequence is restart replicas, promote one replica, disable deployment step and run CHANGE MASTER to MASTER_AUTO_POSITION=1. Watch for auto.cnf server_uuid collisions when restoring files, gaps caused by multi‑threaded slaves, and use mysqlbinlog --include-gtids or GTID_NEXT plus a small BEGIN/COMMIT to “fake” a missing transaction. MySQL 5.7 adds an executed GTIDs table and fully dynamic GTID mode.

AI-written summary · about

" chapters (34)

1. 0:00Intro
2. 0:53Traditional MySQL replication primer
3. 1:03Standard topologies
4. 1:20SHOW MASTER STATUS
5. 2:21Defining GTID
6. 3:24Binary Log Contents
7. 4:04SHOW SLAVE STATUS NEW GTID Information
8. 4:34GTID Sets & Related Variables
9. 6:03GTID vs Binlog Position
10. 6:50Enabling GTIDs in Oracle MySQL 5.6
11. 8:16Potential Replication Conflicts
12. 10:16Percona Server 5.6 implementation
13. 10:38Starting topology
14. 10:48MySQL instance: replication configuration
15. 10:59Important 5.6 GTID variables
16. 11:57Important GTID variables (cont.)
17. 12:39General steps
18. 14:43Important GTID status info variables
19. 16:19GTID slave status
20. 17:02GTID master status
21. 19:01Maintenance
22. 19:41Currently writing master
23. 20:39GTID set gaps
24. 21:38Finding transactions
25. 22:46Fixing transactions with gtid_next
26. 25:05Advanced Concepts
27. 26:26binlog_gtid_simple_recovery
28. 28:55Faking and skipping transactions
29. 30:36GTID Set functions
30. 31:55START SLAVE UNTIL ...
31. 32:47SHOW SLAVE STATUS NONBLOCKING
32. 34:43Enabling GTID online
33. 35:55mysql.gtid_executed table
34. 37:29SurveyMonkey

" related talks

• 22mMySQL Replication: Latest DevelopmentsSujatha Sivakumar · FOSSASIA Summit 2017
• 53mMySQL replication setup, benefits, limitationsRick Golba, Stephane Combaudon · Percona Live MySQL Conference & Expo 2015
• 49mMySQL Replication — Advanced FeaturesPetr Zaytsev · HighLoad++ 2017
• 23mMySQL Group ReplicationVenkatesh Duggirala · FOSSASIA Summit 2017
• 52mMySQL replication deep dive, and ideas for PostgreSQLJagdeep Sidhu · PGConf.dev 2024
• 20mMySQL Binary Logs From Replication Tool to Enterprise Event PlatformBrijesh Patel · Percona Live 2026 Bay Area
• 26mUnderstanding MySQL ConceptsMatthias Crauwels · All Things Open 2020
• 35mMySQL HA, Recovery and Load BalancingDavey Shafik · SunshinePHP 2014