On Fri, Oct 26, 2007 at 11:46:06AM -0700, Dane Miller wrote:
> Hi Slony Folks,
> 
> I recently started administering a Postgres/Slony-1 cluster and wasn't
> satisfied with the replication monitoring scripts in Slony's tools/
> directory.  So I turned to the very fine mysql-heartbeat.  Thanks to
> some recent work by the author, as of revision 1104, mysql-heartbeat
> works great for Postgres too!  Just use the command line option
> --dbidriver=Pg.
> 
> Read about it here:
> http://mysqltoolkit.sourceforge.net/
> 
> And get it from SVN here (this feature is currently only in SVN):
> http://mysqltoolkit.svn.sourceforge.net/viewvc/mysqltoolkit/trunk/mysql-heartbeat/

Maybe I'm missing something obvious, but I don't see anything about
this in their documentation.  Any way to get it some prominence there?

Cheers,
David.

> 
> From the author:
> MySQL Heartbeat
> Monitors replication delay via a two-part process: a heartbeat on the
> master, and monitoring on the slave. It tells how far the slave is
> behind the master at the top of a replication hierarchy.... It produces
> moving averages over arbitrary time windows, so you can see on average
> how much your slave has lagged during the last 1, 5 and 15 minutes (by
> default — you can customize this). It can run as a daemon too.
> 
> Enjoy!
> Dane
> 
> -- 
> Dane Miller
> Systems Administrator
> Great Schools, Inc
> http://greatschools.net
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general

-- 
David Fetter <david at fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter at gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate