Solved

Unix & C-ISAM backup to Disaster Recovery site

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Don’t let your business fall victim to the coming apocalypse – use our Survival Guide for the Fax Apocalypse to identify the risks and signs of zombie fax activities at your business.
For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

856 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