Joe:<br><br>Yes. There is now support for replication (master/slave):<br><ul><li>See if the installed MySQL RA (Resource Agent) includes support for replication (your paths might be different)<pre class="wiki">grep -i 'replication capability' /usr/lib/ocf/resource.d/heartbeat/mysql
# Marian Marinov, Florian Haas: add replication capability
</pre></li><li>If not (grep's empty), then grab the latest from <a class="missing wiki" href="https://trac.dechocorp.com/wiki/GitHub" rel="nofollow">GitHub?</a>:
<pre class="wiki">wget <a href="https://raw.github.com/ClusterLabs/resource-agents/master/heartbeat/mysql">https://raw.github.com/ClusterLabs/resource-agents/master/heartbeat/mysql</a> <br></pre></li></ul><ul><li>Backup the current MySQL RA, move the new one in place (paths might be different):
<pre class="wiki">mv /usr/lib/ocf/resource.d/heartbeat/mysql /usr/lib/ocf/resource.d/heartbeat/mysql.backup
mv mysql /usr/lib/ocf/resource.d/heartbeat/mysql
chmod +x /usr/lib/ocf/resource.d/heartbeat/mysql
</pre></li><li>You might have to do something like this if your paths are off -- Patch the new MySQL RA::
</li></ul><blockquote>
<blockquote>
<blockquote>
<blockquote>
<p>
Open /usr/lib/ocf/resource.d/heartbeat/mysql and replace:
</p>
<pre class="wiki">: ${OCF_FUNCTIONS_DIR=${OCF_ROOT}/lib/heartbeat}
. ${OCF_FUNCTIONS_DIR}/ocf-shellfuncs
</pre><p>
with
</p>
<pre class="wiki">: ${OCF_FUNCTIONS_DIR=${OCF_ROOT}/resource.d/heartbeat}
. ${OCF_FUNCTIONS_DIR}/.ocf-shellfuncs
</pre></blockquote>
</blockquote>
</blockquote>
</blockquote><br>~Mike<br><br><br><div class="gmail_quote">On Mon, Oct 31, 2011 at 1:39 PM, Joe <span dir="ltr"><<a href="mailto:weester@hotmail.com">weester@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div text="#000000" bgcolor="#FFFFFF">
<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;text-align:justify;text-indent:0px;text-transform:none;white-space:normal;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;text-align:justify;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255, 255, 255);font-size:small">
<br>
<br>
<br>
thank you very much,<br><font color="#888888">
Joe<br>
</font></div>
<br>
</div>
<br>_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
<br></blockquote></div><br>