How we migrated our database to the cloud
summary
A postmortem of migrating a production MySQL database to the cloud after an unexpected minor MySQL upgrade caused failures during a company offsite. It describes the outage symptoms, root cause analysis of the MySQL version change, and the steps taken to move the database into a cloud environment to restore reliability.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:52Company and infrastructure
- 3:17Why we chose cloud
- 5:26Minor update consequences
- 10:13Night support issues
- 11:18Table migration problems
- 15:13Monitoring and support lessons
- 15:34Noisy neighbor problem
- 18:04Geo-distributed database issues
- 20:09Hot cloud switchover
- 23:19Cloud settings differences
- 24:46Future plans and conclusions
- 26:33Q&A
related talks
27mMurdering our Mongo Database (or how we migrated to a relational database)
32mMySQL on the Cloud: a Journey from Virtual Machines to Serverless Deployments
40mCloud Databases: Pros and Cons
48mReducing Risk Before Upgrading MySQL
41mDemocratizing MySQL: From Cloud Managed to Kubernetes Managed
19mMove to the Cloud with Zero Downtime
57mThe Evolution of a MySQL Database System
51mMySQL in the Cloud