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

[David Kerr]

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