<html><head></head><body bgcolor="#FFFFFF"><div>Why's evicted terrible? It optional and simply removes the slave node from the cluster if it's lagging too far behind the master. The collocation IP can float to another slave in the cluster or go offline. I thought that's what you're looking for. I can post a config if you're interested.</div><div><br>Sent from my iPhone</div><div><br>On Nov 12, 2011, at 11:51 AM, Yves Trudeau <<a href="mailto:y.trudeau@videotron.ca">y.trudeau@videotron.ca</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
Hi, <br>
Setting evict_outdated_slaves is terrible but then how do you
remove the read VIPs from slaves that are outdated. If there is a
way to do it, tell me :) I am always open to do things in a simpler
way. This solution works without evicting outdated slaves. The
current mysql RA does behave correctly HA wise but it is less than
optimal database wise. I mean in small installations it is probably
ok, but at Percona, I hit many high end installations where the
current behavior is not adequate. I consider myself more as a
database specialist than an HA one so I may be more sensitive to
these problems. <br>
<br>
Regards, <br>
<br>
Yves<br>
<br>
On 11-11-12 09:19 AM, Michael Marrotte wrote:
<blockquote cite="mid:CA+EJDnA2ePgo9PQ3OT0tUmzZS7-mTKuvr7Ab8m57DrRjrWABmA@mail.gmail.com" type="cite">Are you using <span class="s">evict_outdated_slaves</span>?<br>
<pre><div style="background-color: transparent;" class="line" id="LC296"><span class="s"><parameter name="evict_outdated_slaves" unique="0" required="0"></span></div>
<div style="background-color: transparent;" class="line" id="LC297"><span class="s"><longdesc lang="en"></span></div><div style="background-color: transparent;" class="line" id="LC298"><span class="s">If set to true, any slave which is more than max_slave_lag seconds</span></div>
<div style="background-color: transparent;" class="line" id="LC299"><span class="s">behind the master has its MySQL instance shut down. If this parameter</span></div><div style="background-color: transparent;" class="line" id="LC300">
<span class="s">is set to false in a primitive or clone resource, it is simply</span></div><div style="background-color: transparent;" class="line" id="LC301"><span class="s">ignored. If set to false in a master/slave resource, then exceeding</span></div>
<div style="background-color: transparent;" class="line" id="LC302"><span class="s">the maximum slave lag will merely push down the master preference so</span></div><div style="background-color: transparent;" class="line" id="LC303">
<span class="s">the lagging slave is never promoted to the new master.</span></div><div style="background-color: transparent;" class="line" id="LC304"><span class="s"></longdesc></span></div><div style="background-color: transparent;" class="line" id="LC305">
<span class="s"><shortdesc lang="en">Determines whether to shut down badly lagging</span></div><div style="background-color: transparent;" class="line" id="LC306"><span class="s">slaves</shortdesc></span></div>
<div style="background-color: transparent;" class="line" id="LC307"><span class="s"><content type="boolean" default="${OCF_RESKEY_evict_outdated_slaves_default}" /></span></div><div style="background-color: transparent;" class="line" id="LC308">
<span class="s"></parameter></span></div></pre>
<br>
<br>
<div class="gmail_quote">On Fri, Nov 11, 2011 at 9:57 PM, Yves
Trudeau <span dir="ltr"><<a moz-do-not-send="true" href="mailto:y.trudeau@videotron.ca">y.trudeau@videotron.ca</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000"> Because that's not
enough, if a slave lags behind too much, I want to remove
the vip but not stop the slave. <br>
<div>
<div class="h5"> <br>
On 11-11-11 06:12 PM, Michael Marrotte wrote:
<blockquote type="cite">Why don't you simply colocate
VIP's with the master/slave roles?<br>
<br>
<div class="gmail_quote">On Fri, Nov 11, 2011 at 5:18
PM, Yves Trudeau <span dir="ltr"><<a moz-do-not-send="true" href="mailto:y.trudeau@videotron.ca" target="_blank">y.trudeau@videotron.ca</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt
0pt 0pt 0.8ex; border-left: 1px solid rgb(204,
204, 204); padding-left: 1ex;">Hi,<br>
I created a fork of the resource-agents and
modified the mysql RA to supports VIP. The
support for read/write VIPs is something that
currently limits the use of pacemaker to manage
mysql replication. I ran some basic tests on the
modified agent and it seems behaving sanely so far
but more tests will be needed (next week). I also
modified a few things in the RA that were not
optimal in my view. Here's the URL for my fork:<br>
<br>
git://<a moz-do-not-send="true" href="http://github.com/y-trudeau/resource-agents.git" target="_blank">github.com/y-trudeau/resource-agents.git</a><br>
<a moz-do-not-send="true" href="https://y-trudeau@github.com/y-trudeau/resource-agents.git" target="_blank">https://y-trudeau@github.com/y-trudeau/resource-agents.git</a><br>
<br>
In order to use it, you need to adapt the
pacemaker configuration, here's the one I am
using:<br>
<br>
<a moz-do-not-send="true" href="http://pastebin.com/QPJPWDhx" target="_blank">http://pastebin.com/QPJPWDhx</a><br>
<br>
Next, apart from running more tests, I want to do
the following:<br>
<br>
- review user privileges used, need to lower the
ones of replication_user<br>
- add support for MHA (<a moz-do-not-send="true" href="http://code.google.com/p/mysql-master-ha/" target="_blank">http://code.google.com/p/mysql-master-ha/</a>)<br>
- run a beautifier for more uniformity in style<br>
<br>
Reviews and comments are of course welcome.<br>
<br>
Regards,<br>
<br>
Yves<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a moz-do-not-send="true" href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a moz-do-not-send="true" href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a moz-do-not-send="true" href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a moz-do-not-send="true" href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a moz-do-not-send="true" href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
</blockquote>
</div>
<br>
<pre><fieldset></fieldset>
_______________________________________________
Pacemaker mailing list: <a moz-do-not-send="true" href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a>
<a moz-do-not-send="true" href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a>
Project Home: <a moz-do-not-send="true" href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a>
Getting started: <a moz-do-not-send="true" href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a>
Bugs: <a moz-do-not-send="true" href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a moz-do-not-send="true" href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a moz-do-not-send="true" href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a moz-do-not-send="true" href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a moz-do-not-send="true" href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a moz-do-not-send="true" href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
<br>
</blockquote>
</div>
<br>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Pacemaker mailing list: <a class="moz-txt-link-abbreviated" href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a>
<a class="moz-txt-link-freetext" href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a>
Project Home: <a class="moz-txt-link-freetext" href="http://www.clusterlabs.org">http://www.clusterlabs.org</a>
Getting started: <a class="moz-txt-link-freetext" href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a>
Bugs: <a class="moz-txt-link-freetext" href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a>
</pre>
</blockquote>
<br>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a></span><br><span><a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a></span><br><span></span><br><span>Project Home: <a href="http://www.clusterlabs.org">http://www.clusterlabs.org</a></span><br><span>Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a></span><br><span>Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a></span><br></div></blockquote></body></html>