[Pacemaker] Problems settings up MySQL failover

[Javier Charne]

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