Upgrading MySQL

You can upgrade to the latest versions of MySQL to Workflow Automation (WFA) on the Linux server. You can upgrade to a newer version of MySQL to get fixes for security vulnerabilities on the Linux server. You can only upgrade to minor updates of MySQL 5.7, such as 5.7.1 to 5.7.2 (but not to 5.8).

Before you begin

You must have root privileges for the Linux system on which you installed WFA.
Note: Before you reinstall WFA 4.2, you must delete the MySQL data directory if you have uninstalled MySQL.

Steps

  1. Log in as a root user on the WFA host machine.
  2. Download the latest .rpm bundle from the Oracle site for your platform.
  3. After downloading the .rpm bundle from the MySQL site, untar it to one of the directories on your target system.

    You will get multiple .rpm packages in your directory after untarring the pack, 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.
  4. At the shell prompt, stop the WFA database and server services:
    • service wfa-db stop
    • service wfa-server stop
  5. Invoke the upgrade of MySQL by using one of the following commands : rpm -uvh *.rpm or <existing content>
    *.rpm refers to the .rpm packages in the directory where you downloaded the newer version of MySQL.
  6. Start the WFA services: service wfa-db startservice wfa-server start