Showing entries 1 to 2
Displaying posts with tag: Kevin Burton (reset)
Nov
05
2007
MySQL Archiver can now archive each row to a different table
Posted by Baron Schwartz (xaprb) on Mon 05 Nov 2007 13:28 UTC
Tags:

One of the enhancements I added to MySQL Archiver in the recent release was listed innocently in the changelog as "Destination plugins can now rewrite the INSERT statement." Not very exciting or informative, huh? Keep reading.

Oct
01
2007
How to measure MySQL slave lag accurately
Posted by Baron Schwartz (xaprb) on Mon 01 Oct 2007 02:38 UTC
Tags:

Kevin Burton wrote recently about why SHOW SLAVE STATUS is really not a good way to monitor how far behind your slave servers are, and how slave network timeouts can mess up the slave lag. I'd like to chime in and say this is exactly why I thought Jeremy Cole's MySQL Heartbeat script was such a natural fit for the MySQL Toolkit. It measures slave lag in a "show me the money" way: it looks for the effects of up-to-date replication, rather than asking the slave how far behind it thinks it is.

The slave doesn't even need to be running. In …

[Read more]
Showing entries 1 to 2