The State of the Art of MySQL Replication

on YouTube ↗14m

" summary

Recent MySQL releases add replication features that aim to cut ops work and fit cloud needs by supporting multi‑source replication in 5.7, writable multi‑member Group Replication, and built‑in failure handling. Replication modes include async and semi‑synchronous binlog flush that forces the master to push binlog records to slave storage first. Group Replication requires minimum 3 nodes and supports max 99 nodes with voting, and an automatic failover script promotes the most up‑to‑date slave.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 2:05The Evolution of Replication
3. 3:32More Topologies
4. 7:27Consistency Levels
5. 9:25Replication Workflow

" related talks

• 49mMySQL Replication — Advanced FeaturesPetr Zaytsev · HighLoad++ 2017
• 43mHow MySQL Replication WorksAndrey Aksenov · HighLoad++ 2014
• 48mDemystifying MySQL Replication Crash SafetyJean-François Gagné · HighLoad++ Moscow 2018
• 53mMySQL replication setup, benefits, limitationsRick Golba, Stephane Combaudon · Percona Live MySQL Conference & Expo 2015
• 51mReplication latest features: the community sceptic roundupGiuseppe Maxia · Percona Live Open Source Database Conference 2017
• 24mComparing the High Availability of MySQL with Modern Distributed SQL DatabasesRon Xing · Distributed SQL Summit Asia 2023
• 41mAsynchronous Replication Without CensorshipOleg Tsarev · HighLoad++ 2014
• 29mEverything You Ever Wanted to Know About MariaDB Replication but Were Afraid to AskEdward Stoever · MariaDB OpenWorks 2023