Sorry for bothering you.
I just found out that LVSSyncDaemonSwap is not necessary any more with newer
ldirector version.
Ahhehm… one more question (and I not that this question is entirely out of
place her):
Does anyone here know anything about ldirector? I just wonder:
When you configure ldirector to listen on port 3306, shouldn’t this port show
up as “listen” in lsof –i? Because it doesn’t (and access to the balanced hosts
via the virtual IP does not work).
Here’s my crm-config:
node ubuntu-lb01
node ubuntu-lb02
primitive p_loadbalancer ocf:heartbeat:ldirectord \
params configfile="/etc/ldirectord.cf"
ldirectord="/usr/sbin/ldirectord" \
op start interval="0" timeout="15s" \
op stop interval="0" timeout="15s" \
op monitor interval="20s" timeout="10s" \
meta target-role="Started"
primitive p_writer_vip ocf:heartbeat:IPaddr2 \
params ip="10.20.0.13" cidr_netmask="24" nic="eth0:0" \
meta target-role="Started"
group g_loadbalance p_writer_vip p_loadbalancer
location cli-prefer-g_loadbalance g_loadbalance \
rule $id="cli-prefer-rule-g_loadbalance" inf: #uname eq ubuntu-lb01
property $id="cib-bootstrap-options" \
dc-version="1.1.5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f" \
cluster-infrastructure="openais" \
expected-quorum-votes="2" \
stonith-enabled="false" \
no-quorum-policy="ignore" \
default-resource-stickiness="1000" \
last-lrm-refresh="1328884725"
And here’s the config of ldirector:
# Global Directives
checktimeout=10
checkinterval=2
autoreload=no
logfile="local0"
quiescent=yes
virtual = 10.20.0.13:3306
service = mysql
real = 10.20.0.14:3306 gate
real = 10.20.0.15:3306 gate
checktype = negotiate
login = "ldirector"
passwd = "ldirectorpassword"
database = "ldirectordb"
request = "SELECT * FROM connectioncheck"
scheduler = wrr
Any ideas?
Cheers,
Andreas
--
CONET Solutions GmbH
Andreas Stallmann,
Theodor-Heuss-Allee 19, 53773 Hennef
Tel.: +49 2242 939-677, Fax: +49 2242 939-393
Mobil: +49 172 2455051
Internet: http://www.conet.de, mailto:
[email protected]<mailto:[email protected]>
Von: Stallmann, Andreas [mailto:[email protected]]
Gesendet: Freitag, 10. Februar 2012 15:14
An: [email protected]
Betreff: [Pacemaker] Replacement for LVSSyncDaemonSwap-RA?
Hi!
I’m trying to set up a loadbalanced MySQL-Cluster (according to
http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-mysql5.1-p3).
Unfortunately the manual is from 2008 and thus uses heartbeat, while I prefer
corosync/pacemaker. *
Do you know which Ubuntu (11.10) package contains the LVSSyncDaemonSwap-RA?
It’s not in the resource-agents package. ☹
Thanks in advance,
Andreas
*Yes, I know, there’s keepalived out there, but I don’t find a manual how to
set it up for MySQL.
--
CONET Solutions GmbH
Andreas Stallmann,
Theodor-Heuss-Allee 19, 53773 Hennef
Tel.: +49 2242 939-677, Fax: +49 2242 939-393
Mobil: +49 172 2455051
Internet: http://www.conet.de, mailto:
[email protected]<mailto:[email protected]>
----------------------------
CONET Solutions GmbH, Theodor-Heuss-Allee 19, 53773 Hennef.
Registergericht/Registration Court: Amtsgericht Siegburg (HRB Nr. 9136)
Geschäftsführer/Managing Director: Anke Höfer
----------------------------
_______________________________________________
Pacemaker mailing list: [email protected]
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org
