[Bucardo-general] Monitoring Bucardo with PRTG
Greg Sabino Mullane
greg at endpoint.com
Tue Dec 22 15:44:11 UTC 2015
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 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.
 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...
Size: 163 bytes
Desc: not available
More information about the Bucardo-general