Solved

Geo-Site CLUSTER SETUP QUESTION

Posted on 2014-01-10
4
689 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 78

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 78

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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

740 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