<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Roboto;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Not even if a mysql resource fails to stop?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Strahil Nikolov <hunter86_bg@yahoo.com> <br>
<b>Sent:</b> Sunday, June 6, 2021 3:27 AM<br>
<b>To:</b> Cluster Labs - All topics related to open-source clustering welcomed <users@clusterlabs.org>; Eric Robinson <eric.robinson@psmnv.com><br>
<b>Subject:</b> Re: [ClusterLabs] One Failed Resource = Failover the Cluster?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Based on the constraint rules you have mentioned , failure of mysql should not cause a failover to another node. For better insight, you have to be able to reproduce the issue and share the logs with the community.<o:p></o:p></p>
<div id="yMail_cursorElementTracker_1622967988831">
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div id="yMail_cursorElementTracker_1622967989040">
<p class="MsoNormal">Best Regards,<o:p></o:p></p>
</div>
<div id="yMail_cursorElementTracker_1622967992948">
<p class="MsoNormal" style="margin-bottom:12.0pt">Strahil Nikolov<o:p></o:p></p>
<blockquote style="margin-left:0in;margin-right:0in;margin-bottom:15.0pt">
<div>
<div>
<p class="MsoNormal"><span style="font-family:Roboto;color:#6D00F6">On Sat, Jun 5, 2021 at 23:33, Eric Robinson<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Roboto;color:#6D00F6"><<a href="mailto:eric.robinson@psmnv.com">eric.robinson@psmnv.com</a>> wrote:<o:p></o:p></span></p>
</div>
</div>
<div style="border:none;border-left:solid #6D00F6 1.0pt;padding:0in 0in 0in 15.0pt;margin-top:7.5pt">
<p class="MsoNormal">> -----Original Message-----<br>
> From: Users <<a href="mailto:users-bounces@clusterlabs.org">users-bounces@clusterlabs.org</a>> On Behalf Of<br>
> <a href="mailto:kgaillot@redhat.com">kgaillot@redhat.com</a><br>
> Sent: Friday, June 4, 2021 4:49 PM<br>
> To: Cluster Labs - All topics related to open-source clustering welcomed<br>
> <<a href="mailto:users@clusterlabs.org">users@clusterlabs.org</a>><br>
> Subject: Re: [ClusterLabs] One Failed Resource = Failover the Cluster?<br>
><br>
> On Fri, 2021-06-04 at 19:10 +0000, Eric Robinson wrote:<br>
> > Sometimes it seems like Pacemaker fails over an entire cluster when<br>
> > only one resource has failed, even though no other resources are<br>
> > dependent on it. Is that expected behavior?<br>
> ><br>
> > For example, suppose I have the following colocation constraints…<br>
> ><br>
> > filesystem with drbd master<br>
> > vip with filesystem<br>
> > mysql_01 with filesystem<br>
> > mysql_02 with filesystem<br>
> > mysql_03 with filesystem<br>
><br>
> By default, a resource that is colocated with another resource will influence<br>
> that resource's location. This ensures that as many resources are active as<br>
> possible.<br>
><br>
> So, if any one of the above resources fails and meets its migration- threshold,<br>
> all of the resources will move to another node so a recovery attempt can be<br>
> made for the failed resource.<br>
><br>
> No resource will be *stopped* due to the failed resource unless it depends<br>
> on it.<br>
><br>
<br>
Thanks, but I'm confused by your previous two paragraphs. On one hand, "if any one of the above resources fails and meets its migration- threshold, all of the resources will move to another node." Obviously moving resources requires stopping them. But then,
"No resource will be *stopped* due to the failed resource unless it depends on it." Those two statements seem contradictory to me. Not trying to be argumentative. Just trying to understand.<br>
<br>
> As of the forthcoming 2.1.0 release, the new "influence" option for<br>
> colocation constraints (and "critical" resource meta-attribute) controls<br>
> whether this effect occurs. If influence is turned off (or the resource made<br>
> non-critical), then the failed resource will just stop, and the other resources<br>
> won't move to try to save it.<br>
><br>
<br>
That sounds like the feature I'm waiting for. In the example configuration I provided, I would not want the failure of any mysql instance to cause cluster failover. I would only want the cluster to failover if the filesystem or drbd resources failed. Basically,
if a resource breaks or fails to stop, I don't want the whole cluster to failover if nothing depends on that resource. Just let it stay down until someone can manually intervene. But if an underlying resource fails that everything else is dependent on (drbd
or filesystem) then go ahead and failover the cluster.<br>
<br>
> ><br>
> > …and the following order constraints…<br>
> ><br>
> > promote drbd, then start filesystem<br>
> > start filesystem, then start vip<br>
> > start filesystem, then start mysql_01<br>
> > start filesystem, then start mysql_02<br>
> > start filesystem, then start mysql_03<br>
> ><br>
> > Now, if something goes wrong with mysql_02, will Pacemaker try to fail<br>
> > over the whole cluster? And if mysql_02 can’t be run on either<br>
> > cluster, then does Pacemaker refuse to run any resources?<br>
> ><br>
> > I’m asking because I’ve seen some odd behavior like that over the<br>
> > years. Could be my own configuration mistakes, of course.<br>
> ><br>
> > -Eric<br>
> --<br>
> Ken Gaillot <<a href="mailto:kgaillot@redhat.com">kgaillot@redhat.com</a>><br>
><br>
> _______________________________________________<br>
> Manage your subscription:<br>
> <a href="https://lists.clusterlabs.org/mailman/listinfo/users" target="_blank">
https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
><br>
> ClusterLabs home: <a href="https://www.clusterlabs.org/" target="_blank">https://www.clusterlabs.org/</a><br>
Disclaimer : This email and any files transmitted with it are confidential and intended solely for intended recipients. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this
email are solely those of the author and might not represent those of Physician Select Management. Warning: Although Physician Select Management has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility
for any loss or damage arising from the use of this email or attachments.<o:p></o:p></p>
<div id="yqtfd42435">
<p class="MsoNormal"><br>
_______________________________________________<br>
Manage your subscription:<br>
<a href="https://lists.clusterlabs.org/mailman/listinfo/users" target="_blank">https://lists.clusterlabs.org/mailman/listinfo/users</a><br>
<br>
ClusterLabs home: <a href="https://www.clusterlabs.org/" target="_blank">https://www.clusterlabs.org/</a><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
Disclaimer : This email and any files transmitted with it are confidential and intended solely for intended recipients. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this
email are solely those of the author and might not represent those of Physician Select Management. Warning: Although Physician Select Management has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility
for any loss or damage arising from the use of this email or attachments.
</body>
</html>