Upgrading MySQL on Linux

You can upgrade to a newer version of MySQL on the connected Linux server on which Unified Manager is installed to obtain fixes for security vulnerabilities. For any minor upgrade, the base version of MySQL must be 8.0.20 or later. If the installed version of MySQL on your system is earlier than 8.0.20, the Unified Manager 9.7 upgrade process automatically upgrades MySQL to 8.0.20. You must not run a standalone upgrade of MySQL from an earlier version to 8.0.20.

Before you begin

Note: Manual upgrade of MySQL is applicable for internet-connected systems only. If the installed version of MySQL on your system is 5.7, then you must not attempt to directly upgrade MySQL to version 8.0.20. It results in application data loss.
You must have root privileges for the Linux system on which Unified Manager is installed.

About this task

You can upgrade the base version of MySQL 8.0.20 to later versions for only minor updates.

Procedure

  1. Log in as a root user on the Unified Manager host machine.
  2. Download the latest MySQL Community Server .rpm bundle on the target system.
  3. Untar the bundle to a directory on the target system.
  4. You get multiple .rpm packages in the directory after untarring the bundle, but Unified Manager only needs the following rpm packages:
    • mysql-community-client-8.0.20
    • mysql-community-libs-8.0.20
    • mysql-community-server-8.0.20
    • mysql-community-common-8.0.20
    • mysql-community-libs-compat-8.0.20
    Delete all other .rpm packages. However, installing all packages in an rpm bundle does not cause errors.
  5. Stop the Unified Manager service and the associated MySQL software in the order shown: systemctl stop ocieausystemctl stop ociesystemctl stop mysqld
  6. Invoke the upgrade of MySQL by using the following command: yum install *.rpm
    *.rpm refers to the .rpm packages in the directory where you downloaded the newer version of MySQL.
  7. Start Unified Manager in the order shown: systemctl start mysqldsystemctl start ociesystemctl start ocieau