Why Database Migrations Need Expansion and Contraction
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations Hosted by Fexingo
Database schema changes are inevitable, but altering a live table with millions of rows can lock it for hours and take down your service. In this episode, Lucas and Luna dive into the expand-and-contract pattern, the technique that lets teams change schemas without downtime by running dual writes, backfilling, and switching reads in phases. They walk through a real-world example: a checkout table in an e-commerce system moving from one address column to separate fields, showing how each step keeps the system available and consistent. They also discuss why tools like gh-ost and pt-online-schema-change exist, what happens when you skip the backfill, and why the migration itself is the easy part while the coordination is the hard part. If you've ever dreaded a big ALTER TABLE, this episode gives you a concrete playbook to do it safely. #DatabaseMigrations #ExpandAndContract #SchemaChange #ZeroDowntime #OnlineSchemaChange #DualWrites #Backfill #DatabaseEngineering #SQL #NoSQL #DataStorage #TechPodcast #FexingoBusiness #BusinessPodcast #DataEngineering #SoftwareArchitecture #ghost #ptosc Keep every episode free: buymeacoffee.com/fexingo
Embed this episode
No transcript yet.