I would like to inquire about the Maxscale2.21 connector version.
When going through maxscale in WAS, an error called Unknown system variable 'tx_isolation' occurs. My guess is that it is caused by a difference in the connector version used in maxscale, so is it possible to change the connector version in maxscale? (mysql 8. version transaction_isolationmysql 5.7 tx_isolation) maxscale version is using version 2.21, and for db, mysql version 8. I'm using . If it is not possible to change it, what version should I use to solve the problem?
Answer Answered by Markus Mäkelä in this comment.
Can you give the exact MaxScale version you are using? 2.21 is not a valid MaxScale version.
MaxScale does not set tx_isolation by itself but if you are referring to a problem in your application, you can use the regexfilter module to modify the SQL to use transaction_isolation instead of tx_isolation.
