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

sunpeng bluevaley at gmail.com
Thu Mar 1 16:35:43 JST 2012


I‘m studying these docs, thanks!
peng

On Thu, Mar 1, 2012 at 11:03 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> Of course, that's a doable configuration.
>
> See tutorials for concrete examples.
>
>
> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting_3.1/index.html
>
> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.1/index.html
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> > 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/b3c2536d/attachment.html>


More information about the pgpool-general mailing list