Solved

SQL Clustering over WAN

Posted on 2011-09-07
4
530 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
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.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

628 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