[pgpool-general: 4468] Re: Multiple pgpool on the same cluster
ishii at postgresql.org
Thu Feb 18 09:46:07 JST 2016
Thank you for the info. I wonder how HAProxy behaves if a pgpool-II or
PostgreSQL server goes down. Does it ignores the broken pgpool-II or
PostgreSQL? (I expect so). What happens with existing client sessions
that are connecting to the broken pgpool-II or PostgreSQL?
SRA OSS, Inc. Japan
> Hey Tatsuo,
> I've used HAProxy in this configuration successfully.
> Obviously it doesn't know anything about load balancing write SQL to the
> master - but as far as load balancing read queries it works well (as long
> as you enforce session stickiness).
> We actually use HAProxy, in front of PGPool, in front of a PostgreSQL HA
> cluster at some sites. This works well.
> James Sewell,
> PostgreSQL Team Lead / Solutions Architect
> Level 2, 50 Queen St, Melbourne VIC 3000
> *P *(+61) 3 8370 8000 *W* www.lisasoft.com *F *(+61) 3 8370 8099
> On Thu, Feb 18, 2016 at 2:02 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>> > On 02/17/2016 09:25 AM, Tatsuo Ishii wrote:
>> >> BTW, I personally have no experience with HAProxy, one of my customers
>> >> told me that he had bad experience with HAProxy and that was one of
>> >> his reasons he decided to migrate to pgpool-II (single instance).
>> > FWIW, one of my clients successfully used HAProxy to Load Balance
>> > across Tomcat's. Their system had a bit of demand during certain
>> > periods.
>> Well, Tomcat is totally different from PostgreSQL or pgpool-II. My
>> customer used HAProxy in front of PostgreSQL. He expected HAProxy
>> properly handles the case when PostgreSQL goes down but HAProxy hangs
>> when it actually happens.
>> Best regards,
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
> The contents of this email are confidential and may be subject to legal or
> professional privilege and copyright. No representation is made that this
> email is free of viruses or other defects. If you have received this
> communication in error, you may not copy or distribute any part of it or
> otherwise disclose its contents to anyone. Please advise the sender of your
> incorrect receipt of this correspondence.
More information about the pgpool-general