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
6880
September 10, 2007 05:08PM
3025
September 10, 2007 11:52PM
Re: Proxy pool member. How to...?
3315
September 11, 2007 12:58AM
3201
September 11, 2007 01:35AM
3234
September 11, 2007 02:37AM
2983
September 11, 2007 03:38PM
2835
September 12, 2007 03:42PM
2905
September 12, 2007 05:03PM
2813
September 13, 2007 01:45AM
3010
September 13, 2007 03:16PM
2885
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.