LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: help with load balancing mysql

To: "Guy Waugh" <gwaugh@xxxxxxxxxx>, <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: help with load balancing mysql
From: bsheets@xxxxxxxxxxxxx
Date: Mon, 5 Feb 2007 00:33:48 +0000
Ill try both when I get back to the computer. But there are no bugs or 
limitations regarding mysql that would not allow this to work?
  

-----Original Message-----
From: Guy Waugh <gwaugh@xxxxxxxxxx>
Date: Mon, 05 Feb 2007 11:12:15 
To:bsheets@xxxxxxxxxxxxx,       "LinuxVirtualServer.org users mailing list." 
<lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: help with load balancing mysql

bsheets@xxxxxxxxxxxxx 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@xxxxxxxxxx>
> Date: Mon, 05 Feb 2007 10:19:17 
> To:"LinuxVirtualServer.org users mailing list." 
> <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxxxxxxx
>> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
>> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>>
>>   
>>     
>
> _______________________________________________
> 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
>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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
>   


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





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