Does expand-and-contract guarantee a zero-downtime migration?
No. Locks, backfills, replication lag, long transactions, application bugs and data inconsistency can still cause an outage. The approach improves compatibility but must be paired with database-specific lock analysis, bounded backfills, metrics, rehearsal and a tested rollback or forward-fix plan.
Answered in
A Safer Database Rename Takes Three DeploymentsExpand-and-contract migrations keep old and new application versions compatible while a schema changes, but they require observability and a rollback plan.
Read the full analysisOther questions this article answers
More databases questions
- What is an expand-and-contract migration?
- Why not rename a database column in one deployment?
- What is MariaDB Enterprise Platform 2027?
- What does the 56 percent throughput number measure?
- Does the release mean one database should run every workload?
- Is PostgreSQL 19 generally available?
- Can PostgreSQL 19 replace an existing major version in place?
- Which PostgreSQL 19 features should operators test?
Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the Databases beat.