<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Hi Guy, <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
DB2 is not configured for auto start. So that is ruled out. I had some errors in shell script. Just solved that issue and things are ok now.
<br>
<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Hi Reid, <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
I am like extremely new to pacemaker. I do not even know that ordered resource group is implicitly a constraint like behaviour.
<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
So I have to delete the constraint as per your suggestion. Also, I want the order in a different way.
<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Like <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
First halvmd then clxfs then db2inst then clusterip. <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Which is correct order of expectation. <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
I will correct and resend the files. <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Please let me know if it is okay. <br>
<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Thanks. <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0px; padding: 0px; font-family: sans-serif; font-size: 11pt; color: black; text-align: left;">
Harish P <br>
<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
<span id="OutlookSignature">
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Get <a href="https://aka.ms/ghei36">Outlook for Android</a></div>
</span><br>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Users <users-bounces@clusterlabs.org> on behalf of Reid Wahl <nwahl@redhat.com><br>
<b>Sent:</b> Thursday, December 3, 2020 6:49:43 AM<br>
<b>To:</b> Cluster Labs - All topics related to open-source clustering welcomed <users@clusterlabs.org><br>
<b>Subject:</b> Re: [ClusterLabs] Question on restart of resource during fail over</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">How did you resolve the issue? I see a problem in the CIB, and it may<br>
be related to the issue you encountered. Even if not, it may cause<br>
other issues later.<br>
<br>
You have the following resource group:<br>
<br>
<group id="halvm"><br>
<primitive class="ocf" id="ClusterIP" provider="heartbeat"<br>
type="IPaddr2"><br>
</primitive><br>
<primitive class="ocf" id="halvmd" provider="heartbeat" type="LVM"><br>
</primitive><br>
<primitive class="ocf" id="clxfs" provider="heartbeat"<br>
type="Filesystem"><br>
</primitive><br>
<primitive class="ocf" id="db2inst" provider="db2luwacademy"<br>
type="db2server"><br>
</primitive><br>
</group><br>
<br>
You have the following colocation constraint set:<br>
<br>
<rsc_colocation id="colocation_set_dthdcs" score="INFINITY"><br>
<resource_set id="colocation_set_dthdcs_set"><br>
<resource_ref id="db2inst"/><br>
<resource_ref id="halvmd"/><br>
<resource_ref id="clxfs"/><br>
<resource_ref id="ClusterIP"/><br>
</resource_set><br>
</rsc_colocation><br>
<br>
The group says "place ClusterIP, then place halvmd, then place clxfs,<br>
then place db2inst".<br>
The constraint set says "place db2inst, then place halvmd, then place<br>
clxfs, then place ClusterIP"[1].<br>
<br>
A resource group is already an implicit set of ordering and colocation<br>
constraints[2]. If you're happy with the order configured in the<br>
resource group, then you should remove the colocation_set_dthdcs<br>
constraint.<br>
<br>
[1] Example 5.15. Equivalent colocation chain expressed using<br>
resource_set (<a href="https://clusterlabs.org/pacemaker/doc/en-US/Pacemaker/2.0/html-single/Pacemaker_Explained/index.html#idm46061107170640">https://clusterlabs.org/pacemaker/doc/en-US/Pacemaker/2.0/html-single/Pacemaker_Explained/index.html#idm46061107170640</a>)<br>
[2] 10.1. Groups - A Syntactic Shortcut<br>
(<a href="https://clusterlabs.org/pacemaker/doc/en-US/Pacemaker/2.0/html-single/Pacemaker_Explained/index.html#group-resources">https://clusterlabs.org/pacemaker/doc/en-US/Pacemaker/2.0/html-single/Pacemaker_Explained/index.html#group-resources</a>)<br>
<br>
On Wed, Dec 2, 2020 at 4:01 AM Harishkumar Pathangay<br>
<harishpathangay@outlook.com> wrote:<br>
><br>
> Hi,<br>
><br>
> I realized it can be used in standard mode only after you pointing to that.<br>
><br>
> Anyways, writing custom agent always gives me a good understanding of the resources start/stop/monitor etc…<br>
><br>
> My custom agent still has lot of “hard coded” values, but it is meant for studying and understanding purposes rather than to put in a production machine.<br>
><br>
><br>
><br>
> Please find attachments.<br>
><br>
><br>
><br>
> Thanks,<br>
><br>
> Harish P<br>
><br>
><br>
><br>
> Sent from Mail for Windows 10<br>
><br>
><br>
><br>
> From: Reid Wahl<br>
> Sent: 02 December 2020 15:55<br>
> To: Cluster Labs - All topics related to open-source clustering welcomed<br>
> Subject: Re: [ClusterLabs] Question on restart of resource during fail over<br>
><br>
><br>
><br>
> On Wed, Dec 2, 2020 at 2:16 AM Harishkumar Pathangay<br>
> <harishpathangay@outlook.com> wrote:<br>
> ><br>
> > Just got the issue resolved.<br>
><br>
> Nice work!<br>
><br>
> > Any case I will send the cib.xml and my custom db2 resource agent.<br>
> ><br>
> > The existing resource agent is for HADR database, where there are two databases one running as Primary and other as standby.<br>
><br>
> HADR is only one option. There's also a standard mode:<br>
> - <a href="https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2#L64-L69">
https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2#L64-L69</a><br>
><br>
> I don't know much about DB2, so I'm not sure whether that would meet<br>
> your needs. Based on the metadata, standard mode appears to manage a<br>
> single instance (with the databases you select) on one node at a time.<br>
><br>
> > I have created a script which will start/stop db2 instances with a single database on shared logical volume [HA-LVM] exclusively activated on one node.<br>
> ><br>
> ><br>
> ><br>
> > Will mail you shortly.<br>
> ><br>
> ><br>
> ><br>
> > Thanks,<br>
> ><br>
> > Harish P<br>
> ><br>
> ><br>
> ><br>
> > Sent from Mail for Windows 10<br>
> ><br>
> ><br>
> ><br>
> > From: Reid Wahl<br>
> > Sent: 02 December 2020 12:46<br>
> > To: Cluster Labs - All topics related to open-source clustering welcomed<br>
> > Subject: Re: [ClusterLabs] Question on restart of resource during fail over<br>
> ><br>
> ><br>
> ><br>
> > Can you share your pacemaker configuration (i.e.,<br>
> > /var/lib/pacemaker/cib/cib.xml)? If you're concerned about quorum,<br>
> > then also share your /etc/corosync/corosync.conf just in case.<br>
> ><br>
> > Also there's a db2 resource agent already written, if you're interested:<br>
> > - <a href="https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2">
https://github.com/oalbrigt/resource-agents/blob/master/heartbeat/db2</a><br>
> ><br>
> > On Tue, Dec 1, 2020 at 9:50 AM Harishkumar Pathangay<br>
> > <harishpathangay@outlook.com> wrote:<br>
> > ><br>
> > > Hi,<br>
> > ><br>
> > > I have DB2 resource agent scripted by myself.<br>
> > ><br>
> > > It is working fine with a small glitch.<br>
> > ><br>
> > ><br>
> > ><br>
> > > I have node1 and node2 in the cluster. No stonith enabled as I don't need one. The environment is for learning purpose only.<br>
> > ><br>
> > ><br>
> > ><br>
> > > If node one is down [power off], it is starting the resource on other node which is good. My custom resource agent doing its job. Let us say DB2 is running with pid 4567.<br>
> > ><br>
> > ><br>
> > ><br>
> > > Now, the original node which went down is back again. I issue “pcs cluster start” on the node. Node is online. The resource also stays in the other node, which is again good. That way unnecessary movement of resources is avoided, exactly what I want.
Good but there is a issue.<br>
> > ><br>
> > > On the other node it is restarting the DB2 resource. So my pid of db2 changes to 3452.<br>
> > ><br>
> > > This is unnecessary restart of resource which I want to avoid.<br>
> > ><br>
> > > How to I get this working.<br>
> > ><br>
> > ><br>
> > ><br>
> > > I am very new to cluster pacemaker.<br>
> > ><br>
> > > Please help me so that I can create a working DB2 cluster for my learning purpose.<br>
> > ><br>
> > > Also I will be blogging in my youtube channel DB2LUWACADEMY.<br>
> > ><br>
> > > Please any help is of great significance to me.<br>
> > ><br>
> > ><br>
> > ><br>
> > > I think it could be quorum issue. But don't know for sure, because there is only two nodes and DB2 resource needs to be active only in one node.<br>
> > ><br>
> > ><br>
> > ><br>
> > > How do I get this configured.<br>
> > ><br>
> > ><br>
> > ><br>
> > > Thanks.<br>
> > ><br>
> > > Harish P<br>
> > ><br>
> > ><br>
> > ><br>
> > ><br>
> > ><br>
> > > Sent from Mail for Windows 10<br>
> > ><br>
> > ><br>
> > ><br>
> > > _______________________________________________<br>
> > > Manage your subscription:<br>
> > > <a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
> > ><br>
> > > ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Regards,<br>
> ><br>
> > Reid Wahl, RHCA<br>
> > Senior Software Maintenance Engineer, Red Hat<br>
> > CEE - Platform Support Delivery - ClusterHA<br>
> ><br>
> > _______________________________________________<br>
> > Manage your subscription:<br>
> > <a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
> ><br>
> > ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><br>
> ><br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Manage your subscription:<br>
> > <a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
> ><br>
> > ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><br>
><br>
><br>
><br>
> --<br>
> Regards,<br>
><br>
> Reid Wahl, RHCA<br>
> Senior Software Maintenance Engineer, Red Hat<br>
> CEE - Platform Support Delivery - ClusterHA<br>
><br>
> _______________________________________________<br>
> Manage your subscription:<br>
> <a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
><br>
> ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><br>
><br>
><br>
><br>
> _______________________________________________<br>
> Manage your subscription:<br>
> <a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
><br>
> ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><br>
<br>
<br>
<br>
-- <br>
Regards,<br>
<br>
Reid Wahl, RHCA<br>
Senior Software Maintenance Engineer, Red Hat<br>
CEE - Platform Support Delivery - ClusterHA<br>
<br>
_______________________________________________<br>
Manage your subscription:<br>
<a href="https://lists.clusterlabs.org/mailman/listinfo/users">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
<br>
ClusterLabs home: <a href="https://www.clusterlabs.org/">https://www.clusterlabs.org/</a><br>
</div>
</span></font></div>
</body>
</html>