TechnicalCollectible prompt

Zero-downtime database migration plan

Plan a schema change that ships safely, with backfills, checks, and rollback steps.

ClaudeChatGPTClaude Code

Curated by Nvoka

Nvoka wordmark logo
Nvoka wordmark logoTechnical

Zero-downtime database migration plan

Act as a database reliability engineer. Plan this schema change: {{schema_change}} Database engine and version: {{database_engine}} Table sizes and traffic: {{table_sizes_and_traffic}} Downtime we can accept: {{downtime_tolerance}} Return: 1. The main risks: locks, long backfills, replication lag, and old application code meeting the new schema 2. An expand-and-contract rollout where old and new application code both work at every step 3. The SQL for each step, with batched backfills and suggested batch sizes 4. Checks to run before and after each step 5. A rollback path for each step, and the point after which rolling back gets harder 6. What to monitor during and after the change Explain any engine-specific locking behavior you rely on, and flag anything I should rehearse on a copy of production data first.
Technicalnvoka.com/library/nvoka-zero-downtime-database-migrationScan to open
Technical

Zero-downtime database migration plan

Plan a schema change that ships safely, with backfills, checks, and rollback steps.

Nvoka logo

Curated by Nvoka

ClaudeChatGPTClaude Code
Add to my library

Make it yours

Fill in the blanks and change any word. Only your copy changes, never the card.

Fill in the blanks

0 of 4 filled

Your prompt

Act as a database reliability engineer. Plan this schema change: {{schema_change}} Database engine and version: {{database_engine}} Table sizes and traffic: {{table_sizes_and_traffic}} Downtime we can accept: {{downtime_tolerance}} Return: 1. The main risks: locks, long backfills, replication lag, and old application code meeting the new schema 2. An expand-and-contract rollout where old and new application code both work at every step 3. The SQL for each step, with batched backfills and suggested batch sizes 4. Checks to run before and after each step 5. A rollback path for each step, and the point after which rolling back gets harder 6. What to monitor during and after the change Explain any engine-specific locking behavior you rely on, and flag anything I should rehearse on a copy of production data first.
See all