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

[sunpeng]

If a read-only hot-standby could be promoted as master for read-write at
failover, then pgpool-II+hot-standby+streaming replication(or Streaming
Replication) works better.

On Tue, Feb 28, 2012 at 2:46 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > 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,
>
> Why do you think so? hot-standby can be used as a better HA comparing
> warm-standby, since there's less chance to lose transactions.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> >  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/20120301/15913412/attachment-0001.html>