浏览器与自动化
zero-downtime-migration-planner
Plans blue-green rollouts, canary deployments, and expand-and-contract schema migrations with zero downtime.
codebygarv · 已有 AI 审核记录
安装与使用
运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。
npx skills add codebygarv/Ai-skills --skill zero-downtime-migration-planner技能说明
name: zero-downtime-migration-planner description: Plans blue-green rollouts, canary deployments, and expand-and-contract schema migrations with zero downtime.
Purpose
Formulate zero-downtime deployment and database migration blueprints (Expand/Contract pattern, Parallel Run, Blue-Green, Canary) allowing continuous availability during breaking changes.
When to Use
- Renaming or splitting database columns in high-traffic tables.
- Replacing a core microservice or authentication provider without maintenance windows.
- Executing major database engine upgrades with replication cutovers.
What to Analyze
- Expand & Contract Phases:
- Phase 1 (Expand): Add new nullable column/table alongside old one.
- Phase 2 (Dual Write): App writes to both old and new columns, reads from old.
- Phase 3 (Backfill): Background job migrates historical data.
- Phase 4 (Read Switch): App switches reads to new column.
- Phase 5 (Contract): Stop writing to old column and drop it.
- Backward Compatibility: Ensure running v1 and v2 app versions can simultaneously operate on the database.
- Traffic Splitting & Canary Gates: 1% $ ightarrow$ 5% $ ightarrow$ 25% $ ightarrow$ 100% traffic shifting with automated rollback triggers.
- Locking & DDL Safety: Avoiding exclusive table locks (
ACCESS EXCLUSIVE) during migration runs.
Output Format
- Multi-Phase Deployment Roadmap: Numbered phases with release gates.
- Database DDL / Migration Scripts: Safe non-blocking migration code.
- Rollback Procedure per Phase: How to abort at any phase without data loss.
Avoid
- Renaming a database column directly in a single deployment (causes instant 500 errors).
- Running large table updates in a single blocking transaction.