Move to the Cloud with Zero Downtime
summary
Claims that a zero‑downtime lift‑and‑shift is practical using MariaDB SkySQL and built‑in tools, with several customer migrations proving no end‑user interruption. Steps: provision SkySQL, take a full logical backup using mysqldump/mydumper with binlog and position, restore into SkySQL, enable inbound replication by reading SHOW MASTER STATUS and issuing START SLAVE/replication credentials, then flip hosts using SkySQL’s orchestration command like start replication with --change-external-primary. For very large binlogs use MaxScale + binlog router or AWS DMS to externalize and accelerate replication; war stories report successful cutovers.
AI-written summary · about
chapters (6)
- 0:00Intro
- 1:04An example migration scenario
- 5:43Migration Steps
- 12:20Summary
- 13:09Achieve a successful migration
- 14:51Cloud Migration
related talks
26mSoar Higher With MariaDB SkySQL - The Ultimate MariaDB Cloud
26mThe Evolution of MariaDB: From MySQL to SkySQL
40mMySQL at Scale: Booking MariaDB to MySQL Migration
39mZero-Downtime Rebalancing and Data Migration of a Mature Multi-Shard Platform
37mDatabase Schema Migrations with Zero Downtime
15mModern data platforms: AWS and MariaDB SkySQL
40mCloud Databases: Pros and Cons
28mMove to Managed Databases