Best Practices for MySQL High Availability in 2022

on YouTube ↗52m

" summary

Concrete recommendations and measurable tradeoffs: prefer ProxySQL for rich routing and multiplexing, prefer InnoDB Cluster (MySQL 8.0) or Galera variants (Percona XtraDB Cluster, MariaDB Galera) for virtually synchronous multi-master, require three-node quorum, expect multi-AZ/DRBD setups to cut worst-case throughput by up to ~60%, use semi-synchronous replication (used at Facebook since 2014) to avoid data loss, enable sync_binlog=1 and innodb_flush_log_at_trx_commit=1, and use the MySQL clone plugin or XtraBackup/MariaBackup for fast provisioning and SST.

AI-written summary · about

" chapters (9)

1. 0:00Start
2. 3:42Modern Versions of Mysql and Mariadb
3. 9:18Group Commit
4. 22:35Using Multi-Threaded Slaves
5. 23:28Time Delayed Replication
6. 29:19Parallel Replication
7. 30:11Gtid Migration
8. 30:42Schema Parallel Replication
9. 50:47Conclusion

" related talks

• 35mMySQL HA, Recovery and Load BalancingDavey Shafik · SunshinePHP 2014
• 24mComparing the High Availability of MySQL with Modern Distributed SQL DatabasesRon Xing · Distributed SQL Summit Asia 2023
• 32mBest Practice in Design and Implementing MySQL Geographic Distributed, High Availability SolutionsMarco Tusa · Percona Live Online 2020
• 53mMySQL DevOpsV. Fedorkov, A. Raspopina · DevOps Pro Moscow 2019
• 46mDatabase Reliability Engineering for MySQLMatthias Crauwels · Percona Community Live 2022
• 27mDistributed MySQL Architectures: Past, Present and FuturePeter Zaitsev · Distributed SQL Summit 2019
• 14mThe State of the Art of MySQL ReplicationRicky Setyawan · FOSSASIA Summit 2017
• 49mMySQL Replication — Advanced FeaturesPetr Zaytsev · HighLoad++ 2017