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