[Pacemaker] Replacement for LVSSyncDaemonSwap-RA?

[Stallmann, Andreas]

Just forget what I wrote. It was some mysql password issue. ARGH!

--
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: AStallmann at CONET.DE<mailto:AStallmann at CONET.DE>
Von: Stallmann, Andreas [mailto:AStallmann at CONET.DE]
Gesendet: Freitag, 10. Februar 2012 16:03
An: The Pacemaker cluster resource manager
Betreff: Re: [Pacemaker] Replacement for LVSSyncDaemonSwap-RA?

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: AStallmann at CONET.DE<mailto:AStallmann at CONET.DE>
Von: Stallmann, Andreas [mailto:AStallmann at CONET.DE]<mailto:[mailto:AStallmann at CONET.DE]>
Gesendet: Freitag, 10. Februar 2012 15:14
An: pacemaker at oss.clusterlabs.org<mailto:pacemaker at oss.clusterlabs.org>
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: AStallmann at CONET.DE<mailto:AStallmann at CONET.DE>



----------------------------
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

 ----------------------------


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120210/dc41321e/attachment-0003.html>