asked on

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?

strivoli

Very shortly: mirror, YES. Cluster, NO.

Alexey Komarov

Yes you can use mirror http://technet.microsoft.com/en-us/library/ms189852.aspx
You can also use geo-cluster http://technet.microsoft.com/en-us/library/ff878716.aspx

SOLUTION

ienaxxx

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

strivoli

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.

ASKER CERTIFIED SOLUTION

Alexey Komarov

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

strivoli

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.

mystikal1000

ASKER

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 :)

SOLUTION

strivoli

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mystikal1000

ASKER

Strivoli:

Can DataCenter 2 be a similar cluster as DataCenter 1?

SOLUTION

Alexey Komarov

membership