• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

SQL Clustering over WAN

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.
  • 2
1 Solution
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.
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<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.
mukvinmanAuthor Commented:
question closed, solution achieved
mukvinmanAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now