Mon Oct 29 02:29:07 PDT 2007
- Previous message: [Slony1-general] monitoring slony delay with mysql-heartbeat
- Next message: [Slony1-general] Mysterious "node -1" blocking copy set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 >> > >
- Previous message: [Slony1-general] monitoring slony delay with mysql-heartbeat
- Next message: [Slony1-general] Mysterious "node -1" blocking copy set
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list