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
|