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
