help with load balancing mysql

[Guy Waugh]

Brian Sheets wrote:
> One thing I forgot to note is that ldirectord exits silently, and the ip's are up and operational when this happens. I have to comment out the mysql config lines and restart heartbeat, which starts ldirectord.
>   
Most peculiar...

Another thought: Is the mysql command-line binary accessible to the user 
running heartbeat (on my RHEL3 system, root starts heartbeat but setuids 
to nobody - I don't know which user starts the daemon resources)?

Did you find out whether tcpdump on the real servers are getting packets 
when you telnet to port 3306 from the director to the real servers?

Other than those thoughts, I'm not sure I'm going to be much more 
help... I don't load-balance mysql myself, although I do use a few 
'negotiate'-type checks in my ldirectord config, for http, https,
smtp and dns - they have all worked fine for me.

Cheers,
Guy.
>
> Brian
>
> ----- Original Message -----
> From: "Guy Waugh" <gwaugh at scu.edu.au>
> To: bsheets at singlefin.net, "LinuxVirtualServer.org users mailing list." <lvs-users at linuxvirtualserver.org>
> Sent: Sunday, February 4, 2007 4:12:15 PM (GMT-0800) US/Pacific
> Subject: Re: help with load balancing mysql
>
> bsheets at singlefin.net wrote:
>   
>> Ipvsadm shows both servers with a weight of zero. Both reals have lo:0 and the appropriate sysctl.conf entries. This ldirectord is functional for other virtuals.
>>
>> There is no relevent errors, and it does show both reals being added with a weight of 0
>>
>> The part that it doesn't appear to be making the negotiate connection to verify the service is weird
>>   
>>     
> Indeed it is weird.
>
> All I can think of is: Any difference putting the 'service=mysql' line 
> under the 'real=...' lines? (probably not), and... What does the 
> ldirectord log say when you start ldirectord?
>
> Also, with tcpdump on the real servers active, does it register packets 
> when you telnet to port 3306 from the director (just to check that 
> tcpdump is working)?
>
> - GW.
>   
>>   
>>
>> -----Original Message-----
>> From: Guy Waugh <gwaugh at scu.edu.au>
>> Date: Mon, 05 Feb 2007 10:19:17 
>> To:"LinuxVirtualServer.org users mailing list." <lvs-users at LinuxVirtualServer.org>
>> Subject: Re: help with load balancing mysql
>>
>> 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
>>>
>>>   
>>>     
>>>       
>> _______________________________________________
>> 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
>>   
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> 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
>>   
>>     
>
>
>   


-- 
Guy Waugh
Unix System Administrator
IT&TS, Southern Cross University
Lismore, NSW, Australia
Email: gwaugh at scu.edu.au
Ph.: +61 2 6620 3196
Fax: +61 2 6620 3033