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

Migrate RDS MySQL 8.0.28 to Aurora MySQL

1

Hi, it seems Aurora MySQL supports up to MySQL 8.0.23. I'd like to migrate a 2TB database from RDS MySQL 8.0.28 to Aurora MySQL. What's the best practice to do this migration quickly and without losing data or having downtime?

1 Answer
0

Hello, The best approach at the moment is to use a 2 step approach to migrate from MySQL to Aurora Serverless.

Step 1 - Is migrate to Aurora provisioned through a read replica https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Replica.html

Step 2 - Is migrate from Aurora provisioned to Aurora Serverless from a snapshot https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.restorefromsnapshot.html

Let me know if this is helpful and click accept answer !!

SUPPORT ENGINEER
answered 2 months ago
  • Hi, unfortunately this is not possible. I want to migrate from RDS MySQL to Aurora MySQL (not serverless). I tried creating an Aurora read replica from the RDS instance, but it fails, saying that MySQL 8.0.28 is not supported in Aurora (docs also say that it supports only up to 8.0.23).

    So it seems that any version above MySQL 8.0.23 cannot be upgraded from RDS to Aurora?

    Any help will be appreciated. Thank you.

  • I am facing the same problem. I am looking for a solution to this problem.

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