QMetry Reports Upgrade to MySQL v8.0.33 Report DB Container (compatible with QMetry v8.14.x & above)

Owned by Mrunalini Potnis
Feb 19, 2024
3 min read

Pre-requisite

  • Ensure that QMetry is not in use and there are no ongoing operations or traffic on QMetry.

Steps

→ In Case of Offline Installation

Follow the steps to download and restore the QMetry Report Database image. After the image is successfully restored, you can then move forward with the next steps.

Download the Container Image of QMetry Report DB.

Follow these steps on a machine where the internet is accessible so that the container images can be downloaded on it.

→ Steps to download the container image of the QMetry Report Database:

1. Execute the following command. Next, it will ask for container repository credentials. Enter the required credentials. If you do not have the credentials, please contact QMetry Support.

  • docker login

After entering container repository credentials, it will show the success message as shown below.

2. Execute the following commands to download and save the QMetry Report Database container image.

  • docker pull qmetry/qmetry:reportdb8

  • docker images

  • docker save -o reportdb8.tar qmetry/qmetry:reportdb8

  • ls

 3. Transfer the reportdb8.tar file to the host server.

 

Restore the Container Image of QMetry Report DB.

Restore the container image of QMetry Report DB on the specific machine where the installation is to be carried out.

→ Steps to restore the container image of the QMetry Report Database:

1. If you are using the "root" user for installation, then execute the following command. If the user is other than the "root" user, skip this step.

  • sudo su

2. Navigate to the directory where the reportdb8.tar file is placed. Then execute the following command.

  • docker load -i reportdb8.tar

 3. Execute the following command to check whether the container images have been restored correctly or not.

  • docker images

Step 1. Extract ReportDBUpgrade.zip

Copy the ReportDBUpgrade.zip file received from QMetry Support to the server where both the QMetry Report DB and Report Application container are located. Navigate to the directory where this file is kept, and execute the following command.

  •  unzip ReportDBUpgrade.zip

The following process will create a backup of the data from the MySQL 5.7.28 container in the same directory where the master_reports.sh script is run. Please ensure there is a sufficient amount of disk space on this location to accommodate reports DB data. 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 2. Execute the following commands

  • cd ReportDBUpgrade

  • sudo su

  • chmod +x master_report.sh

  • sh master_report.sh

Next, the installation process will prompt you with the following questions.

Options

Default Value

Description

Do you have QMetry's report container running on this machine? (Y/N):

Y

 Mention “Y” if QMetry's report container running on the same machine.

Enter name of QMetry report's container (qmetry-reports):

qmetry-reports

Enter the QMetry Report application container name.

Do you have Report's database container running on this machine? (Y/N):

Y

 Mention “Y” if Report's database container running on the same machine.

Enter name of Report's database container (qmetry-reports-db):

qmetry-reports-db

Enter the QMetry Report Database container name.

Note: This process may take time depending on the amount of data in the database.

Step 3. Update Configurations

After the import is complete, it will ask for the input to update the Configurations. Refer to this page for input questions.

Whichever fields have changed (i.e. QMetry App/Report Database Host or Database Ports), enter those updated values in the input fields.

To continue with the old value for a particular field, press the ENTER/RETURN button on the keyboard to skip the input.

Notes: The new Report Database will be accessible on port 3306 by default. As the data is already in the synced state, mention “N” when asked for the force sync.

 

Steps to upgrade Reports to the latest version

Follow the document https://qmetrysupport.atlassian.net/wiki/spaces/QTMSv816/pages/3541053277 to upgrade to the latest version.