Zero Downtime MySQL Migrations — Here's How GitHub Does It (Enter gh-ost)
Have you ever had a MySQL schema migration bring your production database to a grinding halt? Even GitHub struggled with outages and massive replication lag caused by traditional, trigger-based migration tools.
Learn how they built gh-ost, a revolutionary triggerless solution that brought their replication lag down to sub-second levels and turned "impossible" migrations into unnoticeable ones.
In this video, the database infrastructure team introduces gh-ost, GitHub's open-source, online schema migration tool for MySQL
Key Highlights:
The Problem with Triggers: Why traditional schema change tools cause competing locks and can bring high-traffic services to a grinding halt.
The Binary Log Solution: How gh-ost hooks into the binlog stream to apply changes sequentially and asynchronously, without burdening the master.
Production Testing: How GitHub builds trust by safely running full test migrations on real production replicas before ever touching the master database.
Dynamic Control & ChatOps: How engineers can throttle, pause, reconfigure, and explicitly cut over migrations on the fly using chat commands.
Sub-Second Lag: See the actual graphs of how gh-ost successfully migrated GitHub's notoriously difficult "nemesis" table with completely unnoticeable replication lag.
Hashtags:
#MySQL
#DatabaseMigration
#GitHub
#DBA
#DevOps
#OpenSource
#TechTalk
#HighAvailability
#DatabaseEngineering
#SchemaMigration