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 href="mailto:y.trudeau@videotron.ca">y.trudeau@videotron.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><u></u>
<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 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 href="http://github.com/y-trudeau/resource-agents.git" target="_blank">github.com/y-trudeau/resource-agents.git</a><br>
<a 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 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 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 href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a 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 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 href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a>
Bugs: <a 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 href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a 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 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>