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 <vchep...@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 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 > > _______________________________________________ > 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
_______________________________________________ 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
