Thanks to a patch Dane Miller submitted, MySQL Heartbeat can now be used to monitor Slony-I replication lag for PostgreSQL. It works identically: it updates a record on the master and looks for it on the slave. You just have to specify the database driver on the command-line:
mysql-heartbeat [options] --dbidriver=Pg
Most of the tools in the MySQL Toolkit are very MySQL-specific. This one just happened to be an exception, and I’m happy it’s useful for more than the original purpose.
Technorati Tags:Dane Miller, mysql, PostgreSQL, replication, Slony, sql
Interesting. I usually just check the views on the master and slave that say how far behind replication is without checking that the data really IS getting through. Sounds like another nice tool to put into the /usr/local/bin dir…