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.

preguntada hace 6 meses481 visualizaciones
1 Respuesta
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
EXPERTO
respondido hace 6 meses
profile pictureAWS
EXPERTO
revisado hace 6 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas