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

Tatsuo Ishii ishii at postgresql.org
Tue Feb 28 15:46:19 JST 2012


> 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