Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Clustering over WAN

Posted on 2011-09-07
4
Medium Priority
?
540 Views
Last Modified: 2012-05-12
I am looking at the feasability of clustering SQL Server 20008 across a WAN between 2 remote dada centres. We would be looking at using Windows 2008 Server and SQL server 2008.

Firstly, is this achievable? Are there any caveats, The two locations are not sharing the same Storage.
0
Comment
Question by:mukvinman
  • 2
4 Comments
 
LVL 17

Expert Comment

by:OriNetworks
ID: 36494859
One of hte requirements of sql clustering is a shared storage model. Since you do not have shared storage, mirroring or log shipping may be more relevant for your purposes.
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 36502356
<<Firstly, is this achievable? >>
Yes but you have 4 additional requirements over traditional clustering :

> A perfect network
> A smart virtual storage layer that emulates a single storage unit across the two nodes.  A solution such as Storage Foundation can hel achieve that.
> A distance inferior to 3 mlies for latency purposes
> A lot of work to maintain the solution: network monitoring, failover strategy, transactional fault tolerance effectiveness

In general, the favored option regarding disaster site recovery is Database MIrroring. Forget about clustering over a WAN.  It is very tricky to maintain.
0
 

Accepted Solution

by:
mukvinman earned 0 total points
ID: 36593189
question closed, solution achieved
0
 

Author Closing Comment

by:mukvinman
ID: 36813420
closed
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

963 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