Re: Best high availability solution ?

[Arnaud Lesauvage <thewild(at)freesurf(dot)fr>]

Markus Schiltknecht a écrit :
> Hi Arnaud,
>
> perhaps you can still use Slony-I for replication and have another tool
> automatically handle connections (check out PgPool[1] or SQLRelay[2]).
>
> Or go for a middleware replication solution. Check C-JDBC[3], perhaps
> there is something similar for ODBC?
>
> LifeKeeper seems to handle replication at a lower level (filesystem,
> distributed memory, or such) and does not seem to be very well suited
> for database replication. However, I've had just a quick glance at the
> website.
>
> Hope that helps
>
> Markus
>
> [1]: http://pgfoundry.org/projects/pgpool/
> [2]: http://sqlrelay.sourceforge.net/
> [3]: http://c-jdbc.objectweb.org/


Hi Markus !

Thanks for your suggestions, they are very helpful !
pgpool and SQLRelay looked really great, but there are no ports 
for win32... :(
Maybe some kind of virtual-ip software would do the trick, but I 
am still looking for it !

--
Arnaud