Peter Eisentraut wrote:
> I was at the ObjectWeb Conference today; ObjectWeb
> (http://www.objectweb.org) being a consortium that has amassed quite an
> impressive array of open-source, Java-based middleware under their
> umbrella, including for instance our old friend Enhydra. And they
> regularly kept mentioning PostgreSQL in their presentations.
>
> To those that are interested in distributed transactions/two-phase commit,
> I recommend taking a look at Clustered JDBC
> (http://c-jdbc.objectweb.org/). While this is not exactly the same thing,
> it looks to be a pretty neat solution for a similar class of applications.
> In particular, it provides redundancy, load balancing, caching, and even
> database independence.
>
It is indeed a nice solution but it is far from ready yet.
Especially the disaster recovery mechanism and things such as adding new
masters need some more work.
What I really miss is "DECLARE CURSOR". Maybe it will be in there some
day :).
However, we have done some real testing with sync replication (4 x pg, 1
x oracle). It performed surprisingly well (the JDBC part, not the Oracle
one ;) ).
Maybe this will be something really useful within the next few months.
Cheers,
Hans
--
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706 or +43/660/816 40 77
www.cybertec.at, www.postgresql.at, kernel.cybertec.at