PrepZone Logo
PrepZone
Back to Database

Database · Hard

How do you run schema migrations with zero downtime? Explain expand-contract.

DatabaseAdministrationStaffSchema Design

Answer preview

A zero-downtime migration keeps the old and new schema valid at the same time, so application instances running the previous release and the next one can both read and write during the rollout. The pattern for this is expand-contract (also called parallel change).…