Solved

Unix & C-ISAM backup to Disaster Recovery site

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Forwarding web requests to different web servers 15 118
using BGP Attributes 2 89
eigrp routing loop 5 42
Dell Powerconnect Switch lost username/password 2 42
Let’s list some of the technologies that enable smooth teleworking. 
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

777 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