使用 AWS re:Post 即表示您同意 AWS re: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.

已提問 1 年前檢視次數 670 次
1 個回答
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
專家
已回答 1 年前
profile pictureAWS
專家
已審閱 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南