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 atregular intervals.To test the idea, I remember writing a replicator that worked more on arecord by record basis. You just connect to a (possibly remote) storage server that you want to replicate, and also a localFileStorage. You iterate on the oid-records of the remote database andcopy those into the new. That establishes the base copy. After that,you use the invalidation lists to find out what records to re- retrieve, anddo 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.
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ QP mailing list [email protected] http://mail.mems-exchange.org/mailman/listinfo/qp
