Migrating Meta to MySQL 8.0
summary
Meta migrates ~1,700→2,400 patches onto MySQL 8.0, rebasing yearly and dropping ~700 patches while keeping MyRocks and InnoDB running simultaneously; migration uses logical MySQL dump first copy then XtraBackup, plus shadow testing and automated copy/promote phases to achieve no downtime live promotion. Surprising failures include JSON semantic drift, collation and reserved-keyword breakage, optimizer plan regressions, InnoDB corruption on clones, and unexpected XA/binlog incompatibilities.
AI-written summary · about
chapters (23)
- 0:00Start
- 4:16Json Compatibility
- 11:05Error Codes
- 12:23Automation Validation
- 12:43Reserved Keywords
- 13:25Testing Pipeline
- 14:27Types of Data Correctness
- 16:55Replication Setup Validation
- 24:33Next Steps Monitoring
- 24:47Slow Query Logs
- 25:37Replication Traffic Statistics
- 26:16Client Errors
- 26:34Core Dumps
- 28:50Oracle Fixed Locking
- 30:04Failability Issues
- 33:51Performance Issues
- 35:31Deadlock Contention Issues
- 35:53Deadlock Detection
- 36:39Encrypted Bin Logs
- 37:54Read-Only Database
- 42:09Do You Get More Insight from the New Performance Schema
- 47:00Backups
- 48:45Ever Plan To Open Source that Shadow Db Plugin
