<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello everyone, <br>
<br>
My goal is to build a HA DRBD and MYSQL on two
nodes(active/passive). I followed the " cluster from scratch"
article to build this environment. If I do standby failover host,
it works fine but when I pull the heartbeat cable from the active
node, the resources do not fail over to the secondary. Please
advise. Thank you very much. Joe<br>
<br>
<b>CENTOS 5.6/drbd8.3/corosync/pacemaker<br>
<span class="Apple-style-span" style="color: rgb(0, 0, 0);
font-family: 'Times New Roman'; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing:
normal; line-height: normal; orphans: 2; text-align:
-webkit-auto; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;
background-color: rgb(255, 255, 255); font-size: medium; ">
<pre>node-0 IP: 192.168.1.101 (heartbeat) 10.0.0.10 (drdb)
node-1 IP: 192.168.1.102 (heartbeat) 10.0.0.20 ( drbd)
Cluster Virtual IP: 192.168.1.160</pre>
</span></b> <u>crm configure show</u><br>
node $id="2b68511d-b96f-4b56-9f66-70262e3e2c46" mysqldrbd01 \<br>
attributes standby="off"<br>
node $id="d86dc58b-2309-43d9-af96-6519127e83d7" mysqldrbd02 \<br>
attributes standby="off"<br>
primitive res_Filesystem_QD_FS_DRBD ocf:heartbeat:Filesystem \<br>
params device="/dev/drbd0" directory="/replication/"
fstype="ext3" \<br>
operations $id="res_Filesystem_QD_FS_DRBD-operations" \<br>
op start interval="0" timeout="60" \<br>
op stop interval="0" timeout="60" \<br>
op monitor interval="20" timeout="40" start-delay="0" \<br>
op notify interval="0" timeout="60" \<br>
meta target-role="started"<br>
primitive res_IPaddr2_QD_IP_CLUSTER ocf:heartbeat:IPaddr2 \<br>
params ip="192.168.1.160" \<br>
operations $id="res_IPaddr2_QD_IP_CLUSTER-operations" \<br>
op start interval="0" timeout="20" \<br>
op stop interval="0" timeout="20" \<br>
op monitor interval="10" timeout="20" start-delay="0" \<br>
meta target-role="started"<br>
primitive res_drbd_1 ocf:linbit:drbd \<br>
params drbd_resource="repdata" \<br>
operations $id="res_drbd_1-operations" \<br>
op start interval="0" timeout="240" \<br>
op promote interval="0" timeout="90" \<br>
op demote interval="0" timeout="90" \<br>
op stop interval="0" timeout="100" \<br>
op monitor interval="10" timeout="20" start-delay="1min" \<br>
op notify interval="0" timeout="90" \<br>
meta target-role="started"<br>
primitive res_mysqld_QD_SQL_SERVICE lsb:mysqld \<br>
operations $id="res_mysqld_QD_SQL_SERVICE-operations" \<br>
op start interval="0" timeout="15" \<br>
op stop interval="0" timeout="15" \<br>
op monitor interval="15" timeout="15" start-delay="15" \<br>
meta target-role="started"<br>
group QD_GROUP res_Filesystem_QD_FS_DRBD res_IPaddr2_QD_IP_CLUSTER
res_mysqld_QD_SQL_SERVICE \<br>
meta target-role="started"<br>
ms ms_drbd_1 res_drbd_1 \<br>
meta master-max="1" master-node-max="1" clone-max="2"
clone-node-max="1" notify="true"<br>
colocation QD_MYSQL_DRBD inf: QD_GROUP ms_drbd_1:Master<br>
order QD_MYSQL_AFTER_DRBD inf: ms_drbd_1:promote QD_GROUP:start<br>
property $id="cib-bootstrap-options" \<br>
dc-version="1.0.11-1554a83db0d3c3e546cfd3aaff6af1184f79ee87" \<br>
cluster-infrastructure="Heartbeat" \<br>
no-quorum-policy="ignore" \<br>
stonith-enabled="false" \<br>
last-lrm-refresh="980666220" \<br>
expected-quorum-votes="2"<br>
rsc_defaults $id="rsc-options" \<br>
resource-stickiness="100"<br>
<br>
<b><u>/etc/corosync/corosync.conf</u></b><br>
## generated by drbd-gui 0.9.9<br>
<br>
aisexec {<br>
user: root<br>
group: root<br>
}<br>
<br>
corosync {<br>
user: root<br>
group: root<br>
}<br>
<br>
amf {<br>
mode: disabled<br>
}<br>
<br>
logging {<br>
to_stderr: yes<br>
debug: off<br>
timestamp: on<br>
to_file: no<br>
to_syslog: yes<br>
syslog_facility: daemon<br>
}<br>
<br>
totem {<br>
version: 2<br>
token: 3000<br>
token_retransmits_before_loss_const: 10<br>
join: 60<br>
consensus: 4000<br>
vsftype: none<br>
max_messages: 20<br>
clear_node_high_bit: yes<br>
secauth: on<br>
threads: 0<br>
# nodeid: 1234<br>
rrp_mode: active<br>
<br>
# interface {<br>
# ringnumber: 0<br>
# bindnetaddr: 10.0.0.0<br>
# mcastaddr: 226.94.1.1<br>
# mcastport: 5405<br>
# }<br>
<br>
interface {<br>
ringnumber: 0<br>
bindnetaddr: 192.168.1.0<br>
mcastaddr: 226.94.1.1<br>
mcastport: 5405<br>
}<br>
}<br>
<br>
service {<br>
ver: 0<br>
name: pacemaker<br>
use_mgmtd: no<br>
}<br>
<br>
</body>
</html>