How do I coordinate a zero-loss schema migration with dual-writing on a live table?
Instead of a blocking ALTER TABLE on 20M rows run expand/contract: add nullable columns, dual-write, backfill in throttled batches, then drop the old.
Tag
Continuous integration and delivery: the path from test to production, automated. questions under this tag, answered directly. (Page 2/2)
12 answered questions carry this tag.
Instead of a blocking ALTER TABLE on 20M rows run expand/contract: add nullable columns, dual-write, backfill in throttled batches, then drop the old.
Drop query-string busting: cache content-hashed filenames as immutable, keep the HTML short-lived, and upload the assets before you cut over.