High Availability and Disaster Recovery Made Easy With MySQL InnoDB ClusterSet
summary
MySQL InnoDB ClusterSet (requires MySQL 8.0.27+, metadata 2.1+) uses MySQL Shell automation to build a DR topology: run configure instance, create cluster, create cluster set, then create replica cluster to clone and wire up async replication; switchover is a single command while failover is manual and can lose recent transactions. Requirements: single‑primary source, unique server IDs/UUIDs, same server versions. Clone plugin is used for fast initial sync and performs well.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:06What is ClusterSet
- 11:16Requirements
- 16:13Deploy
- 20:51Replica
- 24:53Deployment
- 25:36Switchover
- 27:38Failover
- 34:18Incremental Recovery
- 37:43Super Read Only
related talks
57mThe Evolution of a MySQL Database System
29mThe State of the Dolphin
46mDatabase Reliability Engineering for MySQL
24mComparing the High Availability of MySQL with Modern Distributed SQL Databases
14mThe State of the Art of MySQL Replication
38mIs Percona XtraDB Cluster Right for Any Application
35mMySQL HA, Recovery and Load Balancing
35mRunning MySQL on Kubernetes [I]