How to upgrade AWS RDS Aurora MySQL 5.6 to 5.7

amazon-web-services amazon-rds-aurora
Satish Gadhave picture Satish Gadhave · Feb 7, 2018 · Viewed 11.4k times · Source

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.

Answer

sciorms picture sciorms · Feb 7, 2018

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

Related questions

AWS Aurora MySQL serverless: how to connect from MySQL Workbench

I was trying to use AWS Aurora Serverless for MySQL in my project, but I am impossible to connect to it, though I have the endpoint, username, password. What I have done: From AWS console managment, I select RDS > …

Read More
Amazon RDS Aurora vs RDS MySQL vs MySQL on EC2?

I've been looking around for best practices when setting up your database on the cloud but it still isn't clear to me which of the following solutions should we be going for? Amazon RDS Aurora Amazon RDS MySQL MySQL on …

Read More
AWS Aurora: The MySQL server is running with the --read-only option so it cannot execute this statement

I am getting this error when executing a GRANT statement on my Aurora DB instance in AWS: The MySQL server is running with the --read-only option so it cannot execute this statement My user is not read-only though, so why …

Read More