MySQL Replication — Advanced Features

on YouTube ↗49m

" summary

Covers MySQL 5.7 replication features and practical tradeoffs: GTID simplifies automated failover and precise transaction tracking but needs relay-log-repository and careful topology handling; ROW vs STATEMENT vs MIXED explains binlog size (FULL vs MINIMAL vs NOBLOB row images) and when statement causes nondeterministic bugs; semi-sync vs lossless semi-sync describes reduced data-loss modes and timeout pitfalls; explains parallel replication (56 per-schema, 57 group-aware) to raise slave throughput, warns about multi-master conflict patterns and recommends Orchestrator/MHA/ProxySQL for failover and routing.

AI-written summary · about

" chapters (13)

1. 0:00Introduction to replication
2. 6:09MySQL replication history
3. 10:06Typical replication setup
4. 12:54Binary log formats
5. 16:24Replication filtering
6. 18:31GTID and transaction tracking
7. 21:25Parallel replication
8. 24:17Sync vs async replication
9. 28:54Semi-sync replication
10. 32:10Multi-master replication
11. 36:24MySQL Group Replication
12. 39:58Failover and traffic routing
13. 44:20Q&A

" related talks

• 22mMySQL Replication: Latest DevelopmentsSujatha Sivakumar · FOSSASIA Summit 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
• 43mHow MySQL Replication WorksAndrey Aksenov · HighLoad++ 2014
• 48mDemystifying MySQL Replication Crash SafetyJean-François Gagné · HighLoad++ Moscow 2018
• 51mReplication latest features: the community sceptic roundupGiuseppe Maxia · Percona Live Open Source Database Conference 2017
• 23mMySQL Group ReplicationVenkatesh Duggirala · FOSSASIA Summit 2017
• 52mMySQL replication deep dive, and ideas for PostgreSQLJagdeep Sidhu · PGConf.dev 2024