Yes, both scripts work perfectly well manually. (the ones that come on /usr/lib/ocf/resource.d/heartbeat/)
2010/2/19 Angie T. Muhammad <angie.taw...@gmail.com> > > > On Fri, Feb 19, 2010 at 7:19 PM, Lior Marantenboim <lior...@gmail.com>wrote: > >> 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:~# >> >> With pacemaker and corosync stopped on both nodes: > can you successfully start / stop / check status of MySQL manually? > > >> _______________________________________________ >> Pacemaker mailing list >> Pacemaker@oss.clusterlabs.org >> http://oss.clusterlabs.org/mailman/listinfo/pacemaker >> >> > > > -- > All the best, > Angie > > _______________________________________________ > 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
