Database Migration Runbook

Procedures for migrating databases, expanding storage, and schema changes.

Storage Expansion

# Expand PVC
kubectl edit pvc mysql-data-mysql-0 -n dev
# Increase storage size

# Verify expansion
kubectl exec mysql-0 -n dev -- df -h /var/lib/mysql

Schema Migration

Use Flyway or Liquibase for schema versioning.

MySQL to Oracle Migration

  1. Export MySQL data

  2. Convert schema

  3. Import to Oracle

  4. Switch database.type in values

  5. Deploy

Backup Before Migration

kubectl exec mysql-0 -n dev -- \
  mysqldump -uroot -p --all-databases > backup.sql

Full runbook includes detailed migration steps and rollback procedures.