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