Re: automating backup in a replicate envrionment
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.
Subject
Views
Written By
Posted
3881
January 10, 2005 04:49PM
2684
January 10, 2005 05:04PM
Re: automating backup in a replicate envrionment
2492
January 11, 2005 05:26PM
2747
January 11, 2005 11:19PM
2831
January 12, 2005 10:08AM
2660
January 18, 2005 12:33PM
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.