help with load balancing mysql

[bsheets at singlefin.net]

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