Hi
I have a couple of items being monitored - specifically the streaming replication 'value' from the master and slave servers.
The results I get back are in hex, formatted something like this :
0x30AF84DC2F (the Master)
0x30AF84C43B (the Slave)
The difference between the two is 17F4(hex) (6132 bytes).
I need a trigger that will diff the two results and produce an event based on the outcome (e.g. if the diff is greater than say 1Mb)
I've tried varients of :
{PGSQL:Master_RepLog} - {PGSQL:Slave_RepLog} > 1M
(where PGSQL:Master_RepLog is the monitoring key I'm getting results from)
but to no joy... any clues would be appreciated
Rob.
I have a couple of items being monitored - specifically the streaming replication 'value' from the master and slave servers.
The results I get back are in hex, formatted something like this :
0x30AF84DC2F (the Master)
0x30AF84C43B (the Slave)
The difference between the two is 17F4(hex) (6132 bytes).
I need a trigger that will diff the two results and produce an event based on the outcome (e.g. if the diff is greater than say 1Mb)
I've tried varients of :
{PGSQL:Master_RepLog} - {PGSQL:Slave_RepLog} > 1M
(where PGSQL:Master_RepLog is the monitoring key I'm getting results from)
but to no joy... any clues would be appreciated

Rob.
Comment