Steps to Upgrade MySQL to v8.0.40

Pre-requisites

MySql version of QMetry Reports and QMetry Application should be 8.0.33.
Ensure that QMetry is not in use and there are no ongoing operations or traffic on QMetry.
Please ensure that docker is authenticated in case of Online installation.

Steps to upgrade MySQL to v8.0.40

In case of Offline Installation

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

Download and restore the QMetry Database Image

Download the Container Image of QMetry or Report DB
Perform the following steps on a machine with internet access to download the container image:
- Log in to the container repository. If you do not have the credentials, contact QMetry Support.
```
docker login
```
- Download and save the QMetry Database container image by executing these commands:
```
docker pull qmetry/qmetry:appdb8040
docker pull qmetry/qmetry:reportdb8040 
docker images
docker save -o qmetrydb.tar qmetry/qmetry:appdb8040
docker save -o reportdb8.tar qmetry/qmetry:reportdb8040 
ls
```
- Transfer the qmetrydb.tar, reportdb8.tar file to the host server where the installation will take place.
Restore the Container Image of QMetry DB
Restore the container image on the target machine where the installation will be carried out:
- If you are logged in as the "root" user, execute the following command. If not, skip this step:
```
sudo su
```
- Navigate to the directory containing the qmetrydb.tar,reportdb8.tar file and load the container image with the following command:
```
docker load -i qmetrydb.tar
docker load -i reportdb8.tar
```
- Verify that the container images have been restored correctly by executing:
```
docker images
```

Step 1: IMPORTANT: Backup Your Existing QMetry Database

Before proceeding, back up existing “qmetry” database. Adjust the username, password, and backup file location as needed (default location is /opt).

docker exec qmetryapp_db sh -c 'exec mysqldump -uroot -p<password> --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_<date>.sql

Example 14.

docker exec qmetryapp_db sh -c 'exec mysqldump -uroot -pqmetry --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_2023-01-01.sql

Step 2: Stop QMetry Services

Stop QMetry app and report containers.

docker stop qmetry_app_1
docker stop qmetry-reports

Step 3. Extract AppDBUpgrade.zip.

Copy the AppDBUpgrade.zip file received from QMetry Support to the server hosting the QMetry database container. Navigate to the directory containing the file and execute the following command:

Unzip and Navigate to the AppDBUpgrade directory
```
unzip AppDBUpgrade.zip
cd AppDBUpgrade 
```
Grant execute permissions and run the upgrade script:
```
chmod 777 dbupgrade.sh
./dbupgrade.sh
```
Once the script starts executing, it will prompt you to enter the following parameters:
Options
Details
Default Value
Example
Enter QMetry database password for root user
Enter QMetry Application Database Password for the root user.
-
QMetry@123

Options	Details	Default Value	Example
Enter QMetry database password for root user	Enter QMetry Application Database Password for the root user.	-	QMetry@123

Step 4: Upgrade the Report Database:

Copy the ReportDBUpgrade.zip file received from QMetry Support to the server hosting both report and report-database container. Navigate to the directory containing the file and execute the following command:

Unzip and Navigate to the ReportDBUpgrade directory
```
Unzip ReportDBUpgrade.zip
cd ReportDBUpgrade
```

Grant execute permissions and run the upgrade script:

chmod 777 dbupgrade.sh
./dbupgrade.sh

Once the installation initiates, it will prompt you to enter the following parameters:

Options	Details	Default Value	Example
Enter Report database password for root user	Enter password for QMetry Reports Database.	-	QMetryreports@!Nf0#
Enter Report database schema	Enter Database schema name for QMetry Reports Database.	qtmanalytics	qtmanalytics

Step 5: Restart QMetry Services:

Start the QMetry app and report containers.

docker start qmetry_app_1
docker start qmetry-reports