[Pgpool-general] pgpool-II documentation

[Harold Lim]

Hi Ishii,

Also, I'm confused between load_balance_mode and replicate_select.

Are they not the same?

load balance will distribute select query across all back ends. But replicate if set to false will only send the query to master db?

So, if I want load balance, should I set both of them to true?

Also, is the load balance only for read operations? So, if I want to write to the DB, it will always write to the master?


Thanks,
Harold
  


--- On Wed, 4/8/09, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> From: Tatsuo Ishii <ishii at sraoss.co.jp>
> Subject: Re: [Pgpool-general] pgpool-II documentation
> To: rold_50 at yahoo.com
> Cc: pgpool-general at pgfoundry.org
> Date: Wednesday, April 8, 2009, 9:03 PM
> > Hi All,
> > 
> > Is there a more in-depth documentation of pgpool?
> 
> Before stepping into pgpool internal, it' s best to
> understand how
> PostgreSQL frontend/backend protocol works. See
> "Frontend/Backend
> Protocol".
> 
> > I'm mostly interested in how pgpool does the
> replication process (how it ensures consistency, especially
> under load_balance_mode).
> 
> There are some explanation in the pgpool-II docs(the latest
> one
> is:http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html).
> 
> 
> Look into around:
> http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#config
> -------------------------------------------------------------------
> replicate_select
> 
>     When set to true, pgpool-II replicate SELECTs. If
> false, pgpool-II
>     only sends them to Master DB. Default is false.
> -------------------------------------------------------------------
> 
> and:
> 
> http://pgpool.projects.postgresql.org/pgpool-II/doc/load_balance.png
> 
> Also I'm going to give a talk at PGCon 2009 in Ottawa.
> I would like to
> talk about how pgpool-II tries to keep the consistency
> among databases.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan