Re: Proxy pool member. How to...?

[vox huang]

-- when I try to connect to mysql-proxy in a loop it looks like round robin balancing not happening at all and only the first member of the group gets all connections. Do I have to do any special configuration changes to allow load balancing?
---------------------------------------------------------------------------------
I have the same question.I run mysql-proxy like this,
LUA_PATH="/usr/local/tools/mysql-proxy/trunk/lib/?.lua" mysql-proxy --proxy-backend-addresses=192.168.0.7:3306 --proxy-read-only-backend-addresses=192.168.0.8:3306 --proxy-read-only-backend-addresses=192.168.0.6:3306 --proxy-lua-script=/usr/local/tools/mysql-proxy/trunk/lib/rw-splitting.lua --daemon

I send 800 queries to mysql-proxy from 4 clients.The most queries are send to 192.168.0.8,only a few queries are send to 192.168.0.6