Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Geo-Site CLUSTER SETUP QUESTION

Posted on 2014-01-10
4
Medium Priority
?
721 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 81

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 81

Accepted Solution

by:
arnold earned 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 (…
Know what services you can and cannot, should and should not combine on your server.
In this Micro Tutorial viewers will learn how they can get their files copied out from their unbootable system without need to use recovery services. As an example non-bootable Windows 2012R2 installation is used which has boot problems.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
Suggested Courses

581 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