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

David Kerr dmk at mr-paradox.net
Mon May 28 02:31:16 JST 2012

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.


More information about the pgpool-general mailing list