Moving from Aurora to RDS Instance

Question

Hello team,

I would like to move my Aurora mysql to an RDS mysql instance. Is it possible to use a snapshot of the write instance to spin up the new rds instance? I saw a post referring to using dms as the only option that can be done from AWS, I would like to confirm this and also get directions on how to use DMS if it is the only option to achieve this.

Accepted Answer

Hello.

It is not possible to restore RDS MySQL from a snapshot of RDS Aurora.  
Only RDS Aurora or Aurora Serverless can be restored from RDS Aurora snapshots.  
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-restore-snapshot.html

As you know, it is possible to migrate data from RDS Aurora to RDS MySQL using AWS DMS.  
You must select Aurora MySQL as the source database and specify RDS MySQL as the target database.  
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Sources.html  
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.MySQL.html

If you can secure a certain period of time when the service is stopped, one method is to use mysqldump to obtain a dump file and migrate the data to RDS MySQL.

Moving from Aurora to RDS Instance

Contenido relevante