LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: help with load balancing mysql

To: "LinuxVirtualServer.org users mailing list." <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: help with load balancing mysql
From: bsheets@xxxxxxxxxxxxx
Date: Sun, 4 Feb 2007 23:51:30 +0000
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
  

-----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




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