Search code examples
javamysqlmysql-connectorsinglestore

Error connecting to memsql with mysql J connector

I have memsql server version 6.7. I am able to connect to it using mysql java connector version 5.1.47 from my spring boot application.

But when i upgrade connector version to 8.0.16 I get below error - Caused by: java.sql.SQLException: Unknown system variable 'performance_schema'

Ran query SHOW VARIABLES; on my memsql instance and I do not see system variable 'performance_schema'.

Can i change datasource.url string to ignore this variable? Any other latest version of driver is supported?

Solution

  • If your concern is the security issue in the 8.0.15 mysql driver you could use the mariaDb drivers instead. We generally recommend folks use them with MemSQL: https://docs.memsql.com/client-downloads/

    MySQL 8 made a number of breaking changes (i.e., you will have issues with MySQL 8 drivers connecting to older versions of MySQL as well : https://bugs.mysql.com/bug.php?id=90994)