<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body 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>
<br>
On 11-11-11 06:12 PM, Michael Marrotte wrote:
<blockquote
cite="mid:CA+EJDnDEGkV+NGhV8Fdq-MRWMCtkaAXmrkUm78k8BLz5spuKEw@mail.gmail.com"
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">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 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>
</body>
</html>