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

[Marian Marinov]

On Sunday 07 January 2007 00:40, Alexey Zilber wrote:
> 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?
Hello Alexey,
I have installed mysql over a DRBD 2 weeks ago and I'm currently testing it 
for entering in production.

For now the max downtime that I had during simulated server downs is 6-8min 
during the checking of a big innodb DB. I had no issues with databases using 
MyISAM.

Best regards,
  Marian

>
> 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
>
> _______________________________________________
> 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