MySQL Forums
Forum List  »  Router & Proxy

error message with keepalive script
Posted by: Amr Hamdy
Date: August 27, 2007 05:39PM

Hello,
I start mysql-proxy as follows;
mysql-proxy --proxy-address=:3306 --proxy-backend-addresses=192.168.99.244:3306 --proxy-read-only-backend-addresses=192.168.99.243:3306 --proxy-lua-script=examples/tutorial-keepalive.lua


Then I establish a connection to the proxy froma remote host;
mysql -h 192.168.99.222 -P3306 -uroot -ppassword

the connection got established successfully;
then I run a simple query "show databases;"

I get errors and the proxy says the following;
network-mysqld-proxy.c.3420: (connect_server) examples/tutorial-keepalive.lua:65: attempt to get length of field 'servers' (a nil value)
(read_query) examples/tutorial-keepalive.lua:166: attempt to get length of field 'servers' (a nil value)
network-mysqld-proxy.c.2815: I have no server backend, closing connection
network-mysqld.c.1161: plugin_call(CON_STATE_READ_QUERY) failed
network-mysqld-proxy.c.3722: (disconnect_client) examples/tutorial-keepalive.lua:257: attempt to get length of field 'servers' (a nil value)



I don't get such errors when I use the examples/tutorial-basic.lua script and queries could be run nicely .. but all queries go to the main backend not to the read-only backend at all ..


with the keepalive script when I establish the connection I could see that it established a connection to the main backend only and not to the read-only backend too ...

Options: ReplyQuote


Subject
Views
Written By
Posted
error message with keepalive script
6781
August 27, 2007 05:39PM
2606
August 28, 2007 07:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.