[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