LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

help with load balancing mysql

To: lvs-users <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: help with load balancing mysql
From: Brian Sheets <bsheets@xxxxxxxxxxxxx>
Date: Sun, 4 Feb 2007 21:54:41 +0000 (UTC)
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


<Prev in Thread] Current Thread [Next in Thread>