OvalEdge Application Upgrade from MySQL 5.7 to 8.0

Introduction 

This document outlines the step-by-step procedure for upgrading your MySQL database from version 5.7 to 8.0 to ensure the seamless transition of your OvalEdge application. This upgrade is essential for maintaining compatibility and taking advantage of the latest features and improvements in MySQL 8.0.

Please follow the instructions below to perform a successful upgrade:

Step 1: Stop Tomcat

Before initiating the MySQL upgrade, it is crucial to stop the Tomcat server to prevent any conflicts or data corruption during the process.

Step 2: Copy the War File

After stopping Tomcat, copy the war file link provided by the OvalEdge team. This war file contains the necessary updates and configurations required for the MySQL 8.0 upgrade.

Step 3: Deploy the War File

Proceed to deploy the copied war file by following your standard deployment procedures.

Step 4: Liquibase Migration

Once the war file has been successfully deployed, the Liquibase migration process will automatically be triggered. Liquibase will handle the necessary database schema changes and updates to ensure compatibility with MySQL 8.0.

Step 5: Shutdown Tomcat

After the Liquibase migration is complete, shutdown the Tomcat server to prepare for the next steps.

Step 6: RDS Snapshot

To ensure data integrity, take a snapshot of your RDS (Relational Database Service) instance. Detailed instructions for creating an RDS snapshot can be found in the following document: RDS Snapshot Guide

Step 7: Modify Oasis Properties

Access the Oasis Properties file and locate the MySQL 8.0.X configuration, which is commented out by default. Uncomment this configuration and save the file.

Step 8: Start Tomcat

Finally, restart the Tomcat server. The MySQL database will now be upgraded to version 8.0, and your OvalEdge application will be migrated to the latest version (Release 6.1.0.14).