Upgrading the MySQL Version

Session Monitor version, 4.1.0.0.0 supports both MySQL versions, 5.5 and 5.7. If you have upgraded from a previous Session Monitor version, your system will be running MySQL 5.5. To upgrade to MySQL 5.7 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. Run the following command to stop the Session monitor services:

   pld-systemctl stop

3. Upgrade MySQL from the official MySQL documentation.
4. Run the following command to install MySQL compatibility libraries:

   yum install mysql-commercial-libs-compat

5. Run the following command to upgrade the MySQL:

   mysql_upgrade

   Note:

   The upgrade duration depends on the database size.
6. Run the following command to deploy the Session Monitor MySQL 5.7configuration:

   cp /opt/oracle/ocsm/etc/iptego/my-5.7.cnf
   /opt/oracle/ocsm/etc/iptego/my.cnf

7. Run the following command to restart MySQL and Session Monitor services:

   systemctl restart mysqld
   pld-systemctl start