check_postgres icon indicating copy to clipboard operation
check_postgres copied to clipboard

Adding check_streaming_delta

Open infraweavers opened this issue 6 years ago • 2 comments

We run a 4 node setup where we have a hot standby and a cascading replication setup like:

A -> B
|
C -> D

where A is the master.

We want to monitor the delays at various points seperately, i.e. A->B should have a low delta, whereas A->C can be longer, whereas C->D should also be low delta.

We couldn't get our desired monitoring with any of the existing checks so we had to add one.

This lets a pginstance be monitored based on receiving and sending WAL, so we can monitor the delay between our cascading replication servers. We've also added the ability to limit based on being in the same network as the cluster that's being checked from which is useful for checking only local replicas if you have a hub-and-spoke-style replication strategy.

infraweavers avatar Nov 21 '18 15:11 infraweavers

@turnstep Curious as to whether there is any feedback on this PR? Thanks

infraweavers avatar Jan 26 '21 02:01 infraweavers

Sorry, been to busy to look this over, will try this weekend.

turnstep avatar Jan 29 '21 19:01 turnstep