MySQL and MySQL compatible migration options at a glance - Amazon Aurora MySQL Migration Handbook

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