<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" ><div style="font-size:medium;font-family:Calibri, sans-serif;" >Hello Team,</div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" > </div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" >We have been recently experimenting with some resource model options to fulfil the following scenario. We would like to collocate a virtual IP resource with multiple db resources. When the virtual IP fails over to another node, all the dbs associated should also fail over to the new node. We were able to accomplish this with resource sets as defined in Example 6.17 in this documentation page: <a href="https://clusterlabs.org/pacemaker/doc/en-US/Pacemaker/1.1/html-single/Pacemaker_Explained/index.html#s-resource-sets-colocation" style="color:rgb(149, 79, 114);" >https://clusterlabs.org/pacemaker/doc/en-US/Pacemaker/1.1/html-single/Pacemaker_Explained/index.html#s-resource-sets-colocation</a>. However, whenever a single db fails over to the other node, the virtual IP address and the other dbs are not following and failing over to the other node. Are there any configurations that may be causing this undesired behaviour? We have already tried resource sets, colocation constraints, and ordering constraints. Are there any other models that we should consider to achieve this solution? Our current constraint model looks like this in a simplified manner.</div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" > </div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" ><rsc_colocation id="vip-with-multiple-dbs" score="INFINITY" ></div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;" ><resource_set id="db-set" role=”Master”></div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;text-indent:36pt;" ><resource_ref id="db1"/> </div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;text-indent:36pt;" ><resource_ref id="db2"/></div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;text-indent:36pt;" ><resource_ref id="db3"/> </div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;text-indent:36pt;" ><resource_ref id="db4"/></div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;" ></resource_set></div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;" ><resource_set id="vip-set"></div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;text-indent:36pt;" ><resource_ref id="primary-VIP"/></div>
<div style="margin:0cm 0cm 0cm 36pt;font-size:medium;font-family:Calibri, sans-serif;" ></resource_set></div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" ></rsc_colocation></div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" > </div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" >Thanks,</div>
<div style="font-size:medium;font-family:Calibri, sans-serif;" >Abithan</div></div></div><BR>