help with load balancing mysql

Brian Sheets bsheets at singlefin.net
Sun Feb 4 21:54:41 GMT 2007


I'm having a problem load balancing MySQL with ldirectord 
 
here is my config
 
# MYSQL
virtual=172.16.10.122:3306
       service=mysql
        real=172.16.10.120:3306 gate
        real=172.16.10.121:3306 gate
       checktype=negotiate
       login="ldirector"
       passwd="xxxxxx"
       database="ldirectordb"
       request="select * from connectioncheck"
       scheduler=wrr
 
I'm running this using the latest ultramonkey on debian sarge.
 
I can run a tcpdump on the real server and look for port 3306 connections to the db to connect and run the check, but none are being made
 
Anyone have any ideas?
 
thanks
 
Brian


Search lvs-users Archives
Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort

More information about the lvs-users mailing list