[lvs-users] MySQL Cluster Balancing

[Darren.Mansell at opengi.co.uk]

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 at linuxvirtualserver.org
[mailto:lvs-users-bounces at linuxvirtualserver.org] On Behalf Of Alejandro
Bednarik
Sent: 25 August 2011 16:29
To: lvs-users at linuxvirtualserver.org
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 at LinuxVirtualServer.org
Send requests to lvs-users-request at LinuxVirtualServer.org
or go to http://lists.graemef.net/mailman/listinfo/lvs-users