Cannot upgrade from mysql 8.0.34 to aurora-mysql 8.0.mysql_aurora.3.04.1. Specify a current active database version, the latest active minor version for mysql 8.0 is 8.0.35.

0

Hi all, I am trying to create an Aurora MySQL 8 instance for a RDS MySQL database and I am getting this rather confusing error message. I choose snapshot, select Action->Migrate snapshop and then I cannot fill anything into the DB engine version on the Migrate database page, but i can select Serverless v2. The RDS myql is on version 8.0.34 and Aurora does not seem to support more than migrating from 8.0.32 if you look at release notes for Aurora 3.05.1 https://docs.aws.amazon.com/AmazonRDS/latest/AuroraMySQLReleaseNotes/AuroraMySQL.Updates.3051.html The error message seems to indicate migration is supported for 8.0.35, so i tried upgrading the db to that, but then i just get the same error again. Cant figure out how to ever migrate to Aurora, but i guess i could turn off minor upgrades on the current database and then wait for the next Aurora version to maybe support 8.0.35. Any better ideas? /Soren

asked 4 months ago491 views
3 Answers
0
Accepted Answer

So end the end I paused minor updates and then finally after some months Aurora MySQL caught up and now supported the version that i was on with regular RDS MySQL and i could easily migrate using a snapshop. I think this is the best way for someone that can wait a few months.

answered 24 days ago
0

To add to Regina's:

Aurora MySQL version 3.05 does not support migrating from some older MySQL 8.0 versions like 8.0.11, 8.0.13, and 8.0.15. The documentation recommends upgrading to MySQL 8.0.28 before migrating.

Even though the error message mentions 8.0.35, it's possible the underlying issue is still related to migrating from an older incompatible version. I would double check the actual MySQL version on the source instance.

Minor version upgrades can sometimes cause compatibility issues, even within the same major release. It may be better to avoid upgrading just the minor version and instead upgrade to a newer major release like 8.0.28 as recommended.

If upgrading isn't an option, another approach would be to take a snapshot of the source database, restore it to a new Aurora MySQL cluster, and then use that as the target of the migration rather than trying to migrate directly.

Checking the AWS documentation thoroughly for specific version compatibility between your source MySQL version and the target Aurora MySQL version being migrated to can help identify potential issues.

profile picture
EXPERT
answered 24 days ago
  • Hi Giovanni,

    How to "take a snapshot of the source database, restore it to a new Aurora MySQL cluster"? When I tried to restore a snapshot, there's no option to restore it as Aurora MySQL cluster. Thank you.

0

If you need to migrate asap, I could say there is another approach. It is to use a database migration tool like AWS Database Migration Service to migrate the schema and data independently of the instance itself. This bypasses the version compatibility check. You could take a snapshot of the RDS instance, restore it locally with the same version, and use a tool to migrate the data/schema to a new Aurora cluster.

AWS
Regina
answered 3 months ago
profile picture
EXPERT
reviewed 24 days 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