[pgpool-general: 252] Re: Hi, Friends, what's the real meanings of "Replication mode"?

[sunpeng]

Thanks!
Just from learning perspective I raised previous 2nd question. I think
there should be 6 cases:

   1. pgpool-II+master server+ warm-standby server+ file-based log shipping
   method between master and standby
   2. pgpool-II+master server+ warm-standby server+ stream replication
   method between master and standby
   3. pgpool-II+master server+ warm-standby server+ synchonous replication
   method between master and standby
   4. pgpool-II+master server+ hot-standby server+ file-based log shipping
   method between master and standby
   5. pgpool-II+master server+ hot-standby server+ stream replication
   method between master and standby
   6. pgpool-II+master server+ hot-standby server+ synchonous replication
   method between master and standby

I noticed the tutorial of
http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html falls into
case 5. From that tutorial I assumed pgpool could be configured to support
case 2,3,5,6 by using master-slave mode combined with load balancing mode.
Is that right? Maybe I could have a try.
I understand people using warm-standby for HA, and hot-standby for load
balancing, or OLAP on standby to seperate work-load from master.


On Tue, Feb 28, 2012 at 9:01 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > Hi, Friends,
> >   I've two questions:
> >   1. What's the real meanings of  "Replication mode"? I noticed there is
> no
> > much more explaination at pgpool-II manual (English)
> > <http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html>, what's
> the
> > difference between "Replication mode" and "Master-slave mode"? Should I
> > understand "Replication mode" as "pgpool-ii sends DML sentences just like
> > Inserts to two backends postgresql?"
>
> Right.
>
> >   2. I know I could configure Postgresql9.1 warm-standby using file-based
> > log shiping, stream replication or Synchronous Replication. From this
> > tutorial For pgpool-II 3.1 and PostgreSQL
> > 9.1<
> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.1/index.html
> >,
> > I know how to configure pgpool supporting stream replication between
> master
> > and warm-standby. My question is it seems pgpool-ii doesn't support
> > file-based log shiping method between master and warm-standby, is that
> > right? Because I could not select Master-slave mode for it only support
> > slony or stream. And I also don't know whether should I use replication
> > mode in pgpool.conf.
> >   Thanks!
>
> I have never tried warm standby with pgpool but master-slave + slony
> should be able to work with it. BTW, why do you need warm standby
> anyway? Is tehre any reason not to use streaming replication?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120228/2ca5ecef/attachment.html>