Public bug reported:
Binary package hint: ldirectord
Hi
I've found a problem with ldirectord mysql connection check using negotiate
method. The problem exists in Ubuntu gutsy server with ldirectord version
2.1.2-1. After upgrading to version 2.1.3-2, the hardy's package compiled from
sources the problem goes away.
Description of the problem:
The ldirectord fails to recognise that the mysql server is alive and
working properly. I've created a testing database and created a table
with 1 row. After specifing these settings in the ldirectord config file
and launching the server, the ipvsadm -L -n shows the Weight of 0. If I
set "quiescent=no" in the config file, the entry with the real server
disappears from the ipvsadm output. I've checked the mysql logs and
everything seems to be fine. Ldirector connects to the database and
receives the output of the <request = "SELECT * from connectioncheck">
command.
The problem goes away when I simply compiled and installed version
2.1.3-2 of ldirector and relevant heartbeat packages from hardy's
sources.
Here is a copy of my ldirectord.cf file:
---BEGIN---
# Global Directives
checktimeout=10
checkinterval=2
autoreload=no
logfile="/var/log/ldirectord.log"
# keep dead server in the list with weight 0
quiescent=yes
# MySQL load balancing
virtual = 192.168.77.71:3306
service = mysql
real = 192.168.77.77:3306 gate 10
real = 192.168.77.78:3306 gate 10
real = 192.168.77.79:3306 gate 10
checktype = negotiate
login = "ldirector"
passwd = "ldirectorpassword"
database = "ldirectordb"
request = "SELECT * from connectioncheck"
scheduler = wrr
protocol=tcp
---END---
Andrei
** Affects: heartbeat (Ubuntu)
Importance: Undecided
Status: New
--
ldirectord connection check problem with mysql
https://bugs.launchpad.net/bugs/184543
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
