High Performance MySQL ch 7 provides one of the solutions on that. Look for check_repl. http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
On Feb 3, 2008 2:58 AM, Brown, Charles <[EMAIL PROTECTED]> wrote: > Can someone please tell me what is the most effective or preferred > method for monitoring replication in MySQL. Recently, my replication > stopped as a result of duplicate row found in the slave. Therefore, I > would like to monitor and send out an email or alert whenever it is > down. > > > > Every so often, I would logon to MySQl and issue this command: "SHOW > SLAVE STATUS". I would like to automate this process. I would like to > parse the output of this command and look pertinent info such as > "seconds_behind_master" < 10. If it greater than 10, then I'll send out > an email saying replication is in error. > > > > Charles > > > ******************************************** > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and CONFIDENTIAL. > > If you are not the intended recipient, you are hereby notified > that any dissemination of this communication is strictly prohibited. > > If you have received this communication in error, please erase > all copies of the message and its attachments and notify us > immediately. > > Thank you. > ******************************************** > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
