When monitoring the MySQL database 8.0.12. mySQL cartridge 5.9.2.1 get the following exception in the agent log
When monitoring with the latest MySQL cartridge against MySQL databases that requires JDBC Connector/J 5.0 driver:
CAUSE 1
The 5.9.2.1 and lower releases of the MySQL cartridge use the 5.1.XX versions of the JDBC Connector/J MySQL driver which is not compatible with MySQL 8 databases.
CAUSE 2
Issue with the mysql-connector-java with MySQL 8.0 and higher on Redhat (RHEL) Operating Systems.
RESOLUTION 1
Workaround
None
Status
The MySQL Connector/J JDBC driver was upgraded to 8.0.12 beginning with MySQL cartridge versions 5.9.3.10.
The MySQL Connector/J JDBC driver for MySQL cartridge version 5.9.4.10 or higher uses MySQL Connector/J 8.0.14
Please download the latest MySQL cartridge from the Downloads area on Supportlink.
Workaround
None
Status
Please download the 5.9.5.22 or higher release of the MySQL cartridge which includes the maria-java-client 2.2.5 driver. The 5.9.5.22 MySQL cartridge is attached to this KB.