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

[Vinicius Garcia D'Avila Menezes]

On Sun, 2007-01-07 at 00:59 +0200, Marian Marinov wrote:
> 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.
> 

Hi marian.

How are you dealing with table corruption on mysql? If the database
corrupts on one node drdb will replicarte de currupted database to the
other node.

... Vinicius Menezes ...



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