I get that when the DB server is overloaded. It's just that the query times out. Looking at the script to check MySQL in ldirectord, it's very simple and doesn't specify any timeouts etc so I assume will be using Perl DBI defaults. Thing is, if the server is heavily loaded and ldirectord is moving traffic away from it, then it's working and it's the desired behaviour.
You can either modify the check_sql routine in ldirectord to lengthen the timeouts, or just change the checktype to connect. But then you're losing the ability to see if MySQL is actually responding as it should and just checking it's listening on 3306. Darren -----Original Message----- From: lvs-users-boun...@linuxvirtualserver.org [mailto:lvs-users-boun...@linuxvirtualserver.org] On Behalf Of Alejandro Bednarik Sent: 25 August 2011 18:22 To: LinuxVirtualServer.org users mailing list. Subject: Re: [lvs-users] MySQL Cluster Balancing 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.mans...@opengi.co.uk> 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-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 > -- _______________________________________________ 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
