Move RDS MySQL 5.6.40 database to Aurora Serverless

The steps I took to move MySQL from RDS to Aurura Serverless is as follows:

1. Backup the RDS production instance.

2. Migrate RDS to Aurora Read Replica instance and promote to master. This is the intermediary instance.

3. Take a snapshot of the Aurora Read Replica instance.

4. Restore the snapshot to Aurora Serverless. This is configured to 1 capacity unit at minimum and 32 capacity units at maximum.

5. Delete the intermediary instance after taking a snapshot (optional).

Hi,

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 [1] 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.

/MrK

[1] https://dev.mysql.com/doc/refman/5.6/en/mysqldump.html (https://dev.mysql.com/doc/refman/5.6/en/mysqldump.html)