Mirror and Clustering a DB

Is it possible to use a mirror and cluster on a Database in SQL 2008/2012 R2 between 2 data centers?
LVL 1
mystikal1000Asked:
Who is Participating?
 
strivoliCommented:
Very shortly: mirror, YES. Cluster, NO.
0
 
Alexey KomarovChief Project EngineerCommented:
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
ienaxxxCommented:
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
 
strivoliCommented:
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
 
strivoliCommented:
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
 
mystikal1000Author Commented:
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
 
strivoliCommented:
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
 
mystikal1000Author Commented:
Strivoli:

Can DataCenter 2 be a similar cluster as DataCenter 1?
0
 
Alexey KomarovChief Project EngineerCommented:
0
 
Alexey KomarovChief Project EngineerCommented:
0
 
strivoliCommented:
Yes, it can be similar.
0
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.

All Courses

From novice to tech pro — start learning today.