[pgpool-general: 564] Re: Companies using pgpool-II

Tatsuo Ishii ishii at postgresql.org
Wed May 30 22:13:03 JST 2012


I'm not sure if it's related to load balancing.
I guess it's related to unamed statements.
http://www.pgpool.net/mantisbt/view.php?id=14

So I think using named statements is one of workarounds for now.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I'd say it's a safe assumption that since they're running java apps
> (extended protocol) in production they're not using load-balance mode.
> 
> Otherwise, they'd be running into the same issue David Kerr reported
> again this week.
> 
> On 05/30/2012 04:28 AM, Tatsuo Ishii wrote:
>> They are using pgpool's native replication mode (the site has opened
>> in April 2009).
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>>> Does anybody know, which mode they are using (replication mode,
>>> master/slave mode, ...). If they are using master/slave mode, which
>>> replication software is used?
>>>
>>> Thanks.
>>>
>>> 2012/5/23 Tatsuo Ishii<ishii at postgresql.org>
>>>
>>>>> Hi everyone,
>>>>>
>>>>> on http://wiki.postgresql.org/wiki/Pgpool-II it says that pgpool-II is
>>>>> already used for several commercial systems.
>>>>>
>>>>> I would like to know what companies actually use it. Can you name any?
>>>>>
>>>>> Thanks for your replies.
>>>>
>>>> Here it is.
>>>>
>>>> http://www.sraoss.co.jp/case_study/nttdataccs.php
>>>>
>>>> (Unfortunately, it is in Japanese).
>>>>
>>>> The system is for a web site: http://travelpoint.jtb.co.jp/tabicard/
>>>> This is for one of the largest travel agency in Japan called "JTB".
>>>> (http://www.jtbcorp.jp/en/)
>>>>
>>>> The system consists of 4 PostgreSQL servers, two pgpool-II servers,
>>>> JBoss, Tomcat and Apache. The databases are two groups, each has two
>>>> PostgreSQL for HA and load balancing.
>>>> --
>>>> Tatsuo Ishii
>>>> SRA OSS, Inc. Japan
>>>> English: http://www.sraoss.co.jp/index_en.php
>>>> Japanese: http://www.sraoss.co.jp
>>>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list