[pgpool-general: 2728] Re: pgpool-ha 2.2 released

[Tatsuo Ishii]

> Ishii-san,
> 
>> Caution: multiple pgpool instances will not work correctly without
>> watchdog. For example, failover script may be executed by multiple
>> pgpool instances at a same time when one of PostgreSQL nodes goes
>> down. Also it's possible that online recovery script can be executed
>> by multiple pgpool instances.
> 
> This means
> multiple pgpool instances *for same backend Postgres instances*
> not work without watchdog, doesn't it?

Correct.

>> >  - manage multi pgpool instances (with single heartbeat pair)
> 
> I say about multiple pgpool instances that independent from each other.

I see.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> with best regards, 
>  ______________________________________________________________________
>  TAKATSUKA Haruka  harukat at sraoss.co.jp  SRA OSS, Inc .
> 
> 
> On Mon, 07 Apr 2014 21:33:42 +0900 (JST)
> Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> > Hi.
>> > 
>> > When you want to do something complicated , it's used.
>> > e.g.
>> >  - use two or more VIP in different N/W segments
>> >  - manage other deamons on same HA cluster with pgpool
>> >  - manage multi pgpool instances (with single heartbeat pair)
>> 
>> Caution: multiple pgpool instances will not work correctly without
>> watchdog. For example, failover script may be executed by multiple
>> pgpool instances at a same time when one of PostgreSQL nodes goes
>> down. Also it's possible that online recovery script can be executed
>> by multiple pgpool instances.
> 
> 
> 
>> 
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>> 
>> > On Sun, 06 Apr 2014 17:07:47 -0700
>> > Alexandru Cardaniuc <cardaniuc at gmail.com> wrote:
>> > 
>> >> Any reason to use pgpool-HA instead of watchdog in pgpool 3.3.3?
>> >> 
>> >> TAKATSUKA Haruka <harukat at sraoss.co.jp> writes:
>> >> 
>> >> > pgpool-ha 2.2 released -------------------------
>> >> >
>> >> > Version 2.2 of pgpool-ha, the OCF resource agent script for pgpool-II
>> >> > on HA cluster management softwares such as Pacemaker, has been
>> >> > released and is publicly available for download.
>> >> >
>> >> >   Download: http://pgpool.net/mediawiki/index.php/Downloads#pgpool-HA
>> >> >
>> >> > This version fixes bugs following:
>> >> >
>> >> >   * fix metadata for pcs command's xml parser. This causes "Unable to
>> >> > parse xml" error at "pcs resource describe" command of Pacemaker 1.1.x
>> >> > (http://www.pgpool.net/mantisbt/view.php?id=91)
>> >> >
>> >> >   * add wait loop to start action function. This causes an
>> >> > inappropriate failure of monitoring action. (reported by
>> >> > [pgpool-general: 2123])
>> >> >
>> >> > _______________________________________________ pgpool-general mailing
>> >> > list pgpool-general at pgpool.net
>> >> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>> >> >
>> >> >
>> >> 
>> >> -- 
>> >> "The only thing necessary for evil to flourish is for good men to do
>> >> nothing."  
>> >> - Edmund Burke
>> > 
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general