Re: Slightly OT. - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Slightly OT.
Date
Msg-id 4660367C.4050905@commandprompt.com
Whole thread Raw
In response to Re: Slightly OT.  ("Alexander Staubo" <alex@purefiction.net>)
Responses Re: Slightly OT.  ("Alexander Staubo" <alex@purefiction.net>)
List pgsql-general
Alexander Staubo wrote:
> On 6/1/07, gonzales@linuxlouis.net <gonzales@linuxlouis.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/


pgsql-general by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: Slightly OT.
Next
From: Csaba Nagy
Date:
Subject: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum