[pgpool-committers: 5820] pgpool: Allow to route relcache queries to load balance node.

Tatsuo Ishii ishii at sraoss.co.jp
Thu Jun 20 13:21:31 JST 2019


Allow to route relcache queries to load balance node.

Queries to build relcache entries were always sent to master (primary)
node. This is usually good because we could eliminate the bad effect
of replication delay. However if users want to lower the load of
master node, it would be nice if we could route the queries to other
than master node. This patch introduces new parameter
"relache_query_target". If it is set to 'load_balance_node', relcache
queries will be routed to load balance node.  If it is set to
'master', the queries are routed to master node, which is same as
before (this is the default).

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=46986ebc0be77e4b011b94b097789fec9e3f5b0f

Modified Files
--------------
doc.ja/src/sgml/misc-config.sgml           | 27 ++++++++++++++++++++
doc/src/sgml/misc-config.sgml              | 39 +++++++++++++++++++++++++++++
src/config/pool_config_variables.c         | 40 ++++++++++++++++++++++++++++++
src/include/pool_config.h                  |  7 ++++++
src/sample/pgpool.conf.sample              |  2 ++
src/sample/pgpool.conf.sample-logical      |  2 ++
src/sample/pgpool.conf.sample-master-slave |  2 ++
src/sample/pgpool.conf.sample-replication  |  2 ++
src/sample/pgpool.conf.sample-stream       |  2 ++
src/utils/pool_process_reporting.c         |  5 ++++
src/utils/pool_relcache.c                  | 34 ++++++++++++++++++++++---
11 files changed, 158 insertions(+), 4 deletions(-)



More information about the pgpool-committers mailing list