monitoring bdr nodes

From: Dennis <dennisr(at)visi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: monitoring bdr nodes
Date: 2015-04-16 15:58:37
Message-ID: F38D1020-3B2C-41CF-BECD-1F1FB5B19806@visi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need some clarification on how to monitor BDR nodes. In particular determining replication lag. As an example, I have a two node cluster with nodes ‘A’ and ‘B’. I need to be able to look at node ‘B’ and determine if it is lagging behind node ‘A’, by interrogating node ‘B’ only.

From the BDR documentation on monitoring:

SELECT pg_xlog_location_diff(pg_current_xlog_insert_location(), flush_location) AS lag_bytes,
pid,
application_name
FROM pg_stat_replication;

Because it is querying the pg_stat_replication table, I will need to run this query on node ‘A’ to check the lag on node ‘B’, is that true? I need to be able run a query on node ‘B’ to determine if it node ‘B’ is behind. I am not sure the above query will work for that use case.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message TonyS 2015-04-16 19:24:32 Error using DAO with the ODBC driver S1000: positioned_load in pos_newload failed
Previous Message William Dunn 2015-04-16 14:52:52 PL\pgSQL 'ERROR: invalid input syntax for type oid:' [PostgreSQL 9.3.6 and 9.4]