1. Upgrade Guide
  2. Upgrading MySQL

2 Upgrading MySQL

This chapter provides the instructions for upgrading MySQL from release 5.5.54 to 5.7.10 and from 5.7.10 to 5.7.24.

Upgrading MySQL from Release 5.5.54 to Release 5.7.24

Note:

Session Monitor version 4.4 supports MySQL 5.5.54, 5.7.10, and 5.7.24 versions. If you have upgraded from a previous Session Monitor version, your system will be running MySQL 5.5.

Upgrading MySQL will not create any loss of data. But all the services will be stopped during this upgrade. The upgrade time depends on the size of the database.

Note:

Before upgrading MySQL, configure yum proxies and repos as yum must connect to the configured repos. Refer to "Configuring Proxies and Repos".

To upgrade to MySQL 5.7.24 for the latest performance updates and improvements, perform the following steps in the maintenance window:

  1. Log in to the Session Monitor server console as the root user and run the following command to load the environment variables. 
    source /opt/oracle/ocsm/ocsm_env.sh
  2. Stop the Session monitor services. 
    pld-systemctl stop

  3. From MOS, download the below patch from Patches and Updates section:

    p28822761: MySQL Database 5.7.24 RPM for Oracle Linux / RHEL 7 x86 (64bit)

  4. Download the zip file p28822761_570_Linux-x86-64.zip and place it under /root or any directory on the system.

  5. Unzip the file. 
    [root@ocsm ~]# unzip p28822761_570_Linux-x86-64.zip
  6. Install all the rpms extracted from the zip file. 
    yum install -y mysql-commercial*.rpm
  7. Complete all the MySQL table migrations from release 5.5 to the latest release 5.7.24. 
    mysql_upgrade

    This command may take some time to complete depending on the DB size.

  8. Once complete, run the following command to move MySQL configuration file, my.cnf: 
    cp /opt/oracle/ocsm/etc/iptego/my-5.7.cnf /opt/oracle/ocsm/etc/iptego/my.cnf
  9. Restart the mysqld service. 
    systemctl restart mysqld.service
  10. Start the Session Monitor services. 
    pld-systemctl start
  11. (Optional) Verify the MySQL version installed. 
    mysql --version

Upgrading MySQL from Release 5.7.10 to Release 5.7.24

Note:

Session Monitor version 4.4 supports MySQL versions 5.5.54, 5.7.10, and 5.7.24.

Upgrading MySQL will not create any loss of data. But all the services will be stopped during this upgrade. The upgrade time depends on the size of the database.

Note:

Before upgrading MySQL, configure yum proxies and repos as yum must connect to the configured repos. Refer to "Configuring Proxies and Repos".

To upgrade to MySQL 5.7.24 for the latest performance updates and improvements, perform the following steps in the maintenance window:

  1. Log in to the Session Monitor server console as the root user and run the following command to load the environment variables. 
    source /opt/oracle/ocsm/ocsm_env.sh
  2. Stop the Session monitor services. 
    pld-systemctl stop

  3. From MOS, download the below patch from Patches and Updates section:

    Patch 28822761: MySQL Database 5.7.24 RPM for Oracle Linux / RHEL 7 x86 (64bit)

  4. Download the zip file p28822761_570_Linux-x86-64.zip and place it under /root or any directory on the system.

  5. Unzip the file. 
    [root@ocsm ~]# unzip p28822761_570_Linux-x86-64.zip
  6. Install all the rpms extracted from the zip file. 
    yum install -y mysql-commercial*.rpm
  7. Complete all the MySQL table migrations from release 5.5 to the latest release 5.7.24. 
    mysql_upgrade

    This command may take some time to complete depending on the size of the database.

  8. Restart the mysqld service. 
    systemctl restart mysqld.service
  9. Start the Session Monitor services. 
    pld-systemctl start
  10. (Optional) Verify the MySQL version installed. 
    mysql --version