Re: Failover with MySQL
On Fri, Aug 17, 2001 at 11:01:26AM +0000, Buisson Olivier wrote:
> > > Hi,
> > >
> > > I would like to know if anybody have a solution to put 2 mysql server in
> > > failover.
> > > Does anybody have setting up such architecture ?
> > >
> > > To be more understood: I would like to setup 2 mysql server. One is a
> > > master and would take all requests. When it failed, the other server
> > > takes the hand and respond to the requets.
> > >
> > > If someone have already setup this, i'm very interessed by his
> > > experiment.
> > >
> > > Cheers,
> > > Olivier Buisson
> > >
> > > --
> > The latest versions of mysql supports a simple replication scheme. You
> > will need to run the mysql version from debian unstable, and I think there
> > is documentation there of how to do it. Have not tried it myself yet
> > though.
>
> MySQL replication is a part of my project but I'm really searching for a
> simple solution for failover with 2 servers. I'm searching for a
> testimonial of someone who have already setup such architecture.
>
It seems that drbd can do what you want. I haven't try it yet, but
it's more general solution for HA server.
it works also (or even better) with postgres.
Reply to: