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 <[email protected]> wrote: > From: Tatsuo Ishii <[email protected]> > Subject: Re: [Pgpool-general] pgpool-II documentation > To: [email protected] > Cc: [email protected] > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
