How MySQL Replication Works

on YouTube ↗43m

" summary

Explains replication types (synchronous, asynchronous, semi-synchronous; master-master vs master-slave) and how MySQL implements them across versions. Covers binary and relay logs, statement-row-binlog formats (SBR/RBR/mixed), position-tracking issues, GTID, and why replication shortcomings led to projects like Tungsten and Galera, plus a few practical tricks for MySQL replication internals.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 7:38About synchronization
3. 9:42About write servers
4. 20:58What the slave does

" related talks

• 49mMySQL Replication — Advanced FeaturesPetr Zaytsev · HighLoad++ 2017
• 53mMySQL replication setup, benefits, limitationsRick Golba, Stephane Combaudon · Percona Live MySQL Conference & Expo 2015
• 14mThe State of the Art of MySQL ReplicationRicky Setyawan · FOSSASIA Summit 2017
• 22mMySQL Replication: Latest DevelopmentsSujatha Sivakumar · FOSSASIA Summit 2017
• 48mDemystifying MySQL Replication Crash SafetyJean-François Gagné · HighLoad++ Moscow 2018
• 52mMySQL replication deep dive, and ideas for PostgreSQLJagdeep Sidhu · PGConf.dev 2024
• 51mReplication latest features: the community sceptic roundupGiuseppe Maxia · Percona Live Open Source Database Conference 2017
• 23mMySQL Group ReplicationVenkatesh Duggirala · FOSSASIA Summit 2017