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

Tatsuo Ishii ishii at postgresql.org
Thu Mar 1 12:03:18 JST 2012


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
>> >>
>>


More information about the pgpool-general mailing list