[pgpool-hackers: 3291] Re: [pgpool-committers: 5615] pgpool: New feature "statement_level_load_balancing".

Tatsuo Ishii ishii at sraoss.co.jp
Tue Apr 2 16:01:06 JST 2019


Sorry, I accidently sent an email dedicated for internal communication.

But still if you are interested, please take a look at my English blog:-)
> http://pgsqlpgpool.blogspot.com/2019/04/statement-level-load-balancing.html

From: Tatsuo Ishii <ishii at sraoss.co.jp>
Subject: [pgpool-hackers: 3290] Re: [pgpool-committers: 5615] pgpool: New feature "statement_level_load_balancing".
Date: Tue, 02 Apr 2019 15:58:42 +0900 (JST)
Message-ID: <20190402.155842.576976374145441461.t-ishii at sraoss.co.jp>

> 主に彭さん
> 
> 石井です。
> 
> この新機能について英語のブログを書きました。
> 
> http://pgsqlpgpool.blogspot.com/2019/04/statement-level-load-balancing.html
> 
> 間違いがないかどうか、確認いただけますか?
> (あるいは、こうした方が良い、というコメントも歓迎です)
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> Congratulations Peng!
>> 
>> It is one the largest features in upcoming Pgpool-II 4.1 and has been
>> expected for many years.
>> 
>> Best regards,
>> --
>> 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: 5615] pgpool: New feature "statement_level_load_balancing".
>> Date: Tue, 02 Apr 2019 01:16:54 +0000
>> Message-ID: <E1hB82o-0006ra-3a at gothos.postgresql.org>
>> 
>>> New feature "statement_level_load_balancing".
>>> 
>>> This feature enables selecting load balancing node per statement.
>>> 
>>> The current feature for load balancing, the load balancing node is decided
>>> at the session start time and will not be changed until the session ends.
>>> 
>>> When set to statement_level_load_balancing = on, the load balancing node
>>> is decided for each read query.
>>> 
>>> For example, in applications that use connection pooling remain connections
>>> open to the backend server, because the session may be held for a long time,
>>> the load balancing node does not change until the session ends.
>>> In such applications, when statement_level_load_balance is enabled,
>>> it is possible to decide load balancing node per query, not per session.
>>> 
>>> Branch
>>> ------
>>> master
>>> 
>>> Details
>>> -------
>>> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=1099ba610eef06a9dab6f89486cc52de55ff3ebb
>>> 
>>> Modified Files
>>> --------------
>>> doc.ja/src/sgml/loadbalance.sgml                   |  37 +++
>>> doc/src/sgml/loadbalance.sgml                      |  23 ++
>>> src/config/pool_config_variables.c                 |  10 +
>>> src/context/pool_query_context.c                   |  21 +-
>>> src/context/pool_session_context.c                 |  52 ++--
>>> src/include/context/pool_query_context.h           |   2 +-
>>> src/include/context/pool_session_context.h         |   6 +-
>>> src/include/pool_config.h                          |   2 +
>>> src/protocol/child.c                               |   4 +-
>>> src/protocol/pool_proto_modules.c                  |   1 +
>>> src/sample/pgpool.conf.sample                      |   3 +
>>> src/sample/pgpool.conf.sample-logical              |   3 +
>>> src/sample/pgpool.conf.sample-master-slave         |   3 +
>>> src/sample/pgpool.conf.sample-replication          |   3 +
>>> src/sample/pgpool.conf.sample-stream               |   3 +
>>> .../expected/statement_level_load_balance.data     |  37 +++
>>> .../statement_level_load_balance.data              |  39 +++
>>> src/test/extended-query-test/test.sh               | 261 +++++++++++++++------
>>> .../tests_n3/statement_level_load_balance.data     |  27 +++
>>> src/test/regression/tests/001.load_balance/test.sh |  23 ++
>>> src/utils/pool_process_reporting.c                 |   5 +
>>> 21 files changed, 454 insertions(+), 111 deletions(-)
>>> 
>> _______________________________________________
>> pgpool-hackers mailing list
>> pgpool-hackers at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers


More information about the pgpool-hackers mailing list