Cloud & Infrastructure Practical By Samson Tanimawo, PhD Published May 2, 2026 4 min read

Database Migration in Cloud: The Three-Phase Rule

Cloud database migrations have specific risks. The three-phase pattern adapted for cloud-native databases.

Three phases

Phase 1: dual-write to old and new. Backfill historical.

Phase 2: dual-read; primary is the new. Old is fallback.

Phase 3: drop old.

Cloud-specific

Use AWS DMS, GCP DataStream, or equivalent for the dual-write.

Verify replication lag during phase 1; production traffic should not see staleness.

Rollback

Phase 1 → drop new tables.

Phase 2 → flip primary back.

Phase 3 → no rollback. Plan accordingly.