Attempting to upgrade mysql serverless from 5.7->8, but no options exist in Engine Version dropdown
Hello! I have a Aurora Serverless v1 cluster, and AWS is telling me to upgrade it to v2 for mysql 8 (to avoid extended support charges)... but when I MODIFY it and expand the "Engine Version" field, I don't see a v2 option... I only see the selected v1 option.
There is a comment on the page "To see more versions, modify the capacity types." I have upped them to 8 capacity units, but still no change:
How do I do the update if I can't select the new version?
FYI I'm trying to upgrade it to Aurora MySQL 3.08.1 (compatible with MySQL 8.0.39)
Any help is greatly appreciated! Cheers, Roger
- Newest
- Most votes
- Most comments
The issue you're experiencing is because Aurora Serverless v1 only supports MySQL 5.7 compatibility and cannot be directly upgraded to MySQL 8.0 or Aurora Serverless v2. This is why you're not seeing any other options in the Engine Version dropdown.
To upgrade from Aurora Serverless v1 (MySQL 5.7 compatible) to Aurora Serverless v2 (MySQL 8.0 compatible), you'll need to follow a migration process rather than an in-place upgrade. Here are the general steps you should follow:
-
Create a new Aurora Serverless v2 cluster with MySQL 8.0 compatibility.
-
Migrate your data from the old Aurora Serverless v1 cluster to the new Aurora Serverless v2 cluster. This can be done using several methods:
- Using AWS Database Migration Service (DMS)
- Creating a snapshot of your v1 cluster and restoring it to a new v2 cluster
- Using MySQL dump and load tools
-
After migrating and thoroughly testing your application with the new cluster, you can switch your application to use the new Aurora Serverless v2 cluster.
-
Once you've confirmed everything is working correctly, you can decommission the old Aurora Serverless v1 cluster.
This process allows you to upgrade to MySQL 8.0 compatibility and take advantage of the improvements in Aurora Serverless v2, including better scaling and performance characteristics.
Remember to thoroughly test your application with the new version before switching over, as there may be some compatibility changes between MySQL 5.7 and 8.0 that could affect your application.
Sources
RDS Aurora Upgrade - No option to create Blue/Green deployment | AWS re:Post
Unable to upgrade from Aurora MySQL 2 | AWS re:Post
Hello.
You can migrate from Aurora Serverless v1 to v2 by following the steps in the document below.
In the procedure, we switch back from Aurora Serverless to the provisioning cluster.
After returning to the provisioning cluster, migrate to Aurora Serverless v2.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.upgrade.html#aurora-serverless-v2.upgrade-from-serverless-v1-procedure
