II.
SkillArea overview
Reference · liveskill-area:database-migrations-zero-downtime
Zero-Downtime Database Migrations overview
Executing schema changes without downtime: expand/contract patterns, online DDL, lock-aware migrations, dual writes, backfill strategies, and feature-flagged read-path swaps. Covers Postgres (CONCURRENTLY, NOT VALID -> VALIDATE) and MySQL (gh-ost, pt-online-schema-change).
Attributes
displayName
Zero-Downtime Database Migrations
description
Executing schema changes without downtime: expand/contract patterns,
online DDL, lock-aware migrations, dual writes, backfill strategies,
and feature-flagged read-path swaps. Covers Postgres (CONCURRENTLY,
NOT VALID -> VALIDATE) and MySQL (gh-ost, pt-online-schema-change).
domains
requiresStackParts
prerequisiteSkillAreas
expertiseLevels
- intermediate
- expert
Outgoing edges
applies_to1
- domain:devops·DomainDevOps
requires_skill_area1
- skill-area:postgres-tuning·SkillAreaPostgres Performance Tuning
uses_stack_part1
- stack-part:relational-database·StackPartRelational Database
Incoming edges
addresses1
- skill:database-migrations·SkillDatabase Migrations
lib_requires_skill_area21
- lib-agent:code-migration-modernization--data-integrity-validator·LibraryAgentdata-integrity-validator
- lib-agent:code-migration-modernization--database-migration-orchestrator·LibraryAgentdatabase-migration-orchestrator
- lib-process:code-migration-modernization--cloud-migration·LibraryProcessspecializations/code-migration-modernization/cloud-migration
- lib-process:code-migration-modernization--configuration-migration·LibraryProcessspecializations/code-migration-modernization/configuration-migration
- lib-process:code-migration-modernization--data-format-migration·LibraryProcessspecializations/code-migration-modernization/data-format-migration
- lib-process:code-migration-modernization--database-schema-migration·LibraryProcessspecializations/code-migration-modernization/database-schema-migration
- lib-process:code-migration-modernization--documentation-migration·LibraryProcessspecializations/code-migration-modernization/documentation-migration
- lib-process:code-migration-modernization--integration-migration·LibraryProcessspecializations/code-migration-modernization/integration-migration
- lib-process:code-migration-modernization--language-version-migration·LibraryProcessspecializations/code-migration-modernization/language-version-migration
- lib-process:code-migration-modernization--logging-observability-migration·LibraryProcessspecializations/code-migration-modernization/logging-observability-migration
- lib-process:code-migration-modernization--migration-testing-strategy·LibraryProcessspecializations/code-migration-modernization/migration-testing-strategy
- lib-process:code-migration-modernization--performance-optimization-migration·LibraryProcessspecializations/code-migration-modernization/performance-optimization-migration
- lib-process:code-migration-modernization--serverless-migration·LibraryProcessspecializations/code-migration-modernization/serverless-migration
- lib-process:code-migration-modernization--ui-framework-migration·LibraryProcessspecializations/code-migration-modernization/ui-framework-migration
- lib-process:web-development--postgresql-database-design·LibraryProcessspecializations/web-development/postgresql-database-design
- lib-skill:code-migration-modernization--data-migration-validator·LibrarySkilldata-migration-validator
- lib-skill:code-migration-modernization--etl-pipeline-builder·LibrarySkilletl-pipeline-builder
- lib-skill:code-migration-modernization--query-translator·LibrarySkillquery-translator
- lib-skill:code-migration-modernization--schema-comparator·LibrarySkillschema-comparator
- lib-skill:web-development--mongodb·LibrarySkillmongodb
- lib-skill:web-development--postgresql·LibrarySkillpostgresql
prerequisite_for_learning3
- skill-area:zero-downtime-deployment·SkillAreaZero-Downtime Deployment
- skill-area:database-migration·SkillAreaDatabase Migration
- skill-area:backend-data-persistence·SkillAreaBackend Data Persistence
requires_expertise3
- role:database-administrator·RoleDatabase Administrator
- role:fullstack-engineer·RoleFullstack Engineer
- role:backend-engineer·RoleBackend Engineer
requires_skill_area10
- stack-profile:strangler-fig-migration·StackProfileStrangler Fig Migration (TypeScript, NestJS, Express, PostgreSQL, Redis, Docker)
- workflow:database-migration-cutover·WorkflowDatabase Migration Cutover
- workflow:data-warehouse-schema-governance·WorkflowData Warehouse Schema Governance
- workflow:schema-migration·WorkflowSchema Migration
- workflow:cross-team-integration-testing·WorkflowCross-Team Integration Testing
- workflow:database-index-optimization·WorkflowDatabase Index Optimization
- workflow:payment-reconciliation-audit·WorkflowPayment Reconciliation Audit
- workflow:clinical-trial-data-management·WorkflowClinical Trial Data Management
- workflow:schema-migration·WorkflowSchema Migration
- workflow:cross-team-integration-testing·WorkflowCross-Team Integration Testing
stack_part_used_by1
- stack-part:relational-database·StackPartRelational Database