Solved

Off-Site Backup or Replication for a database on SCO Unix

Posted on 2004-10-13
5
252 Views
Last Modified: 2013-12-05
I am looking for a solution to enable off-site backup, or ideally a redundant, replicated off-site server to provide fault tolerance for a database running under SCO Unix.  The database is a proprietary one from a 3rd party vendor who does not offer any solution for this.  If there is a way to replicate the entire server, that would be ideal, so that we could fail-over in the event of an outage.  There is a point-to-point T1 available between both sites, and it should be more than enough bandwidth to handle replication in real-time or incremental nightly backups based on the amount of data change each day.

This project is in conjunction with similar off-site backup/replication implementation for Windows 2003 and Exchange 2003 servers, for which we have already found a solution, but if there is an application which can handle all three in a Windows environment, we would defintiely be interested in that as well.
0
Comment
Question by:TeeSeePeeEyePee
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:Cyber-Dude
ID: 12306538
Back from a small vacation and I have this beuty question:
Those solutions we sell for lots of $$$$$.... why? Because youed have to analyse the way traffic floats and how to use this analysis to broadcast data into another and additional location and use that additional location to parallelicly calculate that data.
;)

But heres a tip:
UNIX has the ability to use shared computing architecture thus creating true cluster (if i'm not mistaken, you may use the 'split' or 'fork' commands to initiate such process). I am less familliar with SCO Unix but, sience it is a UNIX system, there might be a chance for you to do the same.

Links:
What is the 'Fork' handling?
http://web.ccr.jussieu.fr/ccr/Documentation/Calcul/usr-share/html/idebug/en_US/concepts/cbwfork.htm

Clustering architecture review in Linux (which may implcate the SCO UNIX as well):
http://lcic.org/reviews/0672323680.html

PS
Once you created clusterring; there is no problem in relocating the clusterred unit remotley...

Hope that helped in a way...

Cyber
0
 
LVL 2

Author Comment

by:TeeSeePeeEyePee
ID: 12309219
Cyber,

Thanks for the ideas, I am taking a look at them.  Basically the aim here is to not have to change the running server much (if at all).  If there is an option, I would like to see something for UNIX like DoubleTake or NovaStor which we use for Windows servers.  Along the same lines, we could build out clustering and AD replication on the Windows side, but these products make it a lot easier to configure, monitor and manage.
0
 
LVL 15

Expert Comment

by:Cyber-Dude
ID: 12309321
I Understand that; But any layer you will add to get to your goal will eventually reduce performance. You may consider MS Storage Server which supports UNIX as well. But than again; you are not using any of the server natural environment where writing a script may contribute in both performance and reliability.

If you are intrested in the MS oriented solution I will post it to you.

Cyber
0
 
LVL 2

Author Comment

by:TeeSeePeeEyePee
ID: 12309891
We do not have the UNIX skills in-house to "home-roll" and support such a soultion, so if you have some ideas that are more MS-oriented, we could probably implement them far more quickly.
0
 
LVL 15

Accepted Solution

by:
Cyber-Dude earned 500 total points
ID: 12316435
OK than;

There is a way to implement (see the document via the following link) where you can create an additional clustering unit where both duplicated UNIX boxs will be located each on another location.

Your site will look like the following:

|LAN|<-->|UNIX|
                |Windows Storage Server 2003|
                 ^
                  |
                 Remote Site
                 |Unix|

The following link contains a document specifically on that issue:
http://www.microsoft.com/windowsserversystem/wss2003/techinfo/plandeploy/wsshybridnetwork.mspx

Hope that helped some how... Other than that; I would suggest you to hire a UNIX professional to analyse the system and implement all that project.

Cyber
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

708 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

13 Experts available now in Live!

Get 1:1 Help Now