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? Does all resource agents potentially involved in this need to be aware of the Master Slave relationship? I am trying to set up a pair fo mysql servers One is replicating from the other(handled within mysql's my.cnf.) I basically want to fail over the VIP of the primary node to the secondary node(which also happens to be the mysql slave) in the event that the primary has its mysql server stopped. I am not using DRBD at all. My config looks like the following. <div>
<br></div><div><div>node $id="0cd2bb09-00b6-4ce4-bdd1-629767ae0739" sipl-mysql-109</div><div>node $id="119fc082-7046-4b8d-a9a3-7e777b9ddf60" sipl-mysql-209</div><div>primitive p_clusterip ocf:heartbeat:IPaddr2 \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>params ip="10.200.131.9" cidr_netmask="32" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="30s"</div>
<div>primitive p_mysql ocf:heartbeat:mysql \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op start interval="0" timeout="120" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op stop interval="0" timeout="120" \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="10" timeout="120" depth="0"</div><div>ms ms_mysql p_mysql \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1"</div>
<div>location l_master ms_mysql \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>rule $id="l_master-rule" $role="Master" 100: #uname eq sipl-mysql-109</div><div>colocation mysql_master_on_ip inf: p_clusterip ms_mysql:Master</div>
<div>property $id="cib-bootstrap-options" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>stonith-enabled="false" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>no-quorum-policy="ignore" \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>start-failure-is-fatal="false" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>expected-quorum-votes="2" \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>symmetric-cluster="false" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>dc-version="1.0.9-89bd754939df5150de7cd76835f98fe90851b677" \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>cluster-infrastructure="Heartbeat"</div><div>rsc_defaults $id="rsc-options" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>resource-stickiness="100"</div>
</div><div><br></div><div><br></div><div>What's happening is that mysql is never brought up due to the following errors:</div><div><br></div><div><div>ul 22 16:15:07 sipl-mysql-109 pengine: [22890]: info: native_color: Resource p_mysql:0 cannot run anywhere</div>
<div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: info: native_color: Resource p_mysql:1 cannot run anywhere</div><div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: info: native_merge_weights: ms_mysql: Rolling back scores from p_clusterip</div>
<div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: info: master_color: ms_mysql: Promoted 0 instances of a possible 1 to master</div><div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: info: native_color: Resource p_clusterip cannot run anywhere</div>
<div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: info: master_color: ms_mysql: Promoted 0 instances of a possible 1 to master</div><div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: notice: LogActions: Leave resource p_clusterip<span class="Apple-tab-span" style="white-space:pre"> </span>(Stopped)</div>
<div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: notice: LogActions: Leave resource p_mysql:0<span class="Apple-tab-span" style="white-space:pre"> </span>(Stopped)</div><div>Jul 22 16:15:07 sipl-mysql-109 pengine: [22890]: notice: LogActions: Leave resource p_mysql:1<span class="Apple-tab-span" style="white-space:pre"> </span>(Stopped)</div>
</div><div><br></div><div><br></div><div>I thought I may have overcome this with my location and colocation directive but it failed. Could someone give me some feedback on what I am trying to do, my config and the resulting errors?</div>
<div><br></div><div>Thanks</div><div>F.</div>