Solved

Geo-Site CLUSTER SETUP QUESTION

Posted on 2014-01-10
4
668 Views
Last Modified: 2014-01-14
Hi,

I am trying to setup a multi-site cluster for SQL and have questions on it.

OS- Win 2012 R2
SAN - Netapp (site to site replication in place)

Site A - 2 nodes (shared storage)
Site B (DR) - 1 node (?)
File witness will be setup on Site C.

I have already setup a 2 node windows failover cluster at Site A with shared storage on Netapp. I am not clear about setting up the 3rd node. With Netapp, when I do the replication, the LUN's at the secondary site will be in read only mode till I break the replication. How will the third node(site B) able to look at the shared storage on site A.

How do I setup the storage for the third node ? Also how do I add the third node in cluster when it will not be looking at the same storage ?

My application for clustering is SQL 2012.

Can someone give any design tips ?
0
Comment
Question by:techguy111
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:arnold
ID: 39772686
The geo setup has to have the storage local which your netapp replication suggested.
Netapp site teosinte replication suggests that site b has a netapp.

Are you setting up cluster site A mirroring to cluster/node on site B?
Using automated transition is not advisable given a sql node failover may trigger the mirroring failover.
Mirroring failover would need to be manual or there needs to be an allowance for the mirroring failover to occur only after 60 seconds as it often takes about 15-30 seconds for a cluster transition.

If you have a netapp to netapp SAN copy, the sql services on the siteb node/system is off until it is needed.

An older article but may help in focusing what you have and what you want.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/40bce680-0fef-40af-98f4-b02c2076f900/sql-server-2012-alwayson-and-geoclustering?forum=sqldisasterrecovery
0
 

Author Comment

by:techguy111
ID: 39772717
Yes I have a netapp on both sites. And we do have snapmirror licenses and necessary network in place for replication.

Currently I only have 2 node windows failover cluster setup in site A. I am still exploring the best options for setting up the node on site B and determining how to add the node to the cluster.

When you say "mirroring failover" is it the Snapmirror failover on netapp ?  We have to quiesce the snapmirror, break it then either resync or reverse resync it. That certainly is not automated.

Once I setup the third node in site B, adding it to the cluster is fairly straigtforward with the quorum node to be - Node and file share majority and the file share witness being on site C.

But what I am not understanding is how do we install DTC and SQL application in the cluster since the storage is entirely separate on site A and site B.

If my site A has 3 LUN's for log, data and DTC will I be mirroring the LUN's to site B and attaching them to the node on Site B. Is this the best way and only way or is there some other way we can do it ?

When I install SQL on the third node at Site B, will I have to break the mirror, proceed with installation , then stop sql services and then again start mirroring again ?

Also what I am doing is the "Asyncronous DB Mirror"

What about the always ON scenario ? How can I accomplish that. I believe that will be the more preferred option.
0
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 39773384
The always on is an overlay in simplistic terms.

Always on effectively manages the mirroring of the data.
Note that SAN level replication necessarily means that the application can not be running.

A geographic setup has cluster on site a accesses the storage local to site a while the nodes on site b will access the local storage on site B.
The resource mapping will be the same.
Older cluster geographic nodes had to be NATTed dealing with IP transitions.

The IP transition between/among location requires you to own your own IP blocks and have peering agreements to advertise the path as it transitions.

Presumably, both locations are serviced/managed by the same entity through whom you can facilitate the IP transitions and the only remaining functionality you would need to setup is the transition between the sites.
0
 

Author Comment

by:techguy111
ID: 39781326
Thanks for your response. We have the networking part in place with a site to site VPN available.

We will most probably go in for "Always On" - SQL based replication.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Recently, I was assigned the task of performing a hardware refresh in the datacenter. The previous Windows 2008 systems were connected to the SAN via fiber channel HBA’s and among other thing, had PowerPath installed in order to provide sufficient f…
The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…

920 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

12 Experts available now in Live!

Get 1:1 Help Now