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

[Raoul Bhatia [IPAX]]

hi,

once again i encourage you to use the ocf:heartbeat:mysql
script.

moreover, i guess you did not configure any "monitor" operations that
would periodically check the mysql server's status.

did you read 
http://www.clusterlabs.org/wiki/Load_Balanced_MySQL_Replicated_Cluster ?

there is some information on how to monitor msyql in there
(note: i did not read the entire article)

cheers,
raoul

On 07.06.2010 03:15, 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"
>
>
>
> _______________________________________________
> 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