Because that's not enough, if a slave lags behind too much, I want to remove the vip but not stop the slave.

On 11-11-11 06:12 PM, Michael Marrotte wrote:
Why don't you simply colocate VIP's with the master/slave roles?

On Fri, Nov 11, 2011 at 5:18 PM, Yves Trudeau <y.trud...@videotron.ca <mailto:y.trud...@videotron.ca>> wrote:

    Hi,
      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:

    git://github.com/y-trudeau/resource-agents.git
    <http://github.com/y-trudeau/resource-agents.git>
    https://y-trud...@github.com/y-trudeau/resource-agents.git

    In order to use it, you need to adapt the pacemaker configuration,
    here's the one I am using:

    http://pastebin.com/QPJPWDhx

    Next, apart from running more tests,  I want to do the following:

    - review user privileges used, need to lower the ones of
    replication_user
    - add support for MHA  (http://code.google.com/p/mysql-master-ha/)
    - run a beautifier for more uniformity in style

    Reviews and comments are of course welcome.

    Regards,

    Yves




    _______________________________________________
    Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
    <mailto:Pacemaker@oss.clusterlabs.org>
    http://oss.clusterlabs.org/mailman/listinfo/pacemaker

    Project Home: http://www.clusterlabs.org
    Getting started:
    http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
    Bugs:
    http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker



_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker

_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker

Reply via email to