Mysql 8.0.29 issues (version disappear)

1

Hello there, I have created mysql rds instance with mysql 8.0.29, but now it's says that this version is deprecated, and I can't upgrade instance, or change something via UI (only some actions over API works).

Enter image description here

Also not possible to change storage type (over UI or API): Enter image description here

Any ideas how it can be fixed, without instance re-creation?

2 Answers
0

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:

  1. 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

  1. 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

Hope this helps in your project.

AWS
EXPERT
answered 2 years ago
  • Hello, Why the minor version MySQL 8.0.29 release has been deprecated? There is no information about this on the MySQL or AWS pages.

0

Dear Customer - there was an issue found with this version, for more details pertaining to it and w.r.t. your RDS instance I would request you to kindly log a case with premium Support AWS RDS Team..

AWS
EXPERT
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