Article View: borland.public.interbase.replication
Article #175Re: Replicating with SQLMonitor
From: Jonathan Neve
Date: Wed, 27 Aug 2003 16:25
Date: Wed, 27 Aug 2003 16:25
28 lines
1973 bytes
1973 bytes
Craig Stuntz [TeamB] wrote: > Jonathan Neve wrote: > > >>All I would have to do would be parse the output of the SQLMonitor to >>turn it into a proper SQL statement, and then log it in a table in >>the database. The big advantage of this method is that I can be sure >>that the server will get exactly the same statements as the client, >>and hence, the results also should be the same. >> >>Any ideas? > > > I disagree with this "advantage." Imagine one DB with users active, > and one DB without other users. Run the same statement on both DBs. > The statement on the first DB might deadlock; the statement on the > second probably won't. So "merely" running the same SQL does not mean > you'll have identical results. > > -Craig > Obviously, I would have to replicate only statements that didn't give an error. But surely that shouldn't be so hard...? Thanks! Jonathan Neve.
Technical Details
Message-ID:
<3f4cdb7f@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailReferences:
<3f4c4486@newsgroups.borland.com> <3f4cc85f$2@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,34b4f8c43c880cd4 X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2003-08-27 09:32:42 PST Date: Wed, 27 Aug 2003 18:25:27 +0200 From: Jonathan Neve <jonathan@!nospam!microtec.fr> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.interbase.replication Subject: Re: Replicating with SQLMonitor References: <3f4c4486@newsgroups.borland.com> <3f4cc85f$2@newsgroups.borland.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 213.11.22.149 Message-ID: <3f4cdb7f@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1062001535 213.11.22.149 (27 Aug 2003 09:25:35 -0700) Lines: 29 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail