[Pacemaker] Problems settings up MySQL failover

[Lior Marantenboim]

I actually tried doing that, but I don't seem to have lsb installed (it says
that I don't have the script installed), even though a "crm ra list lsb"
shows that I supposedly do:

hpblade02:~# crm ra list lsb
acpid                  atd                    bootlogd
bootmisc.sh            checkfs.sh             checkroot.sh
console-screen.kbd.sh  corosync               cron
exim4                  glibc.sh               halt
hdparm                 heartbeat              hostname.sh
hwclock.sh             hwclockfirst.sh        ifupdown
ifupdown-clean         keymap.sh              killprocs
logd                   lvm2                   module-init-tools
mountall-bootclean.sh  mountall.sh            mountdevsubfs.sh
mountkernfs.sh         mountnfs-bootclean.sh  mountnfs.sh
mountoverflowtmp       mtab.sh                multipath-tools
multipath-tools-boot   mysql                  mysql-mmm-agent
mysql-ndb              mysql-ndb-mgm          nagios-nrpe-server
networking             nfs-common             nscd
openbsd-inetd          openhpid               portmap
postfix                procps                 rc
rc.local               rcS                    reboot
rmnologin              rsync                  rsyslog
screen-cleanup         sendsigs               single
snmpd                  ssh                    stop-bootlogd
stop-bootlogd-single   sudo                   sysfsutils
udev                   udev-mtab              umountfs
umountnfs.sh           umountroot             urandom
hpblade02:~#


2010/2/19 Javier Charne <javierch at speedy.com.ar>

> Lior Marantenboim escribió:
>
>> Hello everyone
>>
>> I've having trouble trying to set up a simple MySQL failover (make
>> Pacemaker start it on one node, and if it shuts down, start it on the
>> other). CRM shows as if MySQL is not running but it actually is, and since
>> it doesn't see it that way, it tries to start it on the other node as well.
>> I'm using Debian Lenny, corosync 1.2.0, Pacemaker 1-0-051b78d5f321 and
>> cluster glue
>>
>> Thanks for any help!
>>
>> This is my setup:
>>
>> hpblade02:~# crm configure show
>> node hpblade01
>> node hpblade02 \
>>    attributes standby="off"
>> primitive MySQLIP ocf:heartbeat:IPaddr \
>>    params ip="10.10.99.57" cidr_netmask="32" \
>>    op monitor interval="30s" \
>>    meta target-role="Started"
>> primitive mysql ocf:heartbeat:mysql \
>>    op monitor interval="30s" timeout="60s" \
>>    meta target-role="Started"
>> location cli-prefer-mysql mysql \
>>    rule $id="cli-prefer-rule-mysql" inf: #uname eq hpblade01
>> property $id="cib-bootstrap-options" \
>>    dc-version="1.0.7-051b78d5f32195bd9d83447343606211993169e7" \
>>    cluster-infrastructure="openais" \
>>    expected-quorum-votes="2" \
>>    stonith-enabled="false" \
>>    no-quorum-policy="ignore" \
>>    last-lrm-refresh="1266599381"
>> rsc_defaults $id="rsc-options" \
>>    resource-stickiness="100"
>> hpblade02:~#
>>
>> And here is crm_mon output:
>>
>> hpblade02:~# crm_mon
>> Defaulting to one-shot mode
>> You need to have curses available at compile time to enable console mode
>> ============
>> Last updated: Fri Feb 19 14:16:30 2010
>> Stack: openais
>> Current DC: hpblade01 - partition with quorum
>> Version: 1.0.7-051b78d5f32195bd9d83447343606211993169e7
>> 2 Nodes configured, 2 expected votes
>> 2 Resources configured.
>> ============
>>
>> Online: [ hpblade01 hpblade02 ]
>>
>>  MySQLIP    (ocf::heartbeat:IPaddr):    Started hpblade01
>>
>> Failed actions:
>>    mysql_start_0 (node=hpblade01, call=22, rc=-2, status=Timed Out):
>> unknown exec error
>>    mysql_start_0 (node=hpblade02, call=24, rc=-2, status=Timed Out):
>> unknown exec error
>> hpblade02:~#
>>
>> ------------------------------------------------------------------------
>> E-mail clasificado por el Idenfificador de Spam Inteligente. Para
>> modificar la categor�a clasificada acceda a su webmail
>>
>> ------------------------------------------------------------------------
>> Este mensaje ha sido verificado por el E-mail Protegido. Antivirus
>> actualizado en 19/02/2010 / Versión: 0.95.3/10414
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Pacemaker mailing list
>> Pacemaker at oss.clusterlabs.org
>> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>>
>>
> Try using
>
> primitive mysql lsb:mysql
>
> instead of
>
>
> primitive mysql ocf:heartbeat:mysql \
>   op monitor interval="30s" timeout="60s"
>
>
> Javier.-
>
>
> _______________________________________________
> Pacemaker mailing list
> Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20100219/d853c608/attachment-0002.htm>