MySQL Forums
Forum List  »  Router & Proxy

have problem in use mysql-proxy admin
Posted by: h ch
Date: November 22, 2009 09:31PM

i installed lua ,and download mysql-proxy-0.7.2-linux-rhel5-x86-32bit.tar.gz
cp mysql-proxy to /usr/local,and i start mysql-proxy with follow command

mysql-proxy --proxy-read-only-backend-addresses=172.16.20.210:3306 --proxy-backend-addresses=172.16.1.19:3306 --admin-username=root --admin-password=12345 --admin-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/admin.lua --proxy-lua-script=/usr/local/mysql-proxy/share/doc/mysql-proxy/rw-splitting.lua > /var/log/mysql-proxy/mysql-proxy.log &

and /usr/local/mysql-proxy/share/doc/mysql-proxy/admin.lua is the lua script that i download from http://forge.mysql.com/tools/tool.php?id=198 and when i login in the admin port use

mysql -uroot -p -h172.16.1.19 -P4041
Enter password: 12345
and still have problem in query

Your MySQL connection id is 1
Server version: 5.0.99-agent-admin

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from backends;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: *** NONE ***

ERROR 1105 (07000): need a resultset + proxy.PROXY_SEND_RESULT

why?,seems lack something

Options: ReplyQuote


Subject
Views
Written By
Posted
have problem in use mysql-proxy admin
6828
November 22, 2009 09:31PM
4499
November 23, 2009 09:13PM
2794
November 23, 2009 09:16PM
2812
November 23, 2009 09:23PM


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.