Alexander Staubo wrote:
On 6/1/07, gonzales@xxxxxxxxxxxxxx <gonzales@xxxxxxxxxxxxxx> wrote:
I'm disappointed because SLONY-II has not been released yet to support
multi-master replication!
I wouldn't pin all my hopes on a project still under development. (For
me, personally, add the fact that Slony-I still has not solved
single-master replication in a way that doesn't burden the
developer/DBA with lots of unnecessary extra maintenance; I am not
counting on its developers to fix this issue in Slony-II.)
In the meantime, Cybertec (http://www.postgresql.at/, an Austrian
company) just announced a commercial synchronous multimaster
replication product based on 2-phase commit. It's expensive, and I
can't speak for its maturity, and it may or may not scale as well as
the projected Slony-II design, but the setup seems dead simple, and
from the docs I have found it seems to transparently replicate schema
changes, unlike Slony-I. So that's something.
I could be completely cranked but I believe that product is based on
PgCluster which is horrendously slow.
To be fair, it is still under heavy development and does show promise.
Joshua D. Drake
Alexander.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
