Updating the MySQL Connector

Updating the MySQL Connector

The highest supported version of MySQL that the Percussion supports for this install/upgrade is MySQL 5.7.  There are still several open issues that block upgrade / install with MySQL 8.0.  These will be addressed in future updates.   

The main actions that you need to take when upgrading in a MySQL installation are:

Pre-Upgrade

  • If you are running MySQL 5.5 or 5.6 you should upgrade to MySQL 5.7 prior to upgrading CM1.  This will enable several MySQL improvements, including changes to limitations on the size of indexes in the database, and security updates.
  • Download the latest 5.x MySQL Java Connector from the MySQL website and replace the mysql-connector.jar deployed in your Percussion install with the "bin" version of the jar included in the download archives. 

The installer uses a predefined name for the MySQL Connector jar (mysql-connector.jar) and on upgrade will move the jar to the correct locations(s).

Pre-Upgrade Locations for the MySQL Connector

CM1: AppServer/server/rx/lib/mysql-connector.jar

DTS: Deployment/Server/lib/mysql-connector.jar

The MySQL Connector package contains 2 jars, which one do I use?

After downloading the latest connector from the MySQL website and unzipping the archive, there will be two jar files in the unzipped folder (minor version may be different): 

  • mysql-connector-java-5.1.49-bin.jar
  • mysql-connector-java-5.1.49.jar

The correct jar is the mysql-connector-java-5.1.49-bin.jar.  So on Linux pre-upgrade we would run:

cp /path/to/mysql-connector-java-5.1.49-bin.jar <installDir>/AppServer/server/rx/lib/mysql-connector.jar

and

cp /path/to/mysql-connector-java-5.1.49-bin.jar <installDir>/Deployment/Server/lib/mysql-connector.jar

and is Staging DTS is installed:

cp /path/to/mysql-connector-java-5.1.49-bin.jar <installDir>/Staging/Deployment/Server/lib/mysql-connector.jar

I'd like to use a Linux Package Manager like yum or apt to keep this up to date, how would that work?

You can use a system package manager to keep the jar up to date, just be sure that the 5.1.x version is installed.  You would then use a symbolic link from mysql-connector.jar in the above locations to the copy of the jar maintained by your systems package manager.

Post Upgrade Steps

During the upgrade, the system will modify the backend database schema with new changes and indexes.  The latest version of the MySQL Connector supports new attributes including support for SSL/TLS encryption of the connection to the MySQL Server. 

For CM1, the options used on the connection string are now controlled by editing the following file:

<InstallDir>/jetty/base/etc/perc-ds.properties

Connection string parameters can be changed / added by editing the properties in this file. 

For DTS, the options used on the connection string are unchanged in this release, and can be modified by editing the Deployment/Server/conf/perc/perc-datasources.properties file.