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

질문됨 4달 전594회 조회
3개 답변
0
수락된 답변

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.

답변함 한 달 전
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
전문가
답변함 한 달 전
  • 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
답변함 4달 전
profile picture
전문가
검토됨 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠