RDS MySQL engine version 5.7.36 deprecated/missing

0

I have an RDS instance using MySQL engine version 5.7.36. RDS recommends updating to a newer minor 5.7 engine version, but no versions are available to choose when modifying the instance. describe-db-engine-versions doesn't list 5.7.36, but does list 5.7.34 and 5.7.37, and newer versions after that. Snapshots taken from the instance cannot be restored, because creating a new instance using the version the snapshots specify is not allowed.

5.7.36 is still documented on https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Concepts.VersionMgmt.html as supported until April 2023. As far as I can see there are no notifications that it's deprecated.

There was a Health notification in January of impending end of support but no indication of this behavior:

Starting March 20, 2023 00:00:01 AM UTC, you will not be able to create new RDS instances with MySQL minor versions 8.0.27, 8.0.26, 8.0.25, 8.0.23, 5.7.36, 5.7.34 and 5.7.33 from either the AWS Console or the CLI. We recommend you to upgrade your databases before April 20, 2023. RDS will upgrade your MySQL databases running minor versions 8.0.27, 8.0.26, 8.0.25, 8.0.23, 5.7.36, 5.7.34 and 5.7.33 as well as any instances restored from the snapshots of these versions to the latest minor version during a scheduled maintenance window between April 20, 2023 00:00:01 UTC and May 20, 2023 00:00:01 UTC. On May 20, 2023 00:00:01 AM UTC, any MySQL databases running minor versions 8.0.27, 8.0.26, 8.0.25, 8.0.23, 5.7.36, 5.7.34 and 5.7.33 that remain will be automatically upgraded to the latest minor version by RDS regardless of instances’ scheduled maintenance window.

So, upgrades should be available until April 20, and even today new instances should still be able to be created with these versions. Every other version listed in the notification is still currently available, except 5.7.36.

To me this indicates an error or mistake on the part of AWS. What are my options here?

2개 답변
1

It is not clear what the issue is that is preventing you from upgrading. But you should be able to use the AWS Cli to request the upgrade. I am showing here that there are several versions available for you to upgrade your instance to. hth.

aws rds describe-db-engine-versions --engine mysql --include-all --filters Name=status,Values=deprecated --engine-version 5.7.36 --query "DBEngineVersions[*].ValidUpgradeTarget[*].{EngineVersion:EngineVersion}" --output text
5.7.37
5.7.38
5.7.39
5.7.40
5.7.41
8.0.23
8.0.27
8.0.28
8.0.32
AWS
중재자
philaws
답변함 일 년 전
  • Thanks, yes, the API does still allow the upgrade. But there doesn't seem to be any reason why the web console shouldn't list those upgrade options, which seems to be the case across multiple instances that use 5.7.36. Is it simply that the console doesn't list any upgrade options if what you're on currently is deprecated? That doesn't seem like it would be right.

0

I agree. We are looking into it. thanks,

AWS
중재자
philaws
답변함 일 년 전

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

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

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