How One Engineer Migrated 10 Million Database Records Without Downtime
from The Software Engineering Podcast with Fexingo: Code, Architecture, and Engineering Best Practices Hosted by Fexingo
In this episode, Lucas and Luna dive into a real-world case where a single engineer at a mid-sized e-commerce company migrated over 10 million database records from a legacy MySQL setup to a new PostgreSQL cluster without a second of downtime. The episode walks through the specific strategy used: a dual-write pattern with a backfill worker, careful consistency checks at each stage, and a gradual traffic cutover that took three weeks. Lucas explains why downtime-free database migrations are rare and breaks down the risks, including schema drift and replication lag. Luna asks sharp questions about rollback plans, the role of feature flags, and what happens when the backfill worker falls behind. The hosts also touch on how this approach compares to using a database migration service like AWS DMS or Stripe's online schema change tool. By the end, listeners will understand the trade-offs between safety and speed in zero-downtime migrations and walk away with a clear mental model they could apply to their own systems. #DatabaseMigration #MySQL #PostgreSQL #ZeroDowntime #BackfillWorker #DualWritePattern #FeatureFlags #SchemaMigration #ECommerce #SoftwareEngineering #ProductionDeployment #RollbackPlan #ReplicationLag #EngineeringBestPractices #Technology #FexingoBusiness #BusinessPodcast #TheSoftwareEngineeringPodcast Keep every episode free: buymeacoffee.com/fexingo
Embed this episode
No transcript yet.