<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3132" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=947482221-26072007>Well, if you prevent mysql from starting on boot, your
load balancer should recognize that and not fail back to that server. We took
mysql itself out of the cluster since we also do replication. It was not
necessary to have it in there for our application.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial>
<DIV><SPAN class=981281519-26042007>
<DIV align=left><FONT face=Tahoma size=2><STRONG>
<DIV><SPAN class=981281519-26042007>
<DIV align=left><FONT face=Tahoma color=#000000 size=2><STRONG>Rob
Gil</STRONG></FONT></DIV>
<DIV align=left><FONT face=Tahoma color=#000000 size=2><STRONG>Linux Systems
Administrator</STRONG></FONT></DIV>
<DIV align=left><SPAN class=981281519-26042007><FONT face=Tahoma color=#000000
size=2><STRONG>American Home
Mortgage</STRONG></FONT></SPAN></DIV></SPAN></DIV></STRONG></FONT></DIV></SPAN></DIV></FONT></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> linux-cluster-bounces@redhat.com
[mailto:linux-cluster-bounces@redhat.com] <B>On Behalf Of </B>Bjorn
Oglefjorn<BR><B>Sent:</B> Thursday, July 26, 2007 4:33 PM<BR><B>To:</B> linux
clustering<BR><B>Subject:</B> Re: [Linux-cluster] MySQL Failover /
Failback<BR></FONT><BR></DIV>
<DIV></DIV>Thanks Rob, but that's not quite what I'm looking for. I have a
middleware script of my own which allows me to have both nodes with mysql
running at all times. I need to ensure that when the MASTER fails, Cluster
Suite will failover to the SLAVE. My script then performs some SQL ops to
allow writes, etc. When the MASTER comes back from being fenced, I need to
make sure that Cluster Suite does not failback to the MASTER. I'm hoping
that the 'nofailback' option exists and will work as I expect it to.
<BR><BR>--BO<BR><BR>
<DIV><SPAN class=gmail_quote>On 7/26/07, <B class=gmail_sendername>Robert
Gil</B> <<A
href="mailto:Robert.Gil@americanhm.com">Robert.Gil@americanhm.com</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">I
had figured this out a while back and forgot to post back to the list.<BR>The
steps are as follows<BR><BR>Create a child script to the virtual ip to check
whether mysql is up.<BR>Have mysql NOT start on boot.<BR><BR>With these two
things done. When the vip fails over, it will not fail <BR>back because mysql
wont be up.<BR><BR>Rob Gil<BR>Linux Systems Administrator<BR>American Home
Mortgage<BR><BR>________________________________<BR><BR>From: <A
href="mailto:linux-cluster-bounces@redhat.com">linux-cluster-bounces@redhat.com
</A><BR>[mailto:<A
href="mailto:linux-cluster-bounces@redhat.com">linux-cluster-bounces@redhat.com</A>]
On Behalf Of Bjorn Oglefjorn<BR>Sent: Thursday, July 26, 2007 3:18 PM<BR>To:
linux clustering<BR>Subject: Re: [Linux-cluster] MySQL Failover / Failback
<BR><BR><BR>I found that a 'nofailback' option was added for the
<failoverdomains><BR>section of the conf. I can't find any
reference to 'nofailback' in any<BR>RHCS doc I can find. I'm
guessing it should look like this:
<BR><BR> <failoverdomain name="test_failover_domain"
ordered="1"<BR>restricted="1"
nofailback="1"><BR> ...<BR> </failoverdomain><BR><BR>Can
someone confirm? I will attempt to confirm this myself and will
<BR>report back when I know for sure.<BR><BR>--BO<BR><BR><BR>On 7/26/07, Bjorn
Oglefjorn <<A
href="mailto:sys.mailing@gmail.com">sys.mailing@gmail.com</A>>
wrote:<BR><BR> I'd love to know
how to do this as well. Anyone?
<BR> --BO<BR><BR><BR><BR> On
6/1/07, Robert Gil <<A
href="mailto:Robert.Gil@americanhm.com">Robert.Gil@americanhm.com</A><BR><mailto:<A
href="mailto:Robert.Gil@americanhm.com">Robert.Gil@americanhm.com </A>>
>
wrote:<BR><BR> 1)
Node 1 (master)
dies<BR> -How
do we enable "sticky" failover so that it<BR>does not then fail back to Node
1<BR><BR><BR><BR>--<BR>Linux-cluster mailing list <BR><A
href="mailto:Linux-cluster@redhat.com">Linux-cluster@redhat.com</A><BR><A
href="https://www.redhat.com/mailman/listinfo/linux-cluster">https://www.redhat.com/mailman/listinfo/linux-cluster</A><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>