Solved

SQL Clustering over WAN

Posted on 2011-09-07
4
516 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
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 to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 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