Thank you.
But then how can mysql replication be used for high availability? If I
always rely on 1 master only, what happens if the master goes down?
I've tried two-way master-slave and I understand there are problems. :-(
On Wed, 18 Jul 2001, Warren van der Merwe wrote:
> Hi Ricardo
>
> >From my opinion, and yet again the pro's may dispute it, I understand what
> you actually want is a two way slave situation, in that way, when one goes
> down the second is there to take over, and when server1 comes back up if
> will update itself's from server2 and carry on. The rest of (front end web,
> or app or whatever) is upto you, you will need to configure your app to use
> server1 when available or server2.
>
> two way replication is set up by setting server2 as a slave to server1, and
> vice versa.
>
> THe scenario you describe will not work, because when server1 comes back up
> it will not have the changes that has occured since Server2 took over.
>
> Beware though, two way replication causes serious issues with
> auto-numbering, and it is best to handle this yourself, in my opinion.
>
> Regards
> Warren
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Warren van der Merwe
> Software Director
> PRT Trading (Pty) Ltd t/a RedTie
> Durban, South Africa
> Cell (+27-83) 262-9163
> Office (+27-31) 767-0249
>
>
> > -----Original Message-----
> > From: Ricardo Kleemann [mailto:[EMAIL PROTECTED]]
> > Sent: 18 July 2001 19:37
> > To: [EMAIL PROTECTED]
> > Subject: how to elect slave as master?
> >
> >
> >
> > Hi everyone,
> >
> > I'm wondering how I should configure my.cnf if I have a master-slave
> > scenario where I would like to declare the slave master if
> > the master goes
> > down.
> >
> > What I mean is, let's say I have 2 database servers:
> >
> > server1 = master
> > server2 = slave
> >
> > so normally my.cnf for server2 would have server1 configured as
> > master-host, and server1 would not have any master database
> > server configured.
> >
> > So assuming server1 goes down, I'd have to declare server2 as
> > master, and
> > have it no longer use the "master-host".
> >
> > My confusion is mostly with server1. When it comes back up, how is it
> > supposed to work? Is it supposed to suddenly become a slave?
> > Or does it
> > again come up as master and then server2 relinquishes its
> > master status?
> >
> > How can all of this be done automatically? It seems a little
> > confusing to
> > me to have to have all this automatic switching...
> >
> > HELP! :-)
> >
> > Ricardo
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
