<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">I've got a
replicated <i>mysql with vip</i> setup i've been trying to create, and
it doesnt seem to be obeying my colocation rule much.<br>
<br>
Situation:<br>
I had shut down corosync on all (3) nodes and verified all associated
services were off.<br>
I then started it up an all 3 nodes.<br>
When it came back up, the VIP was running on node1, while the master
mysql service was running on node 2.<br>
<br>
</font></font><font size="-1"><tt># crm status<br>
============<br>
Last updated: Mon Nov 29 05:51:06 2010<br>
Stack: openais<br>
Current DC: devms01 - partition with quorum<br>
Version: 1.0.9-89bd754939df5150de7cd76835f98fe90851b677<br>
3 Nodes configured, 3 expected votes<br>
2 Resources configured.<br>
============<br>
<br>
Online: [ devms01 devms02 devms03 ]<br>
<br>
vip (ocf::heartbeat:IPaddr2): Started devms01<br>
Master/Slave Set: ms_mysql<br>
Masters: [ devms02 ]<br>
Slaves: [ devms01 devms03 ]<br>
<br>
<br>
# crm configure show<br>
node devms01 \<br>
attributes standby="off"<br>
node devms02 \<br>
attributes standby="off"<br>
node devms03<br>
primitive mysql ocf:etc:mysql \<br>
params master_host="165.212.101.96" user="mailsafe_rep"
pass="replicate" \<br>
op monitor interval="10s" role="Master" \<br>
op monitor interval="60s" role="Slave"<br>
primitive vip ocf:heartbeat:IPaddr2 \<br>
params nic="eth0" iflabel="0" ip="165.212.101.96"
cidr_netmask="24" broadcast="165.212.101.255" \<br>
meta target-role="Started" is-managed="true"<br>
ms ms_mysql mysql \<br>
meta target-role="Master" is-managed="true"<br>
colocation co_mysql inf: ms_mysql:Master vip<br>
property $id="cib-bootstrap-options" \<br>
dc-version="1.0.9-89bd754939df5150de7cd76835f98fe90851b677" \<br>
cluster-infrastructure="openais" \<br>
expected-quorum-votes="3" \<br>
stonith-enabled="false" \<br>
no-quorum-policy="ignore" \<br>
default-resource-stickiness="INFINITY" \<br>
last-lrm-refresh="1291008843"<br>
<br>
</tt><br>
<br>
</font><font size="-1"><font face="Helvetica, Arial, sans-serif">I dont
get it. Why did it decide to just ignore the co_mysql rule?<br>
</font></font>
</body>
</html>