RDS MySQL 8.0.29 version is deprecated. Could not do upgrade or modify anything.



Just a month ago RDS MySQL DB engine was upgraded to version 8.029. Now I want to increase the storage of my database. When I checked the "Modify" of the database, it displayed:

Minor version 8.0.29 has been deprecated. We recommend upgrading to the latest applicable minor version

There are no other DB engine versions are displayed in the list to upgrade or downgrade. Could not select DB instance class, and storage type. I want to increase database storage, but it also does not display any list as well. Database storage is going to be full soon. I could not do anything to my database.

Any help will be appreciated?


1 Answer

Dear Customer, Thanks for reaching out to us via AWS re:Post. I just saw this post and checked with my peers and found the below info. The minor version MySQL 8.0.29 release has been deprecated and that’s the reason that you couldn’t find the version in the list any more. At this point, recommendation is for customers that have visible symptoms of a crash we recommend they do a Point-In-Time-Restore (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html ) to recover the database. Please accept my sincere apologies on behalf of AWS for the inconvenience caused by this. When the new version is released and available on RDS we’ll inform you and the rest of our AWS community on our announcements page here: https://aws.amazon.com/new/ If you would like to downgrade your instance to version 8.0.28, below options are available: Using Native MySQL import export tool:

You can use tools like mysqldump/Mydumper/Myloader to import and migrate from existing RDS MySQL instance on 8.0.29 to another instance on 8.0.28 version. Please kindly review the below documentation for more details: [+] Importing data from a MySQL or MariaDB DB to a MySQL or MariaDB DB instance - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.SmallExisting.html [+] Importing Data to an Amazon RDS MySQL or MariaDB DB Instance with Reduced Downtime - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html Using AWS Database Migration Service:

Please use the below resources to get more familiar with DMS working and settings before getting stared with the service: [+] Migrate to an Amazon RDS or Aurora MySQL DB instance using AWS DMS: https://aws.amazon.com/premiumsupport/knowledge-center/migrate-mysql-rds-dms/ [+] What is AWS Database Migration Service? - https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html [+] How AWS Database Migration Service works - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.html

Hoping I was able to assist

answered 2 years 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