pgpool2.git / summary / log / commit / refs

commit    7c90f9825004c0a1230d65b6584b89490b4e87fe
Author:   Tatsuo Ishii <ishii@sraoss.co.jp>
Date:     Tue Apr 09 05:17:57 2019 +0000

    Doc: add description about multi-statement queries to restrictions section.


 doc.ja/src/sgml/restrictions.sgml | 10 ++++++++++
 doc/src/sgml/loadbalance.sgml     |  2 +-
 doc/src/sgml/restrictions.sgml    | 14 ++++++++++++++
 3 files changed, 25 insertions(+), 1 deletion(-)

diff --git a/doc.ja/src/sgml/restrictions.sgml b/doc.ja/src/sgml/restrictions.sgml
index f0ac7e162..b9407ae7e 100644
--- a/doc.ja/src/sgml/restrictions.sgml
+++ b/doc.ja/src/sgml/restrictions.sgml
@@ -42,6 +42,16 @@
     </listitem>
    </varlistentry>
 
+   <varlistentry>
+    <term>Load Balancing</term>
+    <listitem>
+     <para>
+マルチステートメントSQL(1行の中に複数のSQLが含まれている)は、常にプライマリノード(ストリーミングレプリケーションモードの場合)かマスターノード(それ以外のモード)に送られます。
+通常<productname>Pgpool-II</productname>はクエリの種類を見て適切なノードにクエリを送りますが、マルチステートメントSQLではこれが適用されません。
+     </para>
+    </listitem>
+   </varlistentry>
+
    <varlistentry>
 <!--
     <term>Authentication/Access Controls</term>
diff --git a/doc/src/sgml/loadbalance.sgml b/doc/src/sgml/loadbalance.sgml
index b078a7fac..75bd39f70 100644
--- a/doc/src/sgml/loadbalance.sgml
+++ b/doc/src/sgml/loadbalance.sgml
@@ -312,7 +312,7 @@
            </listitem>
            <listitem>
              <para>
-             Multi-stament queries (multiple SQL commands on single line)
+             Multi-statement queries (multiple SQL commands on single line)
              </para>
            </listitem>
          </itemizedlist>
diff --git a/doc/src/sgml/restrictions.sgml b/doc/src/sgml/restrictions.sgml
index e4abf54cd..cf3a4b69d 100644
--- a/doc/src/sgml/restrictions.sgml
+++ b/doc/src/sgml/restrictions.sgml
@@ -25,6 +25,20 @@
     </listitem>
    </varlistentry>
 
+   <varlistentry>
+    <term>Load Balancing</term>
+    <listitem>
+     <para>
+       Multi-statement queries (multiple SQL commands on single line)
+       are always sent to primary node (in streaming replication mode)
+       or master node (in other
+       modes). Usually <productname>Pgpool-II</productname> dispatch
+       query to appropriate node, but it's not applied to
+       multi-statement queries.
+     </para>
+    </listitem>
+   </varlistentry>
+
    <varlistentry>
     <term>Authentication/Access Controls</term>
     <listitem>


[parent: fdbf5f95a0df]