Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-general(at)postgresql(dot)org
Subject: Re: Batch replication ordering (was Re: [GENERAL] 32/64-bit
Date: 2003-04-14 19:16:42
Message-ID: 3E9B091A.2E76F7E9@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I saw somewhere on this thread that there is no way to tell when
something is committed. that really doesn't make sense, since postgres
is a MVCC system. Doesn't the versioning automatically supply commit
times?

"Ed L." wrote:
>
> On Monday April 14 2003 12:20, Andrew Sullivan wrote:
> > On Fri, Apr 11, 2003 at 06:34:53PM -0400, Jan Wieck wrote:
> > > A) You apply those changes in the order you read them out of the master
> > > on the slave. This requires that you do it all in one big transaction
> > > on
> > >
> > > B) You read all the changes across all tables, but regroup them into
> > > their correct order and original transaction boundaries for playback on
> > >
> > > B2) You read all the changes across all tables simultaneously via
> > > cursors. Worst case you need as many cursors as you have tables and
> > > it's
> >
> > What I am confused about is why one needs to apply now-superseded
> > transactions on the slave at all. Don't you just want a
> > (serializable, mind) snapshot of the master to be applied to the
> > slave?
>
> I'd say, yes, if the process of creating such a snapshot is not overly
> intensive or lengthy. IMO, this is one potentially significant drawback of
> the dbmirror approach in general. The upside to dbmirror is that its
> pretty straight-forward, works pretty well for certain situations, it's
> open source, and it's free.
>
> I know rserv/erServer are reported to use the snapshot approach. But rserv
> didn't work at all for me without mods and looks very much like an
> abandoned prototype for eRServer. ERServer, its successor, is done in part
> by Vadim M. who if I'm not mistaken did an excellent job with MVCC. But,
> at least as of Feb 28, 2003, eRServer was $10,000 minimum, closed source,
> doesn't replicate DDL either, doesn't release trial versions, and has no
> plans to support Redhat 8.0. For us, that was more than enough incentive
> to investigate the alternatives.
>
> I think that'd be a great improvement for dbmirror, along with DDL
> replication.
>
> Opinions on a better *currently available* option?
>
> Ed
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-04-14 19:17:26 Re: PostgreSQL on a Cluster
Previous Message Jay O'Connor 2003-04-14 19:09:11 Re: Inserting a needed record before a select