QMetry App DB Upgrade to MySQL v8.4.8 for 2 Tier RHEL8, RHEL 9, RHEL 10 & Podman

This topic describes how to upgrade the QMetry application database container to MySQL 8.4.8 on a two-tier installation.

In a two-tier installation, the QMetry database container and the QMetry application container run on the same server.

Prerequisites

Before you begin, make sure that you have the following:

  • Confirm that no operations or traffic are running on QMetry.

  • You should have root access on the server that hosts the QMetry database container and the QMetry application container.

  • The QMetry_RHEL_Installer.zip file from QMetry Support.

  • You should have enough free disk space in the `/opt` directory for the database backup.

Upgrade to the MySQL 8.4.8 database container

Note

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

  1. Backup your existing QMetry Database.

    Important

    Back up the QMetry database before you upgrade. You need the backup to recover if the upgrade fails.

    podman exec qmetry_rds_1 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 10. 
    podman exec qmetry_rds_1 sh -c 'exec mysqldump-uroot-pqmetry--triggers--routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_2021-01-01.sql


    Make sure your database is backed up correctly and available for recovery if needed.

  2. Copy the QMetry_RHEL_Installer.zip file to the server that hosts the containers. Go to the directory that contains the file, and then unzip it.

    unzip QMetry_RHEL_Installer.zip

  3. Switch to the root user and run the upgrade script.

    cd QMetry_RHEL_Installer
sudo su
chmod +x upgrade.sh
./upgrade.sh

  4. On the main installation menu, type 1 to upgrade QMetry Database.

    QMetry_Upgrade_Menu.png

  5. Configure the following parameters.

    Options

    Default Value

    Description

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

    Y

    Enter “Y”.

    Enter the name of the 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

    Enter “Y”.

    Enter the name of QMetry's database container

    qmetry_rds_1

    Enter the QMetry Database container name.

Steps to upgrade QMetry to the latest version

Follow the document QMetry Upgrade Guide for RHEL8, RHEL9 and Podman (from QMetry v8.16.0.1 and above) to upgrade to the latest version

Clean up data from the MySQL 5.7.28 container

Refer to this section only after performing the steps mentioned in the Steps to upgrade to MySQL v8.4.8 DB Container and Steps to upgrade QMetry to the latest version sections above.

This is an optional step to perform, but we recommend you follow it in order to clean up the residual components and, hence, free up some disk space on the server.

Note

The old QMetry database container and all associated data will be permanently removed once you perform these clean up steps. This action is irreversible.

Before you begin, ensure that the QMetry upgrade is successful, and the data has been fully restored. Once everything has started functioning properly, only then proceed with these steps.

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

Get Support

If you encounter any issues during the migration process, please get in touch with QMetry Support for assistance.

In this section:
© 2026
Publication date: