MySQL proxy Issue in load balancing

[sujeet singh]

I have installed MySQL-Proxy (mysql-proxy-0.8.5-windows-x86-32bit) on my windows server (64 Bit Windows Server 2008 R2) and have tried to do the roud-robin load balancing. For this is have provided two proxy-backend-addresses in the configuration file but I have observed that It only connect the first mysql server and did not forward the load on the second mysql server.

I am also not able to connect the proxy admin. I provide the following command to connect the proxy admin:

`mysql -h 198.xx.xxx.xxx -u admin -p admin -P 4041`

Below is mysql-proxy configuration files. I run the mysql-proxy on the DOS command prompt using the following command:

`mysql -uroot -h198.xx.xxx.xxx -p -P 4040`

mysql-proxy configuration files:

[mysql-proxy]
--daemon=true
--proxy-address=198.xx.xxx.xxx:4040
--log-file="C:\Program Files\MySQL\mysql-proxy\log\mysql-proxy.log"
--admin-lua-script="C:\Program Files\MySQL\mysql-proxy\lib\mysql-proxy\lua\admin.lua"
--admin-address=198.xx.xxx.xxx:4041
--admin-username=admin
--admin-password=admin
--log-level=debug
--plugins=proxy
--plugins=admin
--proxy-backend-addresses=198.xx.xxx.xxx:3306
--proxy-backend-addresses=198.xxx.xxx.xx:3307
--proxy-lua-script="C:\Program Files\MySQL\mysql-proxy\lib\mysql-proxy\lua\proxy\rw-splitting.lua"
--keepalive=true

Can anyone please help on this and suggest where I did mistake.