<div dir="ltr">Hi,<div><br></div><div>Let me explain my use case. I'm using RHEL 6.3 with Corosync + Pacemaker + PostgreSQL9.2 + repmgr 2.0. I have two nodes names clustera and clusterb.</div><div><br></div><div>I have a total of 3 resources :</div>
<div>- APACHE</div><div>- BOUM</div><div>- MS_POSTGRESQL</div><div><br></div><div>They are defined as follow :</div><div><br></div><div><div>sudo crm configure primitive APACHE ocf:heartbeat:apache \</div><div> params configfile=/etc/httpd/conf/httpd.conf \</div>
<div> op monitor interval=5s timeout=10s \</div><div> op start interval=0 timeout=10s \</div><div> op stop interval=0 timeout=10s</div><div><br></div><div> sudo crm configure primitive BOUM ocf:heartbeat:anything \</div>
<div> params binfile=/usr/local/boum/current/bin/boum \</div><div> workdir=/var/boum \</div><div> logfile=/var/log/boum/boum_STDOUT \</div><div> errlogfile=/var/log/boum/boum_STDERR \</div><div> pidfile=/var/run/boum.pid \</div>
<div> op monitor interval=5s timeout=10s \</div><div> op start interval=0 timeout=10s \</div><div> op stop interval=0 timeout=10s</div><div><br></div><div>sudo crm configure primitive POSTGRESQL ocf:xxxxxx:postgresql \</div>
<div> params repmgr_conf=/var/lib/pgsql/repmgr/repmgr.conf pgctl=/usr/pgsql-9.2/bin/pg_ctl pgdata=/opt/pgdata \</div><div> op start interval=0 timeout=90s \</div><div> op stop interval=0 timeout=60s \</div><div> op promote interval=0 timeout=120s \</div>
<div> op monitor interval=53s role=Master \</div><div> op monitor interval=60s role=Slave</div></div><div><br></div><div>Since the PostgreSQL is in streaming replication, I need to have a master and a slave constantly running. Hence, I created an MasterSlave resource, called MS_POSTGRESQL.</div>
<div><br></div><div>I want to that APACHE, BOUM and the master node of PostgreSQL run altogether on the same node. It looks like that as soon as I add a colocation, the Postgresql slave doesn't start anymore.</div><div>
<br></div><div>I end up with :</div><div><br></div><div><div>Online: [ clusterb clustera ]</div><div><br></div><div> Master/Slave Set: MS_POSTGRESQL [POSTGRESQL]</div><div> Masters: [ clustera ]</div><div> Stopped: [ POSTGRESQL:1 ]</div>
<div>APACHE (ocf::heartbeat:apache): Started clustera</div><div>BOUM (ocf::heartbeat:anything):<span class="" style="white-space:pre"> </span>Started clustera</div></div><div><br></div><div>My configuration is as follows :</div>
<div><br></div><div><div><br></div><div>node clustera \</div><div> attributes standby="off"</div><div>node clusterb \</div><div> attributes standby="off"</div><div>primitive APACHE ocf:heartbeat:apache \</div>
<div> params configfile="/etc/httpd/conf/httpd.conf" \</div><div> op monitor interval="5s" timeout="10s" \</div><div> op start interval="0" timeout="10s" \</div>
<div> op stop interval="0" timeout="10s" \</div><div> meta target-role="Started"</div><div>primitive BOUM ocf:heartbeat:anything \</div><div> params binfile="/usr/local/boum/current/bin/boum" workdir="/var/boum" logfile="/var/log/boum/boum_STDOUT" errlogfile="/var/log/boum/boum_STDERR" pidfile="/var/run/boum.pid" \</div>
<div> op monitor interval="5s" timeout="10s" \</div><div> op start interval="0" timeout="10s" \</div><div> op stop interval="0" timeout="10s"</div>
<div>primitive POSTGRESQL ocf:xxxxxxx:postgresql \</div><div> params repmgr_conf="/var/lib/pgsql/repmgr/repmgr.conf" pgctl="/usr/pgsql-9.2/bin/pg_ctl" pgdata="/opt/pgdata" \</div><div>
op start interval="0" timeout="90s" \</div><div> op stop interval="0" timeout="60s" \</div><div> op promote interval="0" timeout="120s" \</div>
<div> op monitor interval="53s" role="Master" \</div><div> op monitor interval="60s" role="Slave"</div><div>ms MS_POSTGRESQL POSTGRESQL \</div><div> meta clone-max="2" target-role="Started" resource-stickiness="100" notify="true"</div>
<div>colocation link-resources inf: ZK UFO BOUM APACHE MS_POSTGRESQL</div><div>property $id="cib-bootstrap-options" \</div><div> dc-version="1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14" \</div>
<div> cluster-infrastructure="openais" \</div><div> expected-quorum-votes="2" \</div><div> stonith-enabled="false" \</div><div> no-quorum-policy="ignore" \</div>
<div> default-resource-stickiness="10" \</div><div> start-failure-is-fatal="false" \</div><div> last-lrm-refresh="1398775386"</div></div><div><br></div><div>Is this a normal behaviour ? If it is, is there a workaround I didn't think of ?</div>
<div><br></div><div><br></div><div><br></div></div>