Re: help with load balancing mysql

[Guy Waugh <gwaugh@xxxxxxxxxx>]

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@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
>