Strategies for RDS MySQL migration to Aurora

Question

RDS has automatically upgraded us to MySQL 8.0.30, and Aurora currently only supports migration from 8.0.28.  AWS Support says they can't provide a timeline for 8.0.30 support, and recommends either using DMS (which seems very lacking for this type of migration) or dumping the database and recreating it (difficult for a database in the hundreds of gigabytes range.)

Does anyone have any good strategies for migrating a database of this size to Aurora?

The answer here -- https://repost.aws/questions/QUM2j4BPEQS5CBHVu4QbOLCA/migrate-rds-my-sql-8-0-28-to-aurora-my-sql -- doesn't work, since you can't create an Aurora read replica for unsupported MySQL versions...

Answer

Hello,

Unfortunately, there is NO in-place method available for migrating from RDS MySQL to Aurora for version 8.0.25 and above. Hence, the work-around available currently is to utilize DMS[1] or performing a logical dump[2] as suggested by the AWS support. Alternatively, you can consider waiting for the official support for migrating from MySQL to aurora, you can check the site[3] for any news about latest releases.

[1] https://aws.amazon.com/blogs/database/migrating-from-mysql-to-amazon-aurora-using-aws-sct-and-aws-dms/

[2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html#MySQL.Procedural.Exporting.NonRDSRepl.PrepareSource

[3] https://aws.amazon.com/new/

Strategies for RDS MySQL migration to Aurora

Relevant content