Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Clustering over WAN

Posted on 2011-09-07
4
Medium Priority
?
544 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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

580 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