<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: palatino,georgia,verdana,arial,sans-serif;
font-style: normal; font-variant: normal; font-weight: normal;
letter-spacing: normal; line-height: 19px; orphans: 2; text-align:
justify; text-indent: 0px; text-transform: none; white-space:
normal; widows: 2; word-spacing: 0px; background-color: rgb(255,
255, 255); font-size: small; display: inline ! important; float:
none;">I have a quick question is the Master Slave setting in
pacemaker only allowed in regards to a DRBD device? Can you use it
to create other Master Slave relationships such as mysql . What I
am trying to do is to failover mysql service on a primary to a
secondary if the mysql service fails on the primary . Here is my
RA Mysql Service.<br>
</span><br>
<u>crm configure show</u><br>
node mysqldrbd01 \<br>
attributes standby="off"<br>
node mysqldrbd02 \<br>
attributes standby="off"<br>
primitive DRBD ocf:linbit:drbd \<br>
params drbd_resource="QD-RES" \<br>
operations $id="DRBD-operations" \<br>
op start interval="0" timeout="240" \<br>
op stop interval="0" timeout="100" \<br>
op monitor interval="120" \<br>
meta target-role="started"<br>
primitive FAILOVER-ADDR ocf:heartbeat:IPaddr2 \<br>
params ip="192.168.1.160" nic="eth1" \<br>
operations $id="FAILOVER-ADDR-operations" \<br>
op monitor start-delay="0" interval="10" \<br>
meta target-role="started"<br>
primitive PING-NET ocf:pacemaker:ping \<br>
params multiplier="100" host_list="192.168.1.5" \<br>
operations $id="PING-NET-operations" \<br>
op start interval="0" timeout="60" \<br>
op stop interval="0" timeout="60" \<br>
op monitor interval="60" timeout="60" start-delay="0" \<br>
meta target-role="started"<br>
primitive SRV-MOUNT ocf:heartbeat:Filesystem \<br>
params device="/dev/drbd0" directory="/data/" fstype="ext3"
\<br>
operations $id="SRV-MOUNT-operations" \<br>
op start interval="0" timeout="60" \<br>
op stop interval="0" timeout="60" \<br>
meta target-role="started"<br>
primitive res_mysqld_MYSQL_SRV lsb:mysqld \<br>
operations $id="res_mysqld_MYSQL_SRV-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>
group AP-CLUST SRV-MOUNT FAILOVER-ADDR<br>
ms DRBD-DATA DRBD \<br>
meta clone-max="2" notify="true" target-role="started"<br>
ms MYSQ_MASTER_SLAVE res_mysqld_MYSQL_SRV \<br>
meta clone-max="2" notify="true" target-role="started"<br>
clone PING-NET-CLONE PING-NET \<br>
meta clone-max="2"<br>
location connected_node DRBD-DATA \<br>
rule $id="connected_node-rule" -inf: not_defined pingd or
pingd lte 0<br>
colocation AP-CLUST_on_DRBD inf: AP-CLUST DRBD-DATA:Master<br>
order AP-CLUST_after_DRBD-DATA inf: DRBD-DATA:promote AP-CLUST:start<br>
property $id="cib-bootstrap-options" \<br>
expected-quorum-votes="2" \<br>
stonith-enabled="false" \<br>
dc-version="1.0.11-1554a83db0d3c3e546cfd3aaff6af1184f79ee87"
\<br>
no-quorum-policy="ignore" \<br>
cluster-infrastructure="openais" \<br>
last-lrm-refresh="1320082592"<br>
rsc_defaults $id="rsc-options" \<br>
resource-stickiness="100"<br>
<br>
<div style="color: rgb(34, 34, 34); font-family: palatino, georgia,
verdana, arial, sans-serif; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal; line-height:
19px; orphans: 2; text-align: justify; text-indent: 0px;
text-transform: none; white-space: normal; widows: 2;
word-spacing: 0px; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255); font-size: small; "><br>
<br>
<br>
thank you very much,<br>
Joe<br>
</div>
<br>
</body>
</html>