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:<br><br>hpblade02:~# crm ra list lsb<br>
acpid atd bootlogd bootmisc.sh checkfs.sh checkroot.sh<br><a href="http://console-screen.kbd.sh">console-screen.kbd.sh</a> corosync cron exim4 glibc.sh halt<br>
hdparm heartbeat hostname.sh hwclock.sh hwclockfirst.sh ifupdown<br>ifupdown-clean keymap.sh killprocs logd lvm2 module-init-tools<br>
mountall-bootclean.sh mountall.sh mountdevsubfs.sh mountkernfs.sh mountnfs-bootclean.sh mountnfs.sh<br>mountoverflowtmp mtab.sh multipath-tools multipath-tools-boot mysql mysql-mmm-agent<br>
mysql-ndb mysql-ndb-mgm nagios-nrpe-server networking nfs-common nscd<br>openbsd-inetd openhpid portmap postfix procps rc<br>
rc.local rcS reboot rmnologin rsync rsyslog<br>screen-cleanup sendsigs single snmpd ssh stop-bootlogd<br>
stop-bootlogd-single sudo sysfsutils udev udev-mtab umountfs<br>umountnfs.sh umountroot urandom <br>hpblade02:~# <br><br>
<br><div class="gmail_quote">2010/2/19 Javier Charne <span dir="ltr"><<a href="mailto:javierch@speedy.com.ar">javierch@speedy.com.ar</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Lior Marantenboim escribió:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
Hello everyone<br>
<br>
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.<br>
I'm using Debian Lenny, corosync 1.2.0, Pacemaker 1-0-051b78d5f321 and cluster glue<br>
<br>
Thanks for any help!<br>
<br>
This is my setup:<br>
<br>
hpblade02:~# crm configure show<br>
node hpblade01<br>
node hpblade02 \<br>
attributes standby="off"<br>
primitive MySQLIP ocf:heartbeat:IPaddr \<br>
params ip="10.10.99.57" cidr_netmask="32" \<br>
op monitor interval="30s" \<br>
meta target-role="Started"<br>
primitive mysql ocf:heartbeat:mysql \<br>
op monitor interval="30s" timeout="60s" \<br>
meta target-role="Started"<br>
location cli-prefer-mysql mysql \<br>
rule $id="cli-prefer-rule-mysql" inf: #uname eq hpblade01<br>
property $id="cib-bootstrap-options" \<br>
dc-version="1.0.7-051b78d5f32195bd9d83447343606211993169e7" \<br>
cluster-infrastructure="openais" \<br>
expected-quorum-votes="2" \<br>
stonith-enabled="false" \<br>
no-quorum-policy="ignore" \<br>
last-lrm-refresh="1266599381"<br>
rsc_defaults $id="rsc-options" \<br>
resource-stickiness="100"<br>
hpblade02:~#<br>
<br>
And here is crm_mon output:<br>
<br>
hpblade02:~# crm_mon<br>
Defaulting to one-shot mode<br>
You need to have curses available at compile time to enable console mode<br>
============<br>
Last updated: Fri Feb 19 14:16:30 2010<br>
Stack: openais<br>
Current DC: hpblade01 - partition with quorum<br>
Version: 1.0.7-051b78d5f32195bd9d83447343606211993169e7<br>
2 Nodes configured, 2 expected votes<br>
2 Resources configured.<br>
============<br>
<br>
Online: [ hpblade01 hpblade02 ]<br>
<br>
MySQLIP (ocf::heartbeat:IPaddr): Started hpblade01<br>
<br>
Failed actions:<br>
mysql_start_0 (node=hpblade01, call=22, rc=-2, status=Timed Out): unknown exec error<br>
mysql_start_0 (node=hpblade02, call=24, rc=-2, status=Timed Out): unknown exec error<br>
hpblade02:~#<br>
<br></div></div>
------------------------------------------------------------------------<br>
E-mail clasificado por el Idenfificador de Spam Inteligente. Para modificar la categor�a clasificada acceda a su webmail<br>
<br>
------------------------------------------------------------------------<br>
Este mensaje ha sido verificado por el E-mail Protegido. Antivirus actualizado en 19/02/2010 / Versión: 0.95.3/10414<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Pacemaker mailing list<br>
<a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
</blockquote>
Try using<br>
<br>
primitive mysql lsb:mysql<br>
<br>
instead of<div class="im"><br>
<br>
primitive mysql ocf:heartbeat:mysql \<br>
op monitor interval="30s" timeout="60s"<br>
<br>
<br></div>
Javier.-<br>
<br>
<br>
_______________________________________________<br>
Pacemaker mailing list<br>
<a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
</blockquote></div><br>