Article View: borland.public.interbase.replication
Article #181Re: Replication techniques
From: Craig Stuntz [TeamB]
Date: Mon, 15 Sep 2003 18:16
Date: Mon, 15 Sep 2003 18:16
23 lines
2154 bytes
2154 bytes
Mark Boler wrote: > very small databases, but yes, you are right You could use a timestamp as well to reduce the number of comparisons you do. This could break if the server clocks go wildly far apart, but most replication systems have a synchronize option as well as replicate -- replicate tries to do changed records only, synchronize copies the whole DB. You don't actually need a GUID, either. You need to know which site changed the record and the "edit sequence". A generator is fine for the latter, and the site ID can be part of the trigger. The advantage of this is that you can do it with standard IB tools only -- a UDF or something would be required for a GUID. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Performance Monitor -- Analyze and control your IB7 server: http://delphi.weblogs.com/IBPerformanceMonitor
Technical Details
Message-ID:
<3f6601ff@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailReferences:
<3f45bc5d@newsgroups.borland.com> <3f462700$1@newsgroups.borland.com> <3f64d442$1@newsgroups.borland.com> <3f65cf28@newsgroups.borland.com> <3f65fdda$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,b1ab3f5d8eb439e6 X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2003-09-15 11:25:30 PST From: "Craig Stuntz [TeamB]" <cstuntz@vertexsoftware.com> Subject: Re: Replication techniques Newsgroups: borland.public.interbase.replication Reply-To: "Craig Stuntz [TeamB]" <cstuntz@nospam.please [but use vertexsoftware.com to send email]> References: <3f45bc5d@newsgroups.borland.com> <3f462700$1@newsgroups.borland.com> <3f64d442$1@newsgroups.borland.com> <3f65cf28@newsgroups.borland.com> <3f65fdda$1@newsgroups.borland.com> Organization: Vertex Systems Corporation User-Agent: XanaNews/1.15.6.3 NNTP-Posting-Host: 24.106.104.202 Message-ID: <3f6601ff@newsgroups.borland.com> Date: 15 Sep 2003 11:16:31 -0700 X-Trace: newsgroups.borland.com 1063649791 24.106.104.202 (15 Sep 2003 11:16:31 -0700) Lines: 23 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail