MySQL Forums
Forum List  »  Router & Proxy

load balancer
Posted by: Irfan Ali
Date: May 29, 2008 01:34AM

Hi,

I am having one serious problem with mysql proxy. I want to split the load on mysql database servers as mysql-proxy takes dicision that which mysql server has low load and switch the query to that server. i.e. I want that proxy should take decision like compare both mysql servers that which of them has less number of processes running and switch the queries on on that server which has low traffic rather than round robin.

$ mysql=proxy --proxy-backend--addresess=192.168.0.1 \
--proxy-backend--addresses=192.168.0.2

Options: ReplyQuote


Subject
Views
Written By
Posted
load balancer
3234
May 29, 2008 01:34AM


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.