Solved

Unix & C-ISAM backup to Disaster Recovery site

Posted on 2006-11-21
4
377 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 40

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 40

Accepted Solution

by:
noci earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Firewall port opening 2 58
No RSTP between switches 3 46
Classlful vs Classless subneting 18 61
Booster, Repeater, or Wireless Access Point 9 44
Some time ago I was asked to set up a web portal PC to put at our entrance. When customers arrive, they could see a webpage 'promoting' our company. So I tried to set up a windows 7 PC as a kiosk PC.......... I will spare you all the annoyances I…
Let’s list some of the technologies that enable smooth teleworking. 
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 tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now