Re: Replication - Mailing list pgsql-general

From Eric Comeau
Subject Re: Replication
Date
Msg-id E6F241DAF915E24F9E34757342EE3E226A8898@ottas09a.ott.signiant.com
Whole thread Raw
In response to Replication  (Pailloncy Jean-Gérard <pailloncy@ifrance.com>)
Responses Re: Replication
List pgsql-general
>
> On Tue, Apr 20, 2004 at 11:26:24AM +0200, Pailloncy Jean-G?rard wrote:
> > Hi,
> >
> > I just see that Mysql will propose at the end of the month a full
> > synchronous replication system with auto-recovery.
>
> Well, sort of.  It seems to be yet another 80/20 Solution From MySQL
> (tm).
>
> It looks like it's based on a new table type.  It stores everything
> in memory, and then writes out asynchronously.  This strikes me as
> pretty dangerous from the point of view of reliability: what if the
> box dies before the write is complete?  (And don't tell me about
> super-redundant high-availability hardware.  I _have_ all that.  All
> hardware sucks; HA stuff just sucks less often at a higher price.)
> Also, it doesn't support the other table types.  I don't want to
> contemplate the horrible mess you'd have to clean up if you had a
> transaction crossing three table types and get a hardware failure.
>
> I'm afraid I agree with the recently-posted Oracle Veep interview:
> this does not represent any serious challenge to the core ORAC
> market.

What is Oracle selling as their replication solution these days?
When I still had a MetaLink userid they had posted a
   "Product Obsolescence Desupport Notice"
for
    "Oracle Replication Services"
The dates where something like:

Desupport End Dates
 Error Correction Support: 01-SEP-2002
 Extended Assistance Support: 01-SEP-2005

Oracle Recommended customers upgrade/migrate to the following...
which was no migration path exits, as no new versions will be release
and no replacement product is available

Their ORAC if I understand it correctly is a "cluster" solution and
no a "replication" solution.

Guess I should visit their web site and see what they are pedaling for
replication over WAN links these days.

>
> > I use PostgreSQL and I would appreciate to have the same
> features in
> > PostgreSQL.
>
> Sure, so would I.  Talk to Jan Wieck about what he plans to do
> about it, and maybe consider supporting that development work too ;-)
>
> A
>
> --
> Andrew Sullivan  | ajs@crankycanuck.ca
>

pgsql-general by date:

Previous
From: Simon Moses
Date:
Subject: loading data into postgresql became slow after i used VACUUME command.
Next
From: Ken Harris
Date:
Subject: List Removal