Multi-Site, Multi-Master Done Right

on YouTube ↗35m

" summary

Continuent’s stack uses a local HA cluster plus an asynchronous cross-site replicator to run multi-site, multi-master MySQL with no application changes, zero-downtime maintenance and production deployments across continents. The connector sits on app servers to hold sessions and route reads/writes during automated master promotion; the replicator ships events into a THL (transaction history log) for optional parallel apply and filtering. Demo topology: San Jose ↔ New York clusters, SSL in flight, autoincrement offset or UUID keys to avoid collisions.

AI-written summary · about

" chapters (16)

1. 0:00Intro
2. 3:49Synchronous multi-master clusters claim to deliver on the dream
3. 6:53Continuent Clustering: HA, DR and Performance Scaling
4. 9:54Continuent SmartScale provides session load balancing
5. 12:09Load Balancing (Routing) Methods
6. 14:01Continuent clusters add HA and scaling without taking features away
7. 15:35Continuent clusters automatically monitor all cluster nodes for failure
8. 16:13Cluster rules failover master if DBMS no longer accepts network connections
9. 19:18Zero Downtime Maintenance
10. 21:40Tungsten Replicator Overview
11. 23:55Asynchronous replication decouples transaction processing on master and slave DBMS nodes
12. 25:37Replicator Pipeline with Parallel Apply
13. 28:21Robust Multi Site Replication
14. 29:41Cross Site Recovery
15. 30:40Requirements (very few!)
16. 32:36Continuent Disaster Recovery creates composite clusters that span sites and are ready for immediate failover

" related talks

• 41mCase Study: Deploying a Multi-Region, Highly Available MySQL ArchitectureGabriel Ciciliani · LISA17
• 35mMigrating a live site across the country without downtimeDrew Blas · MountainWest RubyConf 2013
• 54mThe Evolution of a MySQL Database, From a Single Instance to HA With Disaster RecoveryFrederic Descamps · Percona Live 2022
• 51mMariaDB Scaling - From Single Instance to Multiple ClustersMichal Kuchta · Percona Live 2022
• 43mMySQL Failover for Asynchronous replication with Orchestrator, ProxySQL and ConsulYunus Shaikh · Percona Live 2022
• 24mComparing the High Availability of MySQL with Modern Distributed SQL DatabasesRon Xing · Distributed SQL Summit Asia 2023
• 35mMySQL HA, Recovery and Load BalancingDavey Shafik · SunshinePHP 2014
• 15mMany Faces of Continuent TungstenM C Brown · Percona Live Open Source Database Conference Europe 2017