Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to upgrade AWS RDS Aurora MySQL 5.6 to 5.7

Tags:

We are using AWS RDS Aurora MySQL 5.6 for our production database. AWS launched MySQL 5.7 compatible Aurora engine on 6th Feb, 2018.

I dont see any option in "modify instance" to change engine to MySQL 5.7 I dont see any option in restore snapshot to database with MySQL 5.7 either.

We want to do this upgrade with least downtime. Pls suggest what could be done here.

like image 288
Satish Gadhave Avatar asked Feb 07 '18 18:02

Satish Gadhave

People also ask

What is the latest version of Aurora MySQL?

The current LTS releases for Aurora MySQL are the following: Aurora MySQL version 2.07. *. For more details about this version, see Aurora MySQL database engine updates 2021-11-24 (version 2.07.

Can I control if and when MySQL based RDS instance is upgraded to new supported versions?

You control when to upgrade your DB instance to a new version supported by Amazon RDS. This level of control helps you maintain compatibility with specific database versions and test new versions with your application before deploying in production.

Is AWS Aurora compatible with MySQL?

Amazon Aurora is designed to be compatible with MySQL so that existing MySQL applications and tools can run without requiring modification.

1 Answers

According to this link, you cannot upgrade an in-place database, you will need to restore a snapshot of the existing database and change the engine version during that process. These restrictions appear to be only temporary and may be lifted at a later point to allow for in-place upgra

like image 200
sciorms Avatar answered Sep 18 '22 17:09

sciorms
Sign in to Comment

Related questions

FCM HTTP V1 API returns 404 for unregistered token
Providing a C API to your C++ library and strict aliasing
How to add report_tensor_allocations_upon_oom to RunOptions in Keras
Running airflow tasks/dags in parallel
Which Android versions run which Java versions?
Chrome autofills username into random text input
Is there any way to run parallel cypress tests on local machine, for example 5 streams
How to copy/clone records in C# 9?
"naming to docker.io", explanation and prevention?
Why would concurrency using std::async be faster than using std::thread?
Rails Caching DB Queries and Best Practices
Silverlight Crossdomain

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!