monitoring bdr nodes

Поиск
Список
Период
Сортировка
От Dennis
Тема monitoring bdr nodes
Дата
Msg-id F38D1020-3B2C-41CF-BECD-1F1FB5B19806@visi.com
обсуждение исходный текст
Ответы Re: monitoring bdr nodes
Список pgsql-general
I need some clarification on how to monitor BDR nodes.  In particular determining replication lag.  As an example,  I
havea two node cluster with nodes ‘A’ and ‘B’.    I need to be able to look at node ‘B’ and determine if it is lagging
behindnode ‘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
theabove query will work for that use case. 




В списке pgsql-general по дате отправления: