How GH-OST Saved Our Deployments
summary
GH-OST is an open-source tool for online MySQL ALTERs that copies data into a ghost table, replays binlog (RAW/ROW) changes, and atomically renames tables to avoid locks and data loss. Bankin’ integrated GH-OST into Flyway, running dry-runs on replicas, throttling the copy phase, and successfully migrated tables of 200–300 million rows (~50–60 minutes), while noting limitations around required binlog mode, foreign keys, triggers, and primary key changes.
AI-written summary · about
chapters (6)
- 0:00Start
- 2:16Problématique
- 4:22Présentation
- 17:07Automatisation
- 19:32Tips, bonnes pratiques
- 22:49Limitations
related talks
16mExperiences using gh-ost in a multi-tier topology
39mZero-Downtime Rebalancing and Data Migration of a Mature Multi-Shard Platform
30mOCI GoldenGate: Elastic, real-time data integration
10mWhy Open Sourcing our Database Tooling was a Smart Decision
47mHigh Availability in GCE
01h 00mLet's Get Scary and Continuously Deploy Database Changes!
33mDatabase Schema Migrations with Zero Downtime
44mDatabase Change Management