[Pacemaker] i stop mysql service but the crm status is still runing

[Vadym Chepkov]

On Jun 6, 2010, at 9:44 PM, ch huang wrote:

> thanks for quick reply ,i do have monit on mysql ,mysql datadir is on drbd ,as u see ,the drbd is defined as resource,but as your way,it sames just monit  one host's service ,if the service is unavariable,pacemaker will try to restart it on this host,but i want  mysql start on another backup host


No, you are not, this is your config, right?

> > primitive mysqld lsb:mysqld

no monitor operation is defined




> 
> On Mon, Jun 7, 2010 at 9:30 AM, Vadym Chepkov <vchepkov at gmail.com> wrote:
> 
> On Jun 6, 2010, at 9:15 PM, ch huang wrote:
> 
> > mysql is running ,and crm status output is
> >
> > ============
> > Last updated: Sat Jun  5 09:48:58 2010
> > Stack: openais
> > Current DC: PRIM - partition with quorum
> > Version: 1.0.8-9881a7350d6182bae9e8e557cf20a3cc5dac3ee7
> > 2 Nodes configured, 2 expected votes
> > 2 Resources configured.
> > ============
> >
> > Online: [ PRIM SEC ]
> >
> >  Resource Group: mysql
> >      fs_mysql   (ocf::heartbeat:Filesystem):    Started PRIM
> >      ip_mysql   (ocf::heartbeat:IPaddr2):       Started PRIM
> >      mysqld     (lsb:mysqld):   Started PRIM
> >  Master/Slave Set: ms_drbd_mysql
> >      Masters: [ PRIM ]
> >      Slaves: [ SEC ]
> >
> > and i finished the mysql by
> >
> > #service mysqld stop
> > Stopping MySQL:                                            [  OK  ]
> > # service mysqld status
> > mysqld is stopped
> >
> > but in the crm status output , mysql still in running ,i do not understand why?
> >
> > ============
> > Last updated: Sat Jun  5 09:48:58 2010
> > Stack: openais
> > Current DC: PRIM - partition with quorum
> > Version: 1.0.8-9881a7350d6182bae9e8e557cf20a3cc5dac3ee7
> > 2 Nodes configured, 2 expected votes
> > 2 Resources configured.
> > ============
> >
> > Online: [ PRIM SEC ]
> >
> >  Resource Group: mysql
> >      fs_mysql   (ocf::heartbeat:Filesystem):    Started PRIM
> >      ip_mysql   (ocf::heartbeat:IPaddr2):       Started PRIM
> >      mysqld     (lsb:mysqld):   Started PRIM
> >  Master/Slave Set: ms_drbd_mysql
> >      Masters: [ PRIM ]
> >      Slaves: [ SEC ]
> >
> > and here is my configure
> >
> > # crm
> > crm(live)# configure
> > crm(live)configure# show
> > node PRIM
> > node SEC
> > primitive drbd_mysql ocf:linbit:drbd \
> >         params drbd_resource="r1" \
> >         op monitor interval="15s"
> > primitive fs_mysql ocf:heartbeat:Filesystem \
> >         params device="/dev/drbd/by-res/r1" directory="/drbddata/" fstype="ext3"
> > primitive ip_mysql ocf:heartbeat:IPaddr2 \
> >         params ip="192.168.76.227" nic="eth0"
> > primitive mysqld lsb:mysqld
> > group mysql fs_mysql ip_mysql mysqld
> > ms ms_drbd_mysql drbd_mysql \
> >         meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"
> > colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master
> > order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start
> > property $id="cib-bootstrap-options" \
> >         no-quorum-policy="ignore" \
> >         stonith-enabled="false" \
> >         expected-quorum-votes="2" \
> >         dc-version="1.0.8-9881a7350d6182bae9e8e557cf20a3cc5dac3ee7" \
> >         cluster-infrastructure="openais" \
> >         default-action-timeout="240s"
> >
> 
> 
> First of all, nothing is monitored by default, you need to enabled monitor operation.
> Second, you were advised do not use lsb, use ocf resource agent instead:
> 
> in sql create a simple monitoring database
> 
> create database cluster;
> use cluster;
> create table monitor (int i);
> insert into monitor values(1);
> grant select on cluster.monitor to monitor at localhost identified by 'monitor';
> 
> it's just so the monitor script can do a select.
> 
> Then somewhat long primitive definition:
> 
> primitive mysqld ocf:heartbeat:mysql \
>        params binary="/usr/bin/mysqld_safe" config="/drbddata/mysql/etc/my.cnf" enable_creation="0" datadir="/drbddata/mysql/data" \
>        user="mysql" test_user="monitor" test_passwd="monitor" test_table="cluster.monitor" \
>        op monitor start-delay="60s" interval="300s"
> 
> Enjoy
> 
> Vadym
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> 
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
> 
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> 
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20100606/cc781160/attachment-0001.html>