Re: trying to mirror a db
From: Jay Dee <ais01479_at_aeneas.net>
Date: Tue, 04 Apr 2006 02:10:50 GMT
Message-ID: <KAkYf.77814$UZ5.12306_at_tornado.ohiordc.rr.com>
Date: Tue, 04 Apr 2006 02:10:50 GMT
Message-ID: <KAkYf.77814$UZ5.12306_at_tornado.ohiordc.rr.com>
Ike wrote:
> If I have two databases, A and B, each with only one table, and the tables
> are supposed to miror each other (yet, B gets interacted with independent of
> A, and vice versa) and the table in A has a field for the timestamp of last
> activity for each record, as well as a field for the corresponing id of each
> record in B that the record in A corresponds to.
>
> I am trying to discern an alogirthm for maintining these two tables to be
> concurrent with each other. Does anyone have any ideas, given the
> description above for an algorithm to do this?
>
> Thanks, Ike
>
>
The answers you're looking for can be found by looking-up "distributed database" and "two-phase commit." Received on Tue Apr 04 2006 - 04:10:50 CEST