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

Move RDS MySQL 5.6.40 database to Aurora Serverless

1

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.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Import.html

What is the best approach to achieve this in the shortest time?

asked 3 years ago78 views
2 Answers
1

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).

answered 3 years ago
0

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)

answered 3 years 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