...
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Steps to upgrade to MySQL v8.0.33 DB Container
Pre-requisite
Ensure that QMetry is not in use and there are no ongoing operations or traffic on QMetry.
...
Copy the QMetryDBUpgrade.zip file received from QMetry Support to the server where both the QMetry DB and Application container are located. Navigate to the directory where this file is kept, and execute the following command.
unzip QMetryDBUpgrade.zip
The following process will create a backup of the data from the MySQL 5.7.28 container. Next, a new container for the database will be set up, running on MySQL v8.0.33. Finally, the backed-up data will be restored into the new MySQL v8.0.33 container.
Step 3. Execute the following commands.
cd QMetryDBUpgrade
sudo su
chmod +x upgradedb.sh
sh upgradedb.sh
Next, the installation process will prompt you with the following questions.
Options | Default Value | Description |
---|---|---|
Do you have QMetry's application container running on this machine? (Y/N) | Y | Mention “Y”. |
Enter the name of QMetry application's container. | qmetry_app_1 | Enter the QMetry application container name. |
Do you have QMetry's database container running on this machine? (Y/N) | Y | Mention “Y”. |
Enter the name of QMetry's database container | qmetry_rds_1 | Enter the QMetry Database container name. |
Note: This process may take time depending on the amount of data in the database.
Steps to upgrade QMetry to the latest version
Follow the document QMetry Upgrade Document for RHEL8 & Podman (to latest version) to upgrade to the latest version.
Clean up data from MySQL 5.7.28 container
Refer to this section only after performing the steps mentioned in the Steps to upgrade to MySQL v8.0.33 DB Container and Steps to upgrade QMetry to the latest version sections above.
...
Cleanup Commands:
Execute the following commands on the server where the QMetry DB container is located.
podman rm qmetry_rds_1
podman volume rm $(podman volume ls -qf dangling=true)
podman image prune -af
If you encounter any issues during the migration process, please generate a support ticket on the Support Portal for assistance.