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

Pre-requisites

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

Steps to Upgrade to MySQLv 8.0.40 Report DB Container

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:

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.

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

docker pull qmetry/qmetry:reportdb8040
docker images
docker save -o reportdb8.tar qmetry/qmetry:reportdb8040
ls

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:

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
```
Navigate to the directory where the reportdb8.tar file is placed. Then execute the following command.
```
docker load -i reportdb8.tar
```
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.40. Finally, the backed-up data will be restored into the new MySQL v8.0.40 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.

Note

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 QMetry Reports Upgrade from v8.11.2 and above to upgrade to the latest version.

In this section: