[pgpool-general: 6778] Delay in synchronous replication, is it possible ?!

Franklin Anderson de Oliveira Souza franklinbr at gmail.com
Thu Nov 14 01:01:07 JST 2019


I use pgpool with 5 slave on mode synchronous.
But sometimes i see values on column replication_delay when execute command
show pool_nodes.
Sometimes, when a node goes beyond the value of delay_threshold, the node
does not receive balancing query.

But
1- Synchronous replication should not be delayed is not it?
2- How is this possible ?
3- Is the replication_delay parameter of pgpool wrong?

show pool_nodes
 node_id |  hostname   | port | status | lb_weight |  role   | select_cnt |
load_balance_node | replication_delay | last_status_change
---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
 0       | IP          | 5432 | up     | 0.100000  | primary | 230616548  |
false             | 0                 | 2019-10-24 19:17:27
 1       | IP          | 5432 | up     | 0.100000  | standby | 172466610  |
true              | 0                 | 2019-10-24 19:17:27
 2       | IP          | 5432 | up     | 0.100000  | standby | 180179200  |
false             | 234324            | 2019-10-24 19:17:27
 3       | IP          | 5432 | up     | 0.100000  | standby | 178475037  |
false             | 20777216          | 2019-10-24 19:17:27
 4       | IP          | 5432 | up     | 0.100000  | standby | 182174042  |
false             | 0                 | 2019-10-24 19:17:27
 5       | IP          | 5432 | up     | 0.100000  | standby | 181169375  |
false             | 0                 | 2019-10-24 19:17:27



pg_stat_replication
  application_name  | client_addr |  write_lsn   |  flush_lsn   |
write_lag    | sync_priority | sync_state
--------------------+-------------+--------------+--------------+-----------------+---------------+------------
 pje1_slave1        | IP          | 8FA/42E88B60 | 8FA/42E88B60 |
00:00:00.000355 |             1 | sync
 pje1_slave2        | IP          | 8FA/42E88B60 | 8FA/42E88B60 |
00:00:00.000312 |             2 | potential
 pje1_slave3        | IP          | 8FA/42E88B60 | 8FA/42E88B60 |
00:00:00.000366 |             3 | potential
 pje1_slave4        | IP          | 8FA/42E88B60 | 8FA/42E88B60 |
00:00:00.000277 |             4 | potential
 pje1_slave5        | IP          | 8FA/42E88B60 | 8FA/42E88B60 |
00:00:00.000265 |             5 | potential

-- 
foobar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20191113/4272c0ce/attachment.html>


More information about the pgpool-general mailing list