On 13/09/2007, at 7:58 PM, David Binger wrote:

> I think rsync can be used on a Durus database without pausing the
> main server.
> Here, we just use a cron job with scp from a remote machine to pull
> a copy at
> regular intervals.
>
> To test the idea, I remember writing a replicator that worked more
> on a
> record by record basis.   You just connect to a (possibly
> remote) storage server that you want to replicate, and also a local
> FileStorage.  You iterate on the oid-records of the remote database
> and
> copy those into the new.  That establishes the base copy.  After that,
> you use the invalidation lists to find out what records to re-
> retrieve, and
> do this in a polling loop, sleeping a little to give the remote server
> a chance to do something useful.    Even though this is fairly simple,
> rsync or scp seems even simpler.

Thanks David,
The rsync option definitely sounds simplest, I'm all for that! My
concern, which may be completely unfounded, was over what would
happen if the main server was doing writing and the rsync therefore
pulls across invalid data, I'll poke around with that and see what
happens.

Peter W.