[pgpool-general: 6123] Re: [pgpool-committers: 4777] pgpool: Add new feature to enable specifying SQL patterns lists that sh

Tatsuo Ishii ishii at sraoss.co.jp
Thu Jun 14 15:15:21 JST 2018


Congratulations on the new feature!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: Bo Peng <pengbo at sraoss.co.jp>
Subject: [pgpool-committers: 4777] pgpool: Add new feature to enable specifying SQL patterns lists that sh
Date: Thu, 14 Jun 2018 05:32:29 +0000
Message-ID: <E1fTKs1-0004s6-FY at gothos.postgresql.org>

> Add new feature to enable specifying SQL patterns lists that should not be load-balanced.
> 
> Even though currently we can do this by adding the
> /*NO LOAD BALANCE*/ comment to queries, this requires
> modifying application codes and this is not always
> possible.
> 
> This feature enables specifying SQL patterns lists
> that should not be load-balanced.
> 
> -------------
> New parameter
> -------------
> black_query_pattern_list = ''
> 
> You can specify a semicolon separated list of SQL patterns
> that should be sent to primary node only.
> 
> SQL that matched patterns specified in this list are not load balanced.
> Only Maste Slave mode is supported.
> 
> You can use regular expression to match SQL patterns,
> to which ^ and $ are automatically added.
> When using characters such as "'", ";" or "*" in SQL patterns,
> you need to escape them using "\".
> 
> Branch
> ------
> master
> 
> Details
> -------
> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=83906d1d5024e5f68ef9dd9dff9fda7f5720be4e
> 
> Modified Files
> --------------
> doc.ja/src/sgml/loadbalance.sgml                   |  94 +++++++++++++++++
> doc/src/sgml/loadbalance.sgml                      |  65 ++++++++++++
> src/config/pool_config.l                           |  31 +++++-
> src/config/pool_config_variables.c                 | 111 ++++++++++++++++++++-
> src/context/pool_query_context.c                   |  12 ++-
> src/include/pool_config.h                          |   7 ++
> src/sample/pgpool.conf.sample                      |   7 +-
> src/sample/pgpool.conf.sample-logical              |   6 ++
> src/sample/pgpool.conf.sample-master-slave         |   6 ++
> src/sample/pgpool.conf.sample-replication          |   6 ++
> src/sample/pgpool.conf.sample-stream               |   6 ++
> src/test/regression/tests/001.load_balance/test.sh |  45 +++++++++
> src/utils/pool_process_reporting.c                 |  13 +++
> src/utils/pool_select_walker.c                     |   6 ++
> 14 files changed, 410 insertions(+), 5 deletions(-)
> 


More information about the pgpool-general mailing list