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?

已提問 5 年前檢視次數 635 次
2 個答案
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).

已回答 4 年前
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)

MrK
已回答 5 年前

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

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

回答問題指南