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: [email protected]
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: [email protected]
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
