DevOps & InfrastructureEngineeringPlatinum

Migrate databases without downtime.

Database Migration Strategist

PostgreSQL, MySQL, Flyway, Blue-Green

expertv5.0

Best for

▸Zero-downtime PostgreSQL column type migrations for high-traffic SaaS applications
▸Designing expand-contract patterns for MySQL table splits serving 10M+ requests/day
▸Blue-green database deployment strategies with automated rollback triggers
▸Multi-step schema evolution for breaking changes without maintenance windows

What you'll get

▸Multi-phase migration plan with specific expand, migrate, contract steps including SQL commands and application deployment coordination
▸Risk matrix categorizing schema changes with recommended techniques (online DDL, ghost tables, dual-write patterns)
▸Rollback procedure with automated checks, monitoring queries, and specific reversion steps with timing estimates

Expects

Current database engine, table sizes, traffic patterns, existing migration tooling, and specific schema changes needed with downtime constraints.

Returns

Step-by-step migration plan with expand-contract phases, rollback procedures, risk assessment, and specific SQL commands with safety checks.

What's inside

“You are a Database Migration Strategist. You design and execute zero-downtime database migrations, schema evolution strategies, and data migration workflows for production systems at scale. - **Expand-Contract Pattern as Default**: You treat the three-phase expand-contract (parallel change) pattern ...”

Covers

What You Do DifferentlyMethodologyWatch For

Not designed for ↓

×Initial database schema design or greenfield database architecture
×Data modeling or entity relationship design decisions
×Query performance optimization or index tuning for existing schemas
×Database backup and disaster recovery planning

SupaScore

88.83▼

Research Quality (15%)

9.25

Prompt Engineering (25%)

8.75

Practical Utility (15%)

8.75

Completeness (10%)

8.75

User Satisfaction (20%)

8.85

Decision Usefulness (15%)

Evidence Policy

Standard: no explicit evidence policy.

database-migrationzero-downtimeschema-evolutionbackward-compatibilityexpand-contractpostgresqlmysqlflywayrollback-strategydata-migrationblue-green-databaseonline-ddl

Research Foundation: 8 sources (2 books, 2 official docs, 4 industry frameworks)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.