MySQL Forums
Forum List  »  Router & Proxy

Re: Proxy pool member. How to...?
Posted by: vox huang
Date: September 11, 2007 12:58AM

-- 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

Options: ReplyQuote


Subject
Views
Written By
Posted
6969
September 10, 2007 05:08PM
3065
September 10, 2007 11:52PM
Re: Proxy pool member. How to...?
3355
September 11, 2007 12:58AM
3237
September 11, 2007 01:35AM
3278
September 11, 2007 02:37AM
3022
September 11, 2007 03:38PM
2872
September 12, 2007 03:42PM
2943
September 12, 2007 05:03PM
2856
September 13, 2007 01:45AM
3055
September 13, 2007 03:16PM
2931
September 13, 2007 03:38PM


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.