From: | Stephen Nelson <stephen(at)eccostudio(dot)com> |
---|---|
To: | Enrico Olivelli - Diennea <enrico(dot)olivelli(at)diennea(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: R: Please implement simple failover scenario |
Date: | 2014-09-22 13:52:34 |
Message-ID: | CAHpHs3mFCbXq1bFKtYRXMuuD6fY8sA6UdJ6SP8yXTAUnKcXDDQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Fri, Sep 19, 2014 at 12:39 PM, Enrico Olivelli - Diennea
<enrico(dot)olivelli(at)diennea(dot)com> wrote:
>
> Can you suggest some alternative to ha-jdbc ? I can't find any other library which is currently under active development
>
>
I don't know what your application and infrastructure architecture is
but I'd look at the solutions provided by Postgresql natively such as
Transaction Log Shipping [0] which could be provided by virtual IPs
are previously suggested.
If your application is web-based and lives in a Java app server, for
HA I would expect you would have a hot standby. In this case you could
use an intelligent load balancer to use the endpoint of the active
server.
Finally, I have used ha-jdbc in the past and it worked well for our
needs in an active-active configuration. Also it looks like it is
under active development [1]
Hope this helps,
Stephen
[0] http://www.postgresql.org/docs/9.3/interactive/different-replication-solutions.html
[1] https://github.com/ha-jdbc/ha-jdbc/commits/master
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Schlansker | 2014-09-22 17:16:40 | Re: Disk buffering of resultsets |
Previous Message | Alexis Meneses | 2014-09-22 11:11:02 | Re: Patch to allow setting schema/search_path in the connectionURL |