[Bucardo-general] Monitoring Bucardo with PRTG

[Greg Sabino Mullane]

On Thu, Dec 17, 2015 at 04:09:17AM +0000, Jay Lee wrote:
...
> Because data changes are irregular, I cannot rely on the last good time 
> from the status command, since it may vary from minutes (during busy 
> work days) to days (weekends). Ideally, I would check the last good 
> time only if there are changes to replicate.
> 
> What tables should I query for such information? Or alternatively, 
> does a solution already exist for PRTG?

I have not heard of anyone using PRTG with it. As far as monitoring syncs, 
your best bet may be to simply scan the delta tables[1] for old entries. 
If they are old, it likely means a sync is failing. It's possible for 
delta records to exist after the sync is finished, as the asynchronous 
VAC process is responsible for cleaning that up, but in a normally-running 
Bucardo, that window should be small.

Another way would be to issue a kick on the syncs to monitor, and see what 
gets returned (or just check the status once it finishes). A sync with no 
rows to replicate will still show up as completed.

[1] See bucardo.bucardo_delta_names table

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20151222/68dadeaf/attachment.sig>