Why Database Schema Changes Need Online Migration Not Downtime

Failed to add items

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

Add to cart failed.

Please try again later

Add to wishlist failed.

Please try again later

Remove from wishlist failed.

Please try again later

Follow podcast failed

Unfollow podcast failed

Why Database Schema Changes Need Online Migration Not Downtime

Listen for free

View show details

Most teams still schedule maintenance windows to add a column or change a table schema, but in production databases with millions of rows, those windows can stretch into hours of downtime. This episode explains why online schema migration tools like gh-ost and pt-online-schema-change are the safer, faster alternative. Lucas walks through the trigger-based and binlog-based approaches, compares lock vs. non-blocking strategies, and breaks down a real case: how a mid-size e-commerce company cut a 4-hour migration to 15 minutes with row-based replication and asynchronous shadow tables. Luna asks the critical questions about rollback safety and performance impact during the copy phase. No clickbait, just the architecture behind zero-downtime schema changes. #DatabaseSchemaMigration #OnlineMigration #MySQL #ghost #ptOnlineSchemaChange #ZeroDowntime #DataMigration #DatabaseOperations #SQL #NoSQL #TechPodcast #DatabaseEngineer #ProductionDatabase #SchemaChange #TechTalk #FexingoBusiness #BusinessPodcast #DatabaseTech Keep every episode free: buymeacoffee.com/fexingo

No reviews yet