Move RDS MySQL 5.6.40 database to Aurora Serverless
We have a MySQL 5.6.40 running in RDS for a while now. We are looking to move it to Aurora Serverless to take advantage of the compute and storage scaling features.
The plan was to take a snapshot of our production MySQL 5.6.40 and restore in Aurora. However, it looks like the snapshot method of migrating to Aurora Serverless will not work for MySQL 5.6.40 as described in this document.
What is the best approach to achieve this in the shortest time?
In this type of scenario since restoring a MySQL 5.6.40 to an Aurora Serverless isn't supported.
An option would be to use the mysqldump utility to back up MySQL 5.6.40 database, then restore it into an existing Aurora Serverless Cluster.
You can use the mysqldump  utility to create a database backup in either SQL or delimited-text format. Once you have created the dump you can load it onto the instance using the mysqlclient or by using a third party tool such as MyLoader.
You should do a test run with each format in a non-production environment to see which method minimises the amount of time that mysqldump runs. As it will depend largely on the size of the database.
The steps I took to move MySQL from RDS to Aurura Serverless is as follows:
Backup the RDS production instance.
Migrate RDS to Aurora Read Replica instance and promote to master. This is the intermediary instance.
Take a snapshot of the Aurora Read Replica instance.
Restore the snapshot to Aurora Serverless. This is configured to 1 capacity unit at minimum and 32 capacity units at maximum.
Delete the intermediary instance after taking a snapshot (optional).
Best practices for migrating MySQL RDS to Aurora ServerlessAccepted Answerasked 3 years ago
AWS RDS Aurora MySql Serverless: ft_min_word_len is not being recognizedasked 2 months ago
moving rds aurora serverless from Public subnet to private subnet within same VPCasked 2 days ago
Migrating from RDS MariaDB 10.2 to Aurora MySQL 5.6Accepted Answerasked 3 years ago
Migration from Aurora to Aurora Serverless?Accepted Answerasked 3 years ago
Are there difficulties migrating from Aurora MySQL to Aurora ServerlessAccepted AnswerMODERATORasked 2 years ago
TLS 1.2 + Aurora Serverless MySqlAccepted Answerasked 2 years ago
Move RDS MySQL 5.6.40 database to Aurora Serverlessasked 3 years ago
(Serverless) Amazon Aurora MySQL 1 end of life on February 28, 2023asked 2 months ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago