Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Unix & C-ISAM backup to Disaster Recovery site

Posted on 2006-11-21
4
Medium Priority
?
393 Views
Last Modified: 2013-12-23
Hi

Server - HP-UX (HP-UX xxxxxx B.11.11 U 9000/800)
ERP - Pronto ERP (www.pronto.com.au)
Database - C-Isam with SQL reporting

We are about to move to a new data warehouse (blade servers) and also have a new DR server at a seperate site approx 16k away.  We have created an extra 150+ programs (+ their own DB tables) that tie-in to Pronto and due to their complexity it would be impossible to log all transactions and subsequent entries to every table and therefore restoring trans from log files is not an option.  There is approximately 17gb of live critical data.  Some tables/files are over 2gb each.

Our requirement is to have the DR as up to date as possible in the event of a disaster.  Restoration from overnight back-ups is not an option as it would take too long to input the trans since last backup.
Is there an efficient solution to replicate (new) data/trans to the off-site DR without chewing up a lot of costly bandwidth traffic ??  

Thanks in advance

Cheers

Gav

0
Comment
Question by:gavcol
  • 2
  • 2
4 Comments
 
LVL 41

Expert Comment

by:noci
ID: 18000109
Probably look into a san solution, where you have a san mirror on both sites.
Only the actual changes (on a disk level) are transfered.
0
 

Author Comment

by:gavcol
ID: 18000239
Thanks noci,
   is this the only solution ?? mirrored san can be expensive

Gav
0
 
LVL 41

Accepted Solution

by:
noci earned 2000 total points
ID: 18000322
I think it is the one with most guarantees and least headaches.

You can think of a few storageworks boxes (not too large) to start with.
You will need some network between the sutes too, that also adds to the cost.
(ISDN will probably not pull it, fiberoptic will, the truth is probably in the middle).

And data is mirrored constantly. So if the transactions workout correctly you will
only loose active transactions. (the ones not comitted).

If the underlying layer is oracle or mysql there are different posibilities,
they both allow for settingup slave databases for storing the data.
0
 

Author Comment

by:gavcol
ID: 18005960
Thanks Noci,
   Looks like we are going to go with a mirrored san

Cheers

Gavin
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question