Upgrading AWS MySQL RDS 5.7 to 8.0

Introduction

Upgrading your AWS MySQL RDS instance from version 5.7 to 8.0 can bring significant performance improvements and new features. This comprehensive guide will walk you through the steps to successfully upgrade your MySQL RDS instance to version 8.0.

Preparation Steps

Ensure that the OvalEdge version is updated.
Stop the Apache Tomcat and MySQL RDS services.
Take a snapshot of the RDS instance to create a backup before upgrading.

Upgrade Steps

Assuming that your AWS MySQL RDS instance is currently running on version 5.7, as shown in the screenshot below:

MySQL 5.7 running in RDS

To proceed with the upgrade, follow the steps outlined below.

Open the AWS Management Console and navigate to the RDS service.
Click on the "Actions" button and select "Take snapshot" to create a backup of the RDS instance.

Upgrade RDS Instance

Once the snapshot process is completed, wait for the RDS instance to become available.
Go to the RDS console, select the RDS instance you wish to upgrade, and click on "Modify."
In the modification settings, locate the current MySQL version (5.7) from the DB engine version dropdown and change it to MySQL 8.0.X.
Verify the details you have filled in and click on the "Continue" button. The Summary of Modifications section is displayed with Current and New Values. are displayed.
After reviewing the changes, select "Apply Immediately" and click on "Modify DB Instances."

Confirmation and Verification

Once the RDS instance status is available, confirm the upgraded Engine Version by checking the configuration.
In the RDS console, locate the modified RDS instance and review the Engine Version to ensure it reflects MySQL 8.0.X.
After the RDS has been successfully migrated to MySQL 8.0.X, update the Tomcat server by changing the RDS details in the Oasis properties file.