Re: checking status mysql replication HELP ?!?
Alexander Keremidarski <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hello all,
Brent,
Run SHOW MASTER STATUS on Master only and SHOW SLAVE STATUS on Slave respecively.
Mike Knox wrote:
> I've just implemented a quick and dirty check. As the master's updates are
> performed on the slave the file master.info gets updated. Depending on the
> frequency of updates to the master - you could just take a copy of
> master.info and then compare for differences - say every 15 minutes. Not
> elegant but it's Unix scriptable.
I don't see any benefit over checking SHOW SLAVE STATUS output.
Besides everything you must take care that nothing writes master.info except for
mysqld.
> Mike
--
Are you MySQL certified? -> http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <[email protected]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]