Database Migration Strategies: Zero-Downtime Deployments for Production Systems

Video Description

Learn how to deploy database schema changes to production without downtime, data loss, or breaking active customer transactions. This video covers the expand-contract pattern, dual writes, and blue-green deployments—the exact techniques used by GitHub, Stripe, and other companies to safely migrate production databases. You'll discover why databases require fundamentally different deployment strategies than application code, how to handle schema changes on tables with billions of rows, and the critical steps that prevent irreversible data corruption. Topics Covered: • Why database migrations are fundamentally different from code deploys • The expand-contract pattern: expand, migrate, contract • Implementing dual writes to keep old and new schemas in sync • Backfilling historical data without locking production tables • Blue-green deployment strategies for instant rollback • Database versioning with Flyway and Liquibase • Real-world case studies: GitHub's MySQL migration and Stripe's sharding expansion • Common pitfalls: table locks, replication lag, and foreign key traps • When to use expand-contract vs. blue-green vs. dual-write strategies • Production-ready checklist for safe schema changes Whether you're splitting a column, adding indexes to billion-row tables, or migrating between database systems entirely, this video gives you the patterns and confidence to execute migrations safely. 🎯 Next Steps: Ready to see how these principles apply to replacing entire systems? Watch the Strangler Fig pattern deep dive to learn how to gradually replace monoliths without big-bang rewrites. Timestamps: 0:05 Database Migration Strategies 0:38 The Database Migration Problem 1:06 Why Databases Are Different 1:37 The Expand-Contract Pattern 2:11 Expand-Contract Example: Splitting a Column 2:46 Phase 2: Migrate (Dual Write) 3:19 Phase 2: Backfill Historical Data 3:50 Phase 3: Contract (Remove Old Schema) 4:21 Dual Writes: Keeping Systems in Sync 4:57 Dual Write Implementation 5:31 Blue-Green Database Deployments 6:04 Database Versioning Tools 6:34 Real-World: GitHub's MySQL Migration 7:11 Real-World: Stripe's Document Database Migration 7:46 Best Practices 8:21 Common Pitfalls 8:52 When to Use Each Strategy 9:28 Key Takeaways 10:03 Implementation Checklist