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">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;">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/<u></u>resource-agents.git</a><br>
<a href="https://y-trudeau@github.com/y-trudeau/resource-agents.git" target="_blank">https://y-trudeau@github.com/<u></u>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/<u></u>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>
______________________________<u></u>_________________<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/<u></u>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/<u></u>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-<u></u>foundation.org/enter_bug.cgi?<u></u>product=Pacemaker</a><br>
</blockquote></div><br>