Docker and CI/CD · Senior · Question 43 of 75
Why run heavy data migrations separately from the deploy?
- 1Databases accept schema changes only during maintenance windows
- ✓Correct answer: Long locks or backfills can block traffic and stall the rollout
- 3Migration tools can't run inside the CI/CD pipeline at all
Explanation
Adding an index or rewriting a big table can lock it. Use online techniques (concurrent indexes, batched backfills) and keep deploys quick and reversible.