MySQL and MySQL compatible migration options at a glance
Table 2 — MySQL and MySQL compatible migration options
Source database type | Migration with downtime | Near-zero downtime migration |
---|---|---|
Amazon RDS MySQL |
Option 1 — RDS snapshot migration (recommended) Option 2 — Manual migration using native tools* Option 3 — Schema migration using native tools and data load using AWS DMS |
Option 1 — Migration using Aurora Read Replica (recommended) Option 2 — RDS snapshot migration + binlog replication Option 3 — Schema migration using native tools + AWS DMS for data movement with CDC |
Self-managed MySQL Database |
Option 1 — Migrate using Percona Xtrabackup (recommended) Option 2 — Schema migration with native tools + AWS DMS for data load |
Option 1 — Migrate using Percona Xtrabackup + binlog replication (recommended) Option 2 — Schema migration using native tools + AWS DMS to move data with CDC |
Self-managed MySQL compatible database |
Option 1 — Migrate using native tools (recommended) Option 2 — Schema migration with native tools + AWS DMS for data load |
Option 1 — Migrate using native tools + binlog replication(recommended) Option 2 — Schema migration using native tools + AWS DMS for data movement with CDC |