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 moni...@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@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
