There's a similar product called Syncrify. Worth a look. Re dynamic files - remember that copying dynamic files is ONLY acceptable if the files have been closed and sync to disk. On your old version of UniVerse IIRC a DB Pause/resume does not sync the dynamic file headers as it does on current versions. I would check that with Rocket before you look at doing a dbpause/resume.
Dynamic files rely on current modulus, split and load information held in shared memory. That information is only written back when the file is closed. So you can copy the file over, but if that information is out of date the file will not be usable and will eventually corrupt. Brian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peter Cheney Sent: 05 September 2013 02:59 To: U2 Users List Subject: Re: [U2] REPLICATING DATA Re rsync for windows. Try installing Cygwin and then rsync under that. I've had good success in the past with a basic (non-gui) cygwin install on a windows machine for other projects and rsync certainly works well in that environment. You can also set it up with pub/priv key auth for non-interactive operation too. I think the more recent releases of rsync will allow you to pull or push data in non daemon mode. At least that's how I use it to backup my daily work from my centos workstation (no rsync daemon running) to my crunch-bang (debian) laptop. The laptop runs the rsync out of cron. The script detects which wireless network it's on so doesn't run when at home. Setting some flags in the file system from UV and visa-versa would give you a reasonably good integration with dbpause etc etc. Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e [email protected] | w www.firstmac.com.au ________________________________________ From: [email protected] [[email protected]] on behalf of Anthonys Lists [[email protected]] Sent: Thursday, 5 September 2013 8:55 AM To: [email protected] Subject: Re: [U2] REPLICATING DATA On 04/09/2013 20:27, Ard956 wrote: > We are on Windows Server 2003. I think you can get rsync for Windows, but also investigate robocopy. I don't know whether that can do the same. Basically, rsync will normally check file metadata and not try to copy stuff if it hasn't changed. If the metadata has changed, it will then compare MD5 sums or whatever of chunks of the file to identify which bits have changed. That way, if you have a 2Gb file and change one record, rsync will find the changed block and send just that, without having to copy the entire file. If you can find something like that, it'll give you far shorter network backup times. (Combined with DBPAUSE/DBRESUME, it might well give you zero backup downtime as seen by the users.) Cheers, Wol > > Sent from my iPad > > On Sep 3, 2013, at 1:45 PM, Wols Lists <[email protected]> wrote: > >> On 03/09/13 18:33, Ard956 wrote: >>> and we would keep replication in place as a DR solution. >> What OS are you on? >> >> Given that, I'd be inclined to use rsync - DBPAUSE the database to >> make sure it's quiescent, run an rsync, and then bring the database back. >> >> Dunno what the Windows equivalent of rsync is, but if you're backing >> up across machines, rsync tries to not copy stuff that hasn't changed. >> >> Cheers, >> Wol >>> >>> Sent from my iPad >>> >>> On Sep 3, 2013, at 1:30 PM, Ard956 <[email protected]> wrote: >>> >>>> We are moving our servers to a new colo and wanted to replicate from the server in the old colo to the one in the new colo and then flip over to the new server one weekend. Looking to have minimal down time. >>>> >>>> >>>> Sent from my iPad >>>> >>>> On Sep 3, 2013, at 12:26 PM, Baker Hughes <[email protected]> wrote: >>>> >>>>> Andrea - are you wanting to replicate for the purposes of having a warm backup as DR solution, or for reporting from, or some (what) other purpose? >>>>> >>>>> This question will dictate the strategy and what tools to employ. We copied the entire db every night to a hot system for Business Analysis. That was put in place before EDA was available. >>>>> >>>>> You could spend a lot of resources and time cobbling a 'replication solution' into place, while trying to dodge an upgrade... and perhaps spend more and have less satisfactory results than proceeding with standard methodology (upgrade to get the new toolset). >>>>> >>>>> HTH. >>>>> -Baker >>>>> >>>>> >>>>> -----Original Message----- >>>>> From: [email protected] >>>>> [mailto:[email protected]] On Behalf Of Ard956 >>>>> Sent: Tuesday, September 03, 2013 11:19 AM >>>>> To: [email protected] >>>>> Subject: [U2] REPLICATING DATA >>>>> >>>>> Does anyone do replication with a tool outside of the U2 toolbox? We are on UV 10.2.10 which does not support UV replication. We have no plans to upgrade at this time but need a backup for our Universe server. Our database is about 180GB. >>>>> >>>>> Thank you, >>>>> >>>>> Andrea Dente >>>>> Taylored Services >> _______________________________________________ >> U2-Users mailing list >> [email protected] >> http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ---------------------------------------------------------------------------- --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) ---------------------------------------------------------------------------- --- _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
