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?

asked a year ago643 views
2 Answers
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
MODERATOR
philaws
answered a year ago
  • 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
MODERATOR
philaws
answered a year 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