OnCommand Workflow Automation 5.1

Upgrade MySQL on Linux


You can upgrade to a newer version of MySQL on the Linux server on which OnCommand Workflow Automation is installed to obtain fixes for security vulnerabilities.

You must have root privileges for the Linux system on which WFA is installed.

Note Before you reinstall WFA 4.2, you must delete the MySQL data directory if you have uninstalled MySQL.

You can only upgrade to minor updates of MySQL 5.7, for example, 5.7.22 to 5.7.26. You cannot upgrade to major versions of MySQL, for example, version 5.8.

  1. Log in as a root user on the WFA 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 will get multiple .rpm packages in the directory after untarring the bundle, but WFA only needs the following rpm packages:

    • mysql-community-client-5.7.x

    • mysql-community-libs-5.7.x

    • mysql-community-server-5.7.x

    • mysql-community-common-5.7.x

    • mysql-community-libs-compat-5.7.x Delete all other .rpm packages. Installing all packages in an rpm bundle will not cause any problems.

  5. At the shell prompt, stop the WFA database and server services:

    service wfa-db stop

    service wfa-server stop

  6. Invoke the upgrade of MySQL by using the following command:

    rpm -uvh *.rpm

    *.rpm refers to the .rpm packages in the directory where you downloaded the newer version of MySQL.

  7. Start the WFA services:

    service wfa-db start

    service wfa-server start