Solved

Geo-Site CLUSTER SETUP QUESTION

Posted on 2014-01-10
4
678 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Accessing SQL Server Instance from outside the network 29 109
Migrating WDS from Windows 2008 R2 to 2012 R2 4 28
Event 4625 - Account Name: _ 3 28
Microsoft Licensing 3 26
This article will review the basic installation and configuration for Windows Software Update Services (WSUS) in a Windows 2012 R2 environment.  WSUS is a Microsoft tool that allows administrators to manage and control updates to be approved and ins…
What to do when Windows Update is not working correctly? What tools can I use to detect the cause of the malfunction problem? What does this numeric error code mean? These and other questions that you have been asking in the past are answered here (…
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). …
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

777 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