Yeah. You should use mk-heartbeat, it's the best tool for this situation that I have seen before.
On Wed, Dec 24, 2008 at 10:06 PM, Baron Schwartz <ba...@xaprb.com> wrote: > On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul <jakem...@gmail.com> wrote: > > Slightly more complicated (and also probably more accurate- the time > > reported by show slave status is known to be unreliable in some cases) > > would be a script that inserts a row into a table, then check the > > slave over and over till it arrives. Or even better, insert 2 > > values... a timestamp that *you* provide (in a shell script, something > > like $(date) would work) and a timestamp generated by MySQL.... > > assuming the times are syncronized on the master, slave, and the box > > you're inserting from, when the insert hits the slave it'll generate > > it's own timestamp, which you can then subtract *your* timestamp from. > > > > There's also a tool in maatkit which does replication tracking, > > although I've not yet used it. Judging by the other tools in that > > package though, it's probably pretty decent :). > > It is mk-heartbeat, and it does pretty much what you described, > although it's been tweaked to be slightly more complex to suit various > real-world scenarios. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=yueliangdao0...@gmail.com > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
