MySQL Forums
Forum List  »  Router & Proxy

MySQL proxy Issue in load balancing
Posted by: sujeet singh
Date: January 18, 2016 12:44PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL proxy Issue in load balancing
2440
January 18, 2016 12:44PM


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.