Load balancing issues on a Master/Master architecture
Posted by:
Kin JOY
Date: July 17, 2009 08:51AM
Hello there :)
I'am facing a special issue with mysql-proxy 0.7.2 which is running on a dedicated server and I have two mysql servers 5.1.x running as Master/master. My problem is that every single connection is going to only one server. I read many documentation and the sticky post without finding any information. Here is my init script for mysql-proxy :
LUA_PATH="/usr/src/mysql-proxy-0.7.2/lib/?.lua"
mysql-proxy \
--log-file=/var/log/mysql-proxy.log \
--log-level=debug \
--proxy-address=10.33.3.241:3306 \
--proxy-backend-addresses=10.33.3.242:3306 \
--proxy-backend-addresses=10.33.3.243:3306 \
--daemon
I tried to stimulate my server a bit, thinking that the connection where not enough overcharged but nothing changed :
for i in `seq 1 500` ; do mysql -h 10.33.3.241 -P 3306 -u proxyuser -p***** -e 'exit'; done ;
for ((f=1;f<300;f++)) ; do mysql -h 10.33.3.241 -P 3306 -u proxyuser -p***** -e 'SELECT 42;'; done
What I am looking for with mysql-proxy is pretty simple. I would like to load balance requests (read or write) with an health check on the backend servers. if a server is facing a "too many connection", the proxy could redirect all request to the other server for instance.
Is it possible ? Thanks in advance for your help.
Best regards,
Kin
Subject
Views
Written By
Posted
Load balancing issues on a Master/Master architecture
6220
July 17, 2009 08:51AM
2765
July 17, 2009 08:30PM
4704
July 20, 2009 04:08AM
2794
July 24, 2009 12:14PM
3922
July 20, 2009 08:31AM
2808
July 20, 2009 01:41PM
2633
July 20, 2009 02:03PM
2737
July 21, 2009 02:30AM
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.