Xaprb

Stay curious!

MySQL Heartbeat supports PostgreSQL

with 2 comments

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.

Written by Xaprb

November 6th, 2007 at 8:19 pm

Posted in Perl, SQL, Tools

Tagged with , , , , ,

« Growth limits of open-source vis-a-vis MySQL Toolkit
MySQL Toolkit needs a new name »

2 Responses to 'MySQL Heartbeat supports PostgreSQL'

Subscribe to comments with RSS or TrackBack to 'MySQL Heartbeat supports PostgreSQL'.

  1. 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

  2. [...] 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

Leave a Reply