<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'><font class="Apple-style-span" face="Arial" size="3">Hi All,</font><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">I currently have a 2-node Corosync+Pacemaker cluster configured with a Shared IP (VIP). When the active node fails, the VIP swings to the passive node and becomes active - this works very well so far. </div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">Also - on each node is a MySQL instance - a Master/Master replication configuration.</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">My issue at the moment, is getting Pacemaker configured properly in order to swing the shared ip (VIP) when the active MySQL instance is down.</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">Whenever I shutdown the mysql service on EITHER node - Pacemaker restarts that instance - instead of restarting, I'd really like to see the VIP swing to the other node.</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">Below is my crm configuration - I understand that the example_mysql1 primitive is configured to start the mysql instance - but is there a way to say instead of "op start" - "op shared_ip_one"?</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">I've only started playing with Pacemaker and Corosync and am still digesting concepts - so I'm hoping what I'm trying to accomplish is 'simple' and I'm not able to see the forest for the trees.</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">Many thanks in advance,</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">Patrick</div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; ">`crm configure edit`</div><div><font class="Apple-style-span" color="#00008b" face="monospace"><br></font></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><div>node mycluster1.oz.com</div><div>node mycluster2.oz.com</div><div>primitive example_mysql1 ocf:heartbeat:mysql \</div><div> params binary="mysqld_safe" datadir="/var/lib/mysql/data" pid="/var/lib/mysql/data/mysql.pid" socket="/var/lib/mysql/data/mysql.sock" log="/var/lib/mysql/data/mysql_cluster.log" \</div><div> op start interval="0" timeout="120" \</div><div> op stop interval="0" timeout="120" \</div><div> op monitor interval="10" timeout="30" depth="0"</div><div>primitive shared_ip_one ocf:heartbeat:IPaddr \</div><div> params ip="10.4.1.100" cidr_netmask="255.255.255.0" nic="eth0" \</div><div> op monitor interval="10s"</div><div>ms example_mysql1_master example_mysql1 \</div><div> meta target-role="Slave"</div><div>location cli-prefer-example_mysql1 example_mysql1_master \</div><div> rule $id="cli-prefer-rule-example_mysql1" inf: #uname eq mycluster2.oz.com</div><div>location cli-prefer-shared_ip_one shared_ip_one \</div><div> rule $id="cli-prefer-rule-shared_ip_one" inf: #uname eq mycluster1.oz.com</div><div>property $id="cib-bootstrap-options" \</div><div> dc-version="1.0.11-1554a83db0d3c3e546cfd3aaff6af1184f79ee87" \</div><div> cluster-infrastructure="openais" \</div><div> expected-quorum-votes="2" \</div><div> stonith-enabled="false"</div></div><div style="color: rgb(0, 0, 0); font-family: Arial; font-size: 12pt; "><br></div></div></body></html>