MySQL-Proxy 0.8.5 in not working with MySQL8.0
Hello,
I am having difficulty using MySQL proxy 0.8.5 with MySQL8.0.
Recently I have upgraded a MySQL setup which was using MySQL 5.6 Master-Slave replication with MySQL Proxy 0.8.5. The proxy would split the read-write requests (SQL statements) between the Master and Slave using LUA scripts. However, after upgrading the MySQL version to 8.0, the java client is not able to execute the following SELECT statement. The client is using mysql-connector-java-8.0.15.jar to connect to the proxy at port 4040. In Wireshark, I see that the proxy is sending the SELECT command to the slave DB which in turn responds with the results, but the proxy does not forward the results back to the client. Also, the read_query_result( inj ) function the in the read-write split Lua does not gets executed.
The SQL command from the client/ connector
/* mysql-connector-java-8.0.15 (Revision: 79a4336f140499bd22dd07f02b708e163844e3d5) */
SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout
Please suggest.
Thank You,
Deb Dutta