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@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@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
