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 ?