Cédric Villemain cedric.villemain at dalibo.com
Mon Oct 29 02:29:07 PDT 2007
David Fetter a écrit :
> 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.nt.
>   
looking at the code, there is nothing very fantastic. It supports pg as 
it can support anything.

I personnaly get the same results with a table updated every second, and 
a munin graph grabing the last values from each node. Munin can do all 
the average I want.
>   
>> 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
>>     
>
>   



More information about the Slony1-general mailing list