Solved

Geo-Site CLUSTER SETUP QUESTION

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
free print management solution 5 46
Disable DFS Namespace referrals to folder targets during initial replication 2 55
Microsoft Access 32-bit or 64-bit? 11 59
Ransomware case 23 108
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

738 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