Re: Connection-fail-over

On 17.05.2012 20:00, Mikko Tiihonen wrote:
> Hi,
>
> I have been thinking of adding connection fail-over support to the jdbc
> driver. What this means is that there would be a way to specify more
> than host:port pair to connect to. This will become handy with
> high-availability installations.
>
> Currently the limitation of hostname means that there has to be a
> virtual ip address that is moved with the active backend, which is a
> complex solution that can break.
>
> If we have list of hostname:port pairs we just have to make sure that
> only the master database allows connections from the jdbc clients.

I'd suggest doing this as a generic wrapper or proxy that would work
with any JDBC driver, not just PostgreSQL's. Maybe there is such a thing
out there already? I believe many application servers at least can do
that, and then there's http://ha-jdbc.sourceforge.net/, which I think
can do that too.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com