From single MySQL instance to HA

" summary

Shows how to evolve a MySQL deployment from a single MySQL instance through asynchronous replication (source/replica) and InnoDB ReplicaSet to a fully automated InnoDB Cluster HA setup. Covers limitations of single instance, async replicas, and ReplicaSet, and explains migration steps between these architectures aimed at minimizing downtime.

AI-written summary · about

" related talks

• 54mThe Evolution of a MySQL Database, From a Single Instance to HA With Disaster RecoveryFrederic Descamps · Percona Live 2022
• 57mThe Evolution of a MySQL Database SystemFrederic Descamps · DevClub.lv 114th Frontend focused event
• 24mComparing the High Availability of MySQL with Modern Distributed SQL DatabasesRon Xing · Distributed SQL Summit Asia 2023
• 42mHigh Availability and Disaster Recovery Made Easy With MySQL InnoDB ClusterSetLeonardo Bacchi Fernandes · Percona Live 2022
• 51mMariaDB Scaling - From Single Instance to Multiple ClustersMichal Kuchta · Percona Live 2022
• 35mMySQL HA, Recovery and Load BalancingDavey Shafik · SunshinePHP 2014
• 27mDistributed MySQL Architectures: Past, Present and FuturePeter Zaitsev · Distributed SQL Summit 2019
• 05mMySQL failover with orchestrator and ProxySQLKedar, Yunus Shaikh · Percona Live 2022