Hi, On Fri, Feb 19, 2010 at 03:08:00PM -0300, Javier Charne wrote: > 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"
Always better to use OCF RA! Thanks, Dejan > > Javier.- > > > _______________________________________________ > Pacemaker mailing list > Pacemaker@oss.clusterlabs.org > http://oss.clusterlabs.org/mailman/listinfo/pacemaker _______________________________________________ Pacemaker mailing list Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker
