R: Please implement simple failover scenario

Actually we are going to implement the virtual IP address setup but only for the first stages of the porting

it is a more difficult have a virtual IP address setup in a large system with many servers

it requires many components to be setup and monitored
having simple failover mechanics at JDBC driver level will simplify many aspects of the problem

we could use something like ha-jdbc but s too much complex for our needs (and its impact on performances for us is not justified)

Enrico Olivelli
Software Development Manager @Diennea
Tel.: (+39) 0546 066100 - Int. 925
Viale G.Marconi 30/14 - 48018 Faenza (RA)

MagNews - E-mail Marketing Solutions
http://www.magnews.it
Diennea - Digital Marketing Solutions
http://www.diennea.com

-----Messaggio originale-----
Da: Albe Laurenz [mailto:laurenz(dot)albe(at)wien(dot)gv(dot)at]
Inviato: venerdì 19 settembre 2014 12:55
A: Enrico Olivelli - Diennea; pgsql-jdbc(at)postgresql(dot)org
Oggetto: RE: Please implement simple failover scenario

Enrico Olivelli - Diennea wrote:
> we are going to switch from Oracle to PostgreSQL and we would like to
> setup a simple hot-standby/warm- standby replication scenario.
>
> Actually your JDBC driver does not have native support for failover to the slave host.

Why don't you implement that on a lower level with virtual IP addresses?

You could configure failover so that a certain IP address always points to the current master. That way you only have to reestablish the connection when it fails.

Yours,
Laurenz Albe

Rimani aggiornato sul mondo dell’email marketing e del digital marketing: visita il nostro blog! http://blog.magnews.it