If the master crashes, you can move the ip of you master to the slave machine and it can become the new master. However, to move back to teh master, you will need to copy the stuff back to the master.
There's some good information in the manual about how to plan disaster recovery: http://www.mysql.com/doc/R/e/Replication_FAQ.html [EMAIL PROTECTED] wrote: > > How about if master crashes?...is there anyway to recover?...aside from > copying all stuff from slave to master... > > R.B.Roa > PhilCom Corporation > Tel. No. 858-xxxx > Mobile No. (63) (919-xxxxxxx) > > -----Original Message----- > From: Davide Giunchi [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 10, 2002 5:37 PM > To: Marc Prewitt > Cc: [EMAIL PROTECTED] > Subject: Re: binlog and replication stuff > > You are right, but my master generate about 150Mb of binlog x day, i > a slave > fail after 4 day it will reexec a lot of query and take some time. > how can i > safely rotate the log in master+slaves without restarting them? > The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 > (or > 001) > file, but what about if the binlog is always the same? > I could do a FLUSH MASTER in the master and then FLUSH SLAVE in the > slaves, > it wouldn't loose the sync? > > Regards > > > When a slave crashes or reboots, it should start replicating from > where it > > left off--at least ours do work that way. The current replication > state > > is saved in master.info on the slave and when it starts up again, > it > > should read that file and resume reading the binlog on the master > where it > > left off. The master.info file contains the binlog#, location, > user, > > password, etc... neccessary to restart replication. > > > > In you case, does the slave give you any error messages in it's > error log > > about why it couldn't resume replication? If it doesn't try to > start > > replication, have you tried doing a 'slave start' on the slave > after it > > reboots? > > > > -Marc > > -- --------------------------------------------------------------------- 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
