<font face="Calibri, sans-serif"><span style="font-size:15px">Afternoon all,</span></font><div><font face="Calibri, sans-serif"><span style="font-size:15px"><br></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px">We're cutting over from OpenSUSE and straight heartbeat based on ext3 (two node active passive) to SLES, Pacemaker / Corosync, and OCFS2 in a split role active/passive configuration (three databases, two on one server and one on the other which can fail over to each other).</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size:15px"><br></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px">As this is my first experience with the new Pacemaker / Corosync stack and OCFS2 I would like to get the configuration validated by more experienced users to ensure there will be no big issues.</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size:15px"><br></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px">Also I have some related queries:</span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px">1) On a latest gen x86 IBM server what is the best / appropriate STONITH resource to use for control via the built in IMM interface ?</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size:15px">2) Is there an OCF compliant resource agent for JavaDB / Derby ? Currently am using a nasty init script for its start / stop. I can't seem to find one anywhere.</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size:15px">3) Does the use of a group command negate the use of a colocation command ?</span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px">4) Do you have to be very careful around the timeout values specified for timeouts relative to things like SAN multipath failover times, bonded interface convergence times and OCFS2 / filesystem related timeouts ? ie: Can Pacemaker end up with things chasing their tail, small blip in connectivity turns into a major ?</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size:15px"><br></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px">Also an unrelated query which I'm sure somebody will know:</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size:15px">5) Is the use of CLVM mandatory for the OCFS2 filesystem, or is it simply used if you wish to use logical volumes with online resizing capability ?</span></font></div>
<div><font face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;">6) Is there danger in having a SAN disk visible to two servers at once (with non clustered filesystem such as ext3) but only ever mounted on one ? This is the scenario we will be using and ext3 gives performance gains over OCFS2 so if there is no danger it would be preferable to use.</span></font></div>
<div><font face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;"><br></span></font></div><div><font face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;">Current config is as per the below for review:</span></font></div>
<div><font face="Calibri, sans-serif"><span style="font-size:15px"><br></span></font></div><div><font face="Calibri, sans-serif"><span style="font-size:15px"><div>node company-prod-db-001</div><div>node company-prod-db-002</div>
<div>primitive DERBYDB lsb:derby</div><div>primitive FS_DB_DEPOT ocf:heartbeat:Filesystem \</div><div> params device="-LDB_DEPOT" directory="/DB_DEPOT" fstype="ocfs2" options="acl" \</div>
<div> op start interval="0" timeout="60" \</div><div> op stop interval="0" timeout="60"</div><div>primitive FS_DB_ESP_AUDIT ocf:heartbeat:Filesystem \</div><div> params device="-LDB_ESP_AUDIT" directory="/DB_ESP_AUDIT" fstype="ocfs2" options="acl" \</div>
<div> op start interval="0" timeout="60" \</div><div> op stop interval="0" timeout="60"</div><div>primitive FS_LOGS_DEPOT ocf:heartbeat:Filesystem \</div><div> params device="-LLOGS_DEPOT" directory="/LOGS_DEPOT" fstype="ocfs2" options="data=writeback,noatime,acl" \</div>
<div> op start interval="0" timeout="60" \</div><div> op stop interval="0" timeout="60"</div><div>primitive FS_LOGS_ESP_AUDIT ocf:heartbeat:Filesystem \</div><div> params device="-LLOGS_ESP_AUDIT" directory="/LOGS_ESP_AUDIT" fstype="ocfs2" options="data=writeback,noatime,acl" \</div>
<div> op start interval="0" timeout="60" \</div><div> op stop interval="0" timeout="60"</div><div>primitive IP_DEPOT_15 ocf:heartbeat:IPaddr2 \</div><div> params ip="192.168.15.93" cidr_netmask="24" \</div>
<div> op monitor interval="30s"</div><div>primitive IP_DEPOT_72 ocf:heartbeat:IPaddr2 \</div><div> params ip="192.168.72.93" cidr_netmask="24" \</div><div> op monitor interval="30s"</div>
<div>primitive IP_ESP_AUDIT_15 ocf:heartbeat:IPaddr2 \</div><div> params ip="192.168.15.92" cidr_netmask="24" \</div><div> op monitor interval="30s"</div><div>primitive IP_ESP_AUDIT_72 ocf:heartbeat:IPaddr2 \</div>
<div> params ip="192.168.72.92" cidr_netmask="24" \</div><div> op monitor interval="30s"</div><div>primitive PGSQL_AUDIT ocf:heartbeat:pgsql.audit \</div><div> op start interval="0" timeout="120" \</div>
<div> op stop interval="0" timeout="120"</div><div>primitive PGSQL_DEPOT ocf:heartbeat:pgsql.depot \</div><div> op start interval="0" timeout="120" \</div><div> op stop interval="0" timeout="120"</div>
<div>primitive PGSQL_ESP ocf:heartbeat:pgsql.esp \</div><div> op start interval="0" timeout="120" \</div><div> op stop interval="0" timeout="120"</div><div>group DEPOT FS_LOGS_DEPOT FS_DB_DEPOT IP_DEPOT_15 IP_DEPOT_72 DERBYDB PGSQL_DEPOT</div>
<div>group ESP_AUDIT FS_LOGS_ESP_AUDIT FS_DB_ESP_AUDIT IP_ESP_AUDIT_15 IP_ESP_AUDIT_72 PGSQL_AUDIT PGSQL_ESP</div><div>location LOC_DEPOT DEPOT 25: company-prod-db-001</div><div>location LOC_ESP_AUDIT ESP_AUDIT 25: company-prod-db-002</div>
<div>property $id="cib-bootstrap-options" \</div><div> dc-version="1.1.2-2e096a41a5f9e184a1c1537c82c6da1093698eb5" \</div><div> cluster-infrastructure="openais" \</div><div> expected-quorum-votes="2" \</div>
<div> no-quorum-policy="ignore" \</div><div> stonith-enabled="false" \</div><div> start-failure-is-fatal="false"</div><div>rsc_defaults $id="rsc-options" \</div>
<div> resource-stickiness="100"</div></span></font></div>