From b5995955c9a727a3140f855b51029d39183eac81 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Tue, 10 Aug 2010 03:03:52 +0000 Subject: [PATCH] Sync with Japanese doc. --- doc/pgpool-en.html | 97 +++++++++++++++++++++++++++++++++++----------- 1 file changed, 75 insertions(+), 22 deletions(-) diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html index 5cb7236a4..a53c7d7b9 100644 --- a/doc/pgpool-en.html +++ b/doc/pgpool-en.html @@ -7,7 +7,7 @@ -Last modified: Fri Aug 6 13:55:03 JST 2010 +Last modified: Tue Aug 10 12:00:20 JST 2010 @@ -27,6 +27,10 @@ Last modified: Fri Aug 6 13:55:03 JST 2010
  • Platforms
  • pgpool-II Installation
  • Configuring pgpool-II
    • +
  • Configuring common part
    • +
  • Connection pool mode
    • +
  • Replication mode
    • +
  • Master slave mode
  • Starting/Stopping pgpool-II
  • Reloading pgpool-II configuration files
  • Online recovery
    • @@ -101,6 +105,10 @@ pgpool-II is transparent to both the server and the client, an existing database application can be used with pgpool-II almost without a change to its sources.

    +

    +There is some restrictions of using SQL via pgpool-II. +See Restrictions for more details. +

    Supported Platforms

    @@ -109,6 +117,11 @@ UNIX-like architectures. Windows is not supported. Supported PostgreSQL server's versions are 6.4 and higher. To use the parallel query, however, 7.4 and higher must be used.

    +

    If you are using PostgreSQL 7.3 or before, there are some restrictions of functionalities of pgpool-II.

    + +

    Also you must make sure that all of PostgreSQL servers's major versions are identical. +In addition this, hardware architectures and OSs must be identical if you want to use online recovery. +

    pgpool-II Installation

    @@ -117,6 +130,11 @@ pgpool-II can be downloaded from +

    +The source code of pgpool-II can be downloaded from: +href="http://pgfoundry.org/projects/pgpool/">pgpool development page +

    +

    Installing pgpool-II from source code requires gcc 2.9 or higher, and GNU make. Also, pgpool-II links libpq library, so the libpq library and development headers must be installed on a machine used to build pgpool-II. Additionally @@ -156,7 +174,7 @@ installed. Default value is obtained by pg_config make make install -will install pgpool-II. (If you use FreeBSD, replace make with gmake) +will install pgpool-II. (If you use Solaris or FreeBSD, replace make with gmake)

    @@ -175,7 +193,6 @@ control their behaviors.

    Function/Mode raw Mode - Connection Pool Mode Replication Mode Master/Slave Mode Parallel Query Mode @@ -186,34 +203,38 @@ control their behaviors.

    X O O - O 0 Replication - X X O X - (*) + (*1) Load Balance - X X O O - (*) + (*1) Failover + O O O X + + + + Online recovery X + 0 + (*2) X @@ -222,13 +243,11 @@ control their behaviors.

    X X X - X O Required # of Servers - 1 or higher 1 or higher 2 or higher 2 or higher @@ -240,12 +259,22 @@ control their behaviors.

    no no no - no yes -(*)Parallel Query Mode requires the replication or the load-balancing turned on, however the function of the replication and the load-balancing cannot be used for the table preserved by dividing data in Parallel Query Mode. + +

    +

    +

    +

    Configuring pcp.conf

    pgpool-II provides the control interface where an administrator @@ -304,12 +333,7 @@ cp $prefix/etc/pgpool.conf.sample $prefix/etc/pgpool.conf An empty line or a line starting with "#" is treated as a comment and will be ignored.

    -

    raw Mode

    - -

    In the raw mode, clients simply connect to the PostgreSQL servers -via pgpool-II. This mode is useful for simply limiting excess -connections to the servers, or enabling failover with multiple -servers.

    +

    Common settings

    listen_addresses
    @@ -748,7 +772,7 @@ backend_hostname0 fails for some reason, pgpool-II tries to access the backend specified by backend_hostname1. If that fails, pgpool-II tries the backend_hostname2, 3 and so on.

    -

    Connection Pool Mode

    +

    Connection Pool Mode

    In the connection pool mode, all functions in raw mode and the connection pool function can be used. To enable this mode, set @@ -814,7 +838,7 @@ You need to re-read pgpool.conf upon modification of this direrctive.

    Failover in the connection pool mode is the same as in the raw mode.

    -

    Replication Mode

    +

    Replication Mode

    This mode enables data replication between the backends. The configuration parameters below must be set in addtion to everything above.

    @@ -836,7 +860,7 @@ configuration parameters below must be set in addtion to everything above.

    failover_if_affected_tuples_mismatch

    When set to true, if a backend returns number of affected - tuples by UPDATE/DELETE + tuples by INSERT/UPDATE/DELETE different between the backends, the backends that differ from most frequent result set are degenerated. If set to false, the session is terminated and the backends are not @@ -859,6 +883,35 @@ configuration parameters below must be set in addtion to everything above.

    degenerated. Default is false.

    + +
    white_function_list +
    +

    +Specify comma separated function name list, those do not update database. +SELECTs use functions not specified in this list are not load balanced, replicated if in replication mode. +In master slave mode, SELECTs are sent to master(primary) only. +

    + + +
    black_function_list +
    +

    +Specify comma separated function name list, those do update database. +SELECTs use functions specified in this list are not load balanced, replicated if in replication mode. +In master slave mode, SELECTs are sent to master(primary) only. +

    +

    +You should not make those lists nonempty at the same time. +

    +

    +Prior to pgpool-II 3.0, nextval() and setval() are the functions those do writes to database. +You can emulate this by using white_function_list and black_function_list: +

    +
    +white_function_list = ''
+black_function_list = 'upper,lower'
+
    +
    replicate_select
    @@ -1163,7 +1216,7 @@ You need to call setAutoCommit(true) to enable autocommit. service. The service can be continued if there is at least one backend alive.

    -

    Master/Slave Mode

    +

    Master/Slave Mode

    This mode is for using pgpool-II with another master/slave replication software (like Slony-I and Streaming replication), so it really does the actual data -- 2.39.5