The Evolution of a MySQL Database System
summary
Shows a concrete migration path: single MySQL instance to backups plus binary log for point‑in‑time recovery lowering RPO from days to minutes, then InnoDB ReplicaSet for minute‑scale RTO, then InnoDB Cluster for seconds RTO and RPO zero, and ClusterSet for cross‑data‑center disaster recovery. Demonstrates MySQL Shell Admin API, MySQL Router, cloning for fast provisioning, GTID and binlog streaming, and the three‑node minimum for automatic failover; numbers and commands are shown and the deployments run end‑to‑end.
AI-written summary · about
chapters (9)
- 0:00MySQL evolution journey
- 3:01Single MySQL instance
- 8:48Reliability with backups
- 14:53Point-in-time recovery
- 20:12MySQL replica sets
- 28:13High availability with InnoDB Cluster
- 42:12Disaster recovery with ClusterSet
- 49:18MySQL 8.1 and 8.2 features
- 56:50Q&A
related talks
54mThe Evolution of a MySQL Database, From a Single Instance to HA With Disaster Recovery
42mHigh Availability and Disaster Recovery Made Easy With MySQL InnoDB ClusterSet
29mThe State of the Dolphin
46mDatabase Reliability Engineering for MySQL
50mMySQL 8.0 at 4. Where are we now?
27mDistributed MySQL Architectures: Past, Present and Future
53mMySQL DevOps
40mImproving Observability, Reliability, and Security of Relational Database...