MySQL Forums
Forum List  »  Replication

Re: automating backup in a replicate envrionment
Posted by: Peter Halliday
Date: January 11, 2005 05:26PM

Well, you can also use SHOW SLAVE STATUS to find out more useful info. It will tell you if both of the Slave threads (IO and SQL) are running. It will show you whether there was any errors and if so what they are. This can be useful because if you have multiple slaves and want to vote, you may use this info to determine who changes over. Even if you have just one, you may want to konw if there were errors before you switch to master, because there may have been data loss.

Options: ReplyQuote

Written By
Re: automating backup in a replicate envrionment
January 11, 2005 05:26PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.