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

What's the best way to migrate from MySQL 8.0.33 on RDS to Aurora Serverless V2 cluster?

0

My research indicates this will be a multi-step process, starting with making a Read Replica, which is failing.

It appears that the latest version of Aurora only supports up to MySQL 8.0.32, but I have had my "Auto apply minor version upgrade" set to "Yes", so my MySQL version keeps outpacing Aurora. Do I need to turn off that setting and then just wait until they release an Aurora version that is compatible with MySQL 8.0.33? I assume that could take months. Is there any quicker way to get from MySQL RDS to Aurora Serverless?

Also, as part of this process, I need to make sure my provisioned storage is reduced. We deleted many GiB of data from our database but can't lower the storage setting on the MySQL instance. I need to make sure we are not paying for all that extra storage on the Aurora cluster.

Topics
AnalyticsDatabase
Tags
Amazon AuroraAurora MySQL
Language
English
JoeJErnst
asked a year ago670 views
1 Answer
0

Hello.

AWS doesn't support version downgrades, so I think it's best to wait until MySQL 8.0.33 is supported.
I think it is possible to use other methods such as mysqldump or AWS DMS to move data from a MySQL 8.0.33 RDS instance to a MySQL 8.0.32 RDS instance and migrate to Aurora Serverless, but verification is required. I think this will take some time as well.

profile picture
EXPERT
Riku_Kobayashi
answered a year ago
profile pictureAWS
EXPERT
Didier_Durand
reviewed a year 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