by Mark Nielsen
Copyright Dec 2021
AWS: Migration Aurora
The purpose of this is to migration data from a MySQL Master on your own server or
an EC2 server to Aurora.
- Links
- Setting up replication to RDS MySQL or RDS Aurora
- Restore to RDS MySQL or Aurora
- Snapshot RDS MySQL to Aurora
- Setup Master Master replication
- Switchover to AWS Aurora
Links
- https://aws.amazon.com/getting-started/hands-on/migrate-rdsmysql-to-auroramysql/
- https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.html
- https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-mysql-database-to-aurora-mysql.html
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.Other.html
Setting up replication to RDS MySQL or RDS Aurora
Restore to RDS MySQL or Aurora
You have four choices:
- An optional choice to restore to EC2.
- Restore to RDS
- Restore to Aurora
EC2
- Restore using mysqldump
- Restore from Percona innodb Backup.
RDS
You have to restore using mysqldump.
Aurora
- Restore to Aurora from mysqldump
- Restore to Aurora from an RDS MySQL snapshot
- Restore to Aurora from an an RDS Read Replica
Snapshot RDS MySQL to Aurora
This is only if you did not restore to Aurora directly.
Setup Master Master replication
Use these steps to setup replication to EC2, RDS, or Aurora.
Switchover