LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: [lvs-users] MySQL Cluster Balancing

To: "LinuxVirtualServer.org users mailing list." <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: [lvs-users] MySQL Cluster Balancing
From: Alejandro Bednarik <alejandrob@xxxxxxx>
Date: Thu, 25 Aug 2011 14:22:14 -0300
Already Test Ldirectord in Debug Mode al modulesa are installed an
dldirectord shows server up and running.  When there is no traffic all
servers are up, but when i start sending traffic, in this case is like 3000
k queries per second in a cluster with 10 DBs servers are mark as down and
up all the time. Without this MySQL check LVS is working fine, in fact is
what we are using.

Thanks for help!

On Thu, Aug 25, 2011 at 1:00 PM, <Darren.Mansell@xxxxxxxxxxxx> wrote:

> That looks fine. This is mine from a production cluster:
>
> virtual=10.167.20.100:3306
>        fallback=10.167.20.20:3306
>        real=10.167.20.10:3306 gate 1000
>        service=mysql
>        login="servicecheck"
>        passwd="password"
>        database="ldirectord"
>        request="SELECT * from connectioncheck;"
>        scheduler=wlc
>        protocol=tcp
>        checktype=negotiate
>
>
> What's not working? LVS giving it a 0 score?
>
> If so, look in the ldirectord log, it may just be something like
> Perl-MySQL not installed.
>
>
> -----Original Message-----
> From: lvs-users-bounces@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:lvs-users-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Alejandro
> Bednarik
> Sent: 25 August 2011 16:29
> To: lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Subject: [lvs-users] MySQL Cluster Balancing
>
> Hi Guys,
>
> Anyone here using lvs + heartbeat + ldirectod with the option to test
> mysql server using a simple query ? Just test in a QA enviroment and
> worker great but when i tried the same configuration in a Production
> environment results where bad..
>
> Here the configuration used
>
>
> virtual=10.0.0.1:3306
>        real=10.0.0.2:3306   gate 10
>        real=10.0.6.3:3306   gate 10
>        service=mysql
>        scheduler=wlc
>        checktype = negotiate
>        login = "lbuser"
>        passwd = "lbpassword"
>        database = "db_name"
>        request = "select 1"
>
>
> Thanks,
> Cheers.
> _______________________________________________
> Please read the documentation before posting - it's available at:
> http://www.linuxvirtualserver.org/
>
> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://lists.graemef.net/mailman/listinfo/lvs-users
>
> _______________________________________________
> Please read the documentation before posting - it's available at:
> http://www.linuxvirtualserver.org/
>
> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://lists.graemef.net/mailman/listinfo/lvs-users
>



--
_______________________________________________
Please read the documentation before posting - it's available at:
http://www.linuxvirtualserver.org/

LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
or go to http://lists.graemef.net/mailman/listinfo/lvs-users

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