Comparing the High Availability of MySQL with Modern Distributed SQL Databases

on YouTube ↗24m

" summary

Walks through MySQL HA varieties — native async (master‑slave), semi‑sync, Galera/Percona clusters and InnoDB Group Replication — and calls out concrete limits: single‑writer defaults, full‑copy nodes, manual provisioning, poor handling of large DDLs and cross‑region distribution. Contrasts that with a distributed SQL implementation that uses a two‑layer design, Postgres‑compatible API, Raft consensus, automatic sharding and 3x replication per tablet, enabling zero‑downtime upgrades, automatic resharding and horizontal scale to hundreds of nodes and terabytes.

AI-written summary · about

" chapters (6)

1. 0:00MySQL and distributed SQL
2. 6:14MySQL HA architectures
3. 12:17Distributed SQL explained
4. 17:41Scalability and multi-master
5. 20:31Operational overhead and failover
6. 22:00YugabyteDB models and closing

" related talks

• 35mMySQL HA, Recovery and Load BalancingDavey Shafik · SunshinePHP 2014
• 32mBest Practice in Design and Implementing MySQL Geographic Distributed, High Availability SolutionsMarco Tusa · Percona Live Online 2020
• 52mBest Practices for MySQL High Availability in 2022Colin Charles · Percona Live 2022
• 27mDistributed MySQL Architectures: Past, Present and FuturePeter Zaitsev · Distributed SQL Summit 2019
• 54mThe Evolution of a MySQL Database, From a Single Instance to HA With Disaster RecoveryFrederic Descamps · Percona Live 2022
• 14mThe State of the Art of MySQL ReplicationRicky Setyawan · FOSSASIA Summit 2017
• 58mDatabase High AvailabilitySusanne (miracee) Holzgraefe · FrOSCon 2016
• 49mMySQL Replication — Advanced FeaturesPetr Zaytsev · HighLoad++ 2017