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

[Tatsuo Ishii]

主に彭さん

石井です。

この新機能について英語のブログを書きました。

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