How One Engineer Handled a Database Migration With Zero Downtime Using Flyway
from The Software Engineering Podcast with Fexingo: Code, Architecture, and Engineering Best Practices Hosted by Fexingo
In episode 76 of The Software Engineering Podcast, Lucas and Luna dive into the story of a senior engineer at a mid-sized e-commerce company who migrated a critical PostgreSQL database from a single instance to a replicated cluster without any downtime. The migration involved 200 GB of data, 50 tables, and a tight deadline. The engineer used Flyway for schema versioning, pglogical for replication, and a careful cutover strategy that included read-only mode, dual writes, and a final switch. They walk through the step-by-step approach, the pitfalls that were avoided (like schema drift and replication lag), and the key lesson: safe migrations are about orchestration, not just tools. If you've ever dreaded a database migration, this episode is for you. #DatabaseMigration #Flyway #PostgreSQL #ZeroDowntime #Engineering #Technology #SoftwareEngineering #pglogical #SchemaVersioning #Ecommerce #DevOps #DataEngineering #Production #MigrationStrategy #Database #FexingoBusiness #TechPodcast #Code Keep every episode free: buymeacoffee.com/fexingo
Embed this episode
No transcript yet.