Solved

Mirror and Clustering a DB

Posted on 2013-12-05
12
281 Views
Last Modified: 2013-12-18
Is it possible to use a mirror and cluster on a Database in SQL 2008/2012 R2 between 2 data centers?
0
Comment
Question by:mystikal1000
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 19

Expert Comment

by:strivoli
Comment Utility
Very shortly: mirror, YES. Cluster, NO.
0
 
LVL 4

Expert Comment

by:alexeykomarov
Comment Utility
0
 
LVL 10

Assisted Solution

by:ienaxxx
ienaxxx earned 100 total points
Comment Utility
Very short answer YES AND YES.
You mean a failover Cluster on each DC (or at least in the production site) and a mirror in between, right?

I currently HAVE this configuration.
0
 
LVL 19

Expert Comment

by:strivoli
Comment Utility
I assume the cluster is a "classic" cluster: 2 nodes and 1 shared storage. I understood the question was about creating a cluster where node1 is located in DataCenter1, node2 is located in DataCenter2 and the shared storage is somewhere between DataCenter1, DataCenter2 or another location. This is why I responded, NO.

I'm not aware of geo-cluster.
0
 
LVL 4

Accepted Solution

by:
alexeykomarov earned 300 total points
Comment Utility
0
 
LVL 19

Expert Comment

by:strivoli
Comment Utility
Thank you alexeykomarov. Very good document!

You are right as long as the scenario is accepted. I've seen the doc very quickly and it involves 2 clusters in 2 DataCenters synced. If this is what the requester is searching for, then YES, you are right. Elsewhere, I'm right.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Author Comment

by:mystikal1000
Comment Utility
Is it wise to use a cluster and failover on SQL 2008 R2 between 2 datacenters or would it be more simplistic just to go with a mirror?  The reason I ask what if the active node goes down and passive takes over, could it break the mirror?  I just don't want headaches with that configuration.  Ease my mind :)
0
 
LVL 19

Assisted Solution

by:strivoli
strivoli earned 100 total points
Comment Utility
I don't know what's the budget for this project, but... I think a (very) good solution is a cluster (let's make it simple: 2 nodes: active/passive + 1 shared storage) on DataCenter1 which mirrors on DataCenter2.
If the active goes down, the passive takes over, and, NO, it won't break the mirror.
0
 
LVL 1

Author Comment

by:mystikal1000
Comment Utility
Strivoli:

Can DataCenter 2 be a similar cluster as DataCenter 1?
0
 
LVL 4

Assisted Solution

by:alexeykomarov
alexeykomarov earned 300 total points
Comment Utility
0
 
LVL 4

Expert Comment

by:alexeykomarov
Comment Utility
0
 
LVL 19

Expert Comment

by:strivoli
Comment Utility
Yes, it can be similar.
0

Featured Post

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now