- Knowledge Base
- Installation and System Setup
- Installation
-
Roadmap
-
Knowledgebase Documents
-
Installation and System Setup
-
Setup Data Catalog
-
Connectors
-
Data Discovery
-
Self Service
-
Access Management
-
Data Quality
-
Data Literacy
-
Privacy Compliance
-
Reporting
-
Architecture, Security & Releases
-
Developer's Zone
-
Advanced Tools
-
Record of Processing Activities (ROPA)
-
Others
-
Release6.0 User Guide
-
Release6.1 Features
-
Data Catalog
-
News
-
Deactivated_Old
-
Release6.3 Deep Dive Articles
OvalEdge Application Upgrade from MySQL 5.7 to 8.0
This article 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).
Copyright © 2024, OvalEdge LLC, Peachtree Corners, GA USA