Apparently commiting even if it complains that the slb resource does not exist, works. I have it working now with SLB instead of ocf: heartbeat.<br><br>The next thing I'm trying to do is that if the cluster detects that the primary node has MySQL down, to switch it's service IP to the other node.<br>
Is there an easy way to do that?<br><br><div class="gmail_quote">2010/2/22 Dejan Muhamedagic <span dir="ltr"><<a href="mailto:dejanmm@fastmail.fm">dejanmm@fastmail.fm</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;">
Hi,<br>
<div><div></div><div class="h5"><br>
On Fri, Feb 19, 2010 at 02:19:15PM -0300, Lior Marantenboim wrote:<br>
> Hello everyone<br>
><br>
> I've having trouble trying to set up a simple MySQL failover (make Pacemaker<br>
> start it on one node, and if it shuts down, start it on the other). CRM<br>
> shows as if MySQL is not running but it actually is, and since it doesn't<br>
> 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<br>
> 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):<br>
> unknown exec error<br>
> mysql_start_0 (node=hpblade02, call=24, rc=-2, status=Timed Out):<br>
> unknown exec error<br>
<br>
</div></div>This contradicts the statement above, i.e. the start action timed<br>
out. It may be that mysql actually started, but then monitor<br>
failed. Don't have the details. If it takes a long time for the<br>
database to start, then increase the start operation timeout<br>
(defaults to 20 sec, from the default-action-timeout property).<br>
Check the logs for any mysql messages (incl. those relayed by<br>
lrmd). If you can't figure out what's going on, make a hb_report<br>
and post it.<br>
<br>
Thanks,<br>
<br>
Dejan<br>
<br>
> hpblade02:~#<br>
<div><div></div><div class="h5"><br>
> _______________________________________________<br>
> Pacemaker mailing list<br>
> <a href="mailto:Pacemaker@oss.clusterlabs.org">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>
<br>
_______________________________________________<br>
Pacemaker mailing list<br>
<a href="mailto:Pacemaker@oss.clusterlabs.org">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>
</div></div></blockquote></div><br>