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