Re: Slightly OT.

Alexander Staubo wrote:
> On 6/1/07, gonzales(at)linuxlouis(dot)net <gonzales(at)linuxlouis(dot)net> 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/