MySQL Heartbeat supports PostgreSQL
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.
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…
Scott Marlowe
9 Nov 07 at 12:46 pm
[...] also reports on an enhancement to the MySQL Heartbeat tool that allows it to support, of all things, [...]
Pythian Group Blog » Blog Archive » Log Buffer #70: a Carnival of the Vanities for DBAs
9 Nov 07 at 2:10 pm