[Linux-HA] RE: One-way failover?

[Alexey Zilber]

Hi Eddie,

  I'm aware of 5.0 multi-master.  We actually had 4.1 setup as multi-master
(but using it as a master-slave).   The danger with this, is that at some
point someone executed some sql to drop the databases, then the vpn between
the servers was down.  Once that was fixed, you can imagine the carnage...

What about DRDB with mysql, is that doable?

I'll check out the sourceforge project on monday too.. thanks!

-Alex

On 1/6/07, Eddie C <edlinuxguru at gmail.com> wrote:
>
> There is a project on sourceforge called mysql-ha. Its not part of linux
> HA
> put it deals with switching servers from master to slave in the event of a
> failure. Seems like never mysql 5.0 with multi-master is a better way to
> go.
>
> There is a great article on onlamp about it. I posted it to this list a
> while back.
> Edward
>
> On 1/6/07, Luettgen, John (N-ENSCO) <john.luettgen at lmco.com> wrote:
> >
> > Alex, not configurable, but still possible.  Simply having the node "a"
> > not start HA, if the other node has the services running.  Not
> complicated
> > to do, just a bit of logic to consult the other node to check it state
> and
> > service.
> >
> > OK, John
> >
> >
> > From: "Alexey Zilber" <alexeyzilber at gmail.com>
> > Subject: [Linux-HA] One-way failover?
> > To: linux-ha at lists.linux-ha.org
> > Message-ID:
> >         <c42337150701051318q601001b7qcd1593517deafafc at mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> >
> > Hi All,
> >
> >   Is it possible to do a one-way failover with Heartbeat?  Here's the
> > scenario.  We are running mysql on node a and the slave on node b.  We
> > want
> > to failover one way, ie. node a fails, node b takes over.  If node b
> > fails,
> > regardless if node a is up or not, we don't want any services coming
> back
> > up.  This will allow us to move data back to the master (node a) and
> bring
> > it up manually.
> >
> > Is this scenario possible?
> >
> > Thanks!
> > Alex
> >
> > _______________________________________________
> > Linux-HA mailing list
> > Linux-HA at lists.linux-ha.org
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > See also: http://linux-ha.org/ReportingProblems
> >
> >
> _______________________________________________
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>