I'm new to Pacemaker and trying to understand exactly what it can and can't do.<div><br></div><div>I currently have a small, mysql master/slave cluster setup that is getting monitored within Heartbeat/Pacemaker: What I'd like to be able to do (and am hoping Pacemaker will do) is to have 1 node designated as Master and in the event of a failure, automatically promote a slave to master and realign all of the existing slaves to be slaves of the newly promoted master. Currently what seems to be happening, however, is heartbeat correctly sees that a node goes down and pacemaker promotes it up to master but the replication is not adjusted so that it is now feeding everyone else. It seems like this should be possible to do from within Pacemaker but I feel like I'm missing a part of the puzzle. Any suggestions would be appreciated.</div>
<div><br></div><div><br></div><div>Here's an output of my crm configure show:</div><div><br></div><div><div>node $id="7deca2cd-9a64-476c-8ea2-372bca859a4f" four \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>attributes 172.17.0.130-log-file-p_sql="mysql-bin.000013" 172.17.0.130-log-pos-p_sql="632"</div>
<div>node $id="9b355ab7-8c81-485c-8dcd-1facedde5d03" three \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>attributes 172.17.0.131-log-file-p_sql="mysql-bin.000020" 172.17.0.131-log-pos-p_sql="106"</div>
<div>primitive p_sql ocf:heartbeat:mysql \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>params config="/etc/mysql/my.cnf" binary="/usr/bin/mysqld_safe" datadir="/var/lib/mysql" \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>params pid="/var/lib/mysql/novaSQL.pid" socket="/var/run/mysqld/mysqld.sock" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>params max_slave_lag="120" \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>params replication_user="novaSlave" replication_passwd="nova" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>params additional_parameters="--skip-external-locking --relay-log=novaSQL-relay-bin --relay-log-index=relay-bin.index --relay-log-info-file=<a href="http://relay-bin.info">relay-bin.info</a>" \</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 promote interval="0" timeout="120" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op demote interval="0" timeout="120" \</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="10" role="Master" timeout="30" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="30" role="Slave" timeout="30"</div>
<div>primitive p_sqlIP ocf:heartbeat:IPaddr2 \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>params ip="172.17.0.96" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="10s"</div>
<div>ms ms_sql p_sql \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>meta target-role="Started" is-managed="true"</div><div>location l_sqlMaster p_sqlIP 10: three</div><div>location l_sqlSlave1 p_sqlIP 5: four</div>
<div>property $id="cib-bootstrap-options" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>dc-version="1.0.9-unknown" \</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>cluster-infrastructure="Heartbeat" \</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>last-lrm-refresh="1313187103"</div></div><div><br></div><div><br></div><div>Thanks!</div><div><br></div><div>-Mike.</div>