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.

Technorati Tags:, , , , ,

You might also like:

  1. MySQL Toolkit version 896 released
  2. Why is MySQL more popular than PostgreSQL?
  3. Going to PostgreSQL Conference East

2 Responses to “MySQL Heartbeat supports PostgreSQL”


  1. 1 Scott Marlowe

    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…

  1. 1 Pythian Group Blog » Blog Archive » Log Buffer #70: a Carnival of the Vanities for DBAs

Leave a Reply

Please do not use this blog to get help with problems or bugs in Maatkit or innotop: use the Sourceforge forums, mailing list, or bug trackers. If you're asking for help with MySQL, please use the MySQL mailing list instead.