How One Engineer Handled a Database Migration With Zero Downtime Using Flyway

Failed to add items

Sorry, we are unable to add the item because your shopping cart is already at capacity.

Add to basket failed.

Please try again later

Add to wishlist failed.

Please try again later

Remove from wishlist failed.

Please try again later

Adding to library failed

Please try again

Follow podcast failed

Unfollow podcast failed

How One Engineer Handled a Database Migration With Zero Downtime Using Flyway

Listen for free

View show details

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

No reviews yet