migration-checklist

Zero-downtime database migration uses dual-write, backfill, and switch phases to move data without service interruption. This skill generates a comprehensive checklist covering pre-migration validation, rollback procedures, monitoring dashboards, and post-migration verification to ensure data integrity and minimize risk.

A migration checklist includes pre-migration validation, backup procedures, data integrity checks (counts and checksums), dual-write setup, backfill execution, switch procedures, documented rollback steps, monitoring dashboards, post-migration verification, and cleanup tasks to guide planning and execution.

Ensure data integrity by performing counts and checksums before and after migration, validating schema changes, executing backups, implementing dual-write verification, and monitoring for discrepancies. This skill provides validation steps and verification procedures to catch issues early.

Yes, this skill applies to schema changes like adding required columns. It covers dual-write strategies, backfill procedures, and switch timing to execute schema migrations with zero or minimal downtime while maintaining data consistency.

The skill generates documented rollback procedures as part of the checklist, detailing steps to revert to the previous state, restore from backups, and restore service. This ensures you can safely recover from failures without extended downtime.