2013-09-19 02:24 PM - edited 2015-12-18 01:12 AM
Is the following setup supported / doable from a SQL 2012, SnapDrive & SMSQL perspective:
A local 2-node SQL 2012 AlwaysOn Failover Cluster Instance, stretched to a 3rd, remote node via AlwaysOn Availability Group?
2013-10-01 05:48 AM
Many thanks for your response.
In practical terms though - how do we provision LUNs with SnapDrive? AlwaysOn AG operates on top of a 3-node MS cluster, which includes 2 local & 1 remote node. SnapDrive plainly refuses to create a drive associated with local nodes only.
2013-10-03 07:17 AM
In the meantime I figured out following workaround for creating LUNs:
Can anyone tell me if there is a less clunky method of achieving this?
2013-10-03 09:09 AM
I don't want to create any confusion and I mean no disrespect, but the statement from "Welch" that this is a supported configuration is incorrect. The IMT has no stated support for this configuration and I have run this post and question by 2 different Senior Support Engineers and this is their response:
"Combining a SQL FCI with an availability group is not supported in SnapDrive/SMSQL. This is due to a limitation within SnapDrive that attempts to communicate with all nodes defined within the cluster object.
Typically, we would suggest that for these three nodes, each node have dedicated storage, rather than use a failover instance (with shared storage) in the primary location."
2015-03-13 09:36 AM
Has this situation changed? Has been that Snapshot Limitation been corrected? FCI provides some benefits different to the AlwaysOn. How can we raise the important of this support?
2015-06-16 05:00 AM
We are looking at aquiring NetApp as our SAN solution and our planned configuration for the SQL\cluster architecture was the same\similar as described here. Of course the sales people said it i was no issue. It sounds like it actually is. I am interested in more information on what you did as a solution, or was it just a work around? Since I am in the beginning stages I want to make sure I set this up right the first time.