help with load balancing mysql

[Guy Waugh]

Brian Sheets wrote:
> 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?
>   
What's the output of 'ipvsadm -Ln'? Is the virtual service listed, and 
if so, are the real servers listed?

Anything in the ldirectord log?

Given you're using LVS-DR, do the real servers have the 172.16.10.122 
address set up as a loopback address?

Cheers,
Guy.
>  
> thanks
>  
> Brian
>
> _______________________________________________
> LinuxVirtualServer.org mailing list - lvs-users at LinuxVirtualServer.org
> Send requests to lvs-users-request at LinuxVirtualServer.org
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
>