?
Solved

Unix & C-ISAM backup to Disaster Recovery site

Posted on 2006-11-21
4
Medium Priority
?
389 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 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

Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

Question has a verified solution.

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

When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
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…
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Suggested Courses

770 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