Maxscale not allowed to connect mysql8 with java application

Question

I have a mysql 8.0.3 database over top of that maxscale server is running when i tried to connect with that mysql jdbc driver this error is coming unknown system variable 'query_cache_size'. But when i tried to connect directly to database is working for me. query_cache_size parameters removed from mysql 8.

Answer 1

Edit: With MXS-2890 fixed, you should now be able to configure version_string=8.0.16-mysql in MaxScale to solve this problem

---

This is most likely caused by the following bug: https://jira.mariadb.org/browse/MXS-2890

The MariaDB JDBC connector should not suffer from this problem which means installing it instead of the MySQL JDBC connector can be used as a workaround.

Answer 2

In your /etc/maxscale.cnf you can add version_string=5.6

[Read-Write-Service]
type=service
router=readwritesplit
servers=master
version_string=5.6
user=user
password=********```

after that i am  able to access mysql8 on top of maxscale server.