By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Moving from Aurora to RDS Instance

0

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.

Topics
Migration & ModernizationAnalyticsDatabase
Tags
AWS Database Migration ServiceAmazon Relational Database ServiceDatabaseAmazon AuroraAurora MySQL
Language
English
Olive
asked 3 months ago417 views
1 Answer
1
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.

profile picture
EXPERT
Riku_Kobayashi
answered 3 months ago
profile pictureAWS
EXPERT
Didier_Durand
reviewed 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content