[pgpool-general: 533] Re: Hibernate and pgpool-II

[Tatsuo Ishii]

> On 05/27/2012 10:31 AM, David Kerr wrote:
>> On 5/27/2012 10:28 AM, Ludger Overbeck wrote:
>>> Hi,
>>>
>>> I would like to know if anybody has ever used pgpool-II (in
>>> Replication
>>> Mode or Master/Slave Mode) with Hibernate? Does this cause any
>>> problems?
>>>
>>> As far as I know in Hibernate SQL-statements (which are sent to the
>>> database) are always issued in an explicit transaction. And as the FAQ
>>> for pgpool says, that would mean that there is no load balancing in
>>> replication mode. Is that correct?
>>>
>>> Instead I am thinking about using the Master/Slave mode with
>>> synchronous
>>> streaming replication to avoid that selects deliver stale data (as
>>> with
>>> asynchronous replication). Would this work?
>>>
>>> Thanks for your replies.
>>
>> I've started some testing with Hibernate + PgPool II in load balance /
>> master server mode with async Streaming Replication and so far the
>> results have been positive.
>>
>> Dave
> 
> 
> Update on this:
> 
> Even though my test appeared to be load balancing, the log files show
> that, in fact, it was not.
> 
> I suspect it's as you mentioned the explicit transactions in
> hibernate. (I'm in Master/Slave mode.)

I don't know what was your test case but I'm sure pgpool-II 3.0 or
later can do load balancing in streaming replication mode even in
explicit transactions.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp