question

Wizedude avatar image
Wizedude asked

create VM SQL cluster with SAN storage

Hi,

I have a 3 node windows server cluster connected to a netapp SAN (iscsi) and i have created all CSV's and added storage from the SAN to the cluster and all working and failover works as expected. Now I need to create a 2 VM SQL cluster but i need advice on how i can connect storage from the SAN for the new SQL cluster. Do I need to create separate LUNs on the SAN directly and then connect these to the SQL cluster directly through ISCSI for the cluster disks or is there a better way of adding the storage to the SQL cluster. I just need to make sure that if i need to failover the SQL cluster everything stays working as expected.

clusteringstoragestorageareanetwork
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

What type of HA for SQL are you putting in place? A SQL Failover Cluster Instance or a SQL Always On Availability Group?

Depending on what type of HA solution you are putting in place, will depend on what you need to do in terms of storage.

If you are putting in a SQL Failover Cluster Instance, you would set the disks up as you would any other Windows cluster, so that they can fail between the cluster nodes, just because this has SQL on, doesn't detract the technology from it's basic underpinnings, so just setup the disks like you have done already on the 3 node cluster you have already provisioned.

If you are doing SQL Always On Availability Groups, then there is no need for CSV's, each node most have dedicated storage which does not failover between the replicas, so you can just present the disks to the nodes without the need to cluster them. This does mean you need "number of nodes * amount of storage", do for 2 nodes you need double the storage, 3 nodes triple the storage etc.

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wizedude avatar image Wizedude commented ·

Hi, Yes i am using virtual SQL Failover Cluster Instance, so i would then just provision the volumes on the SAN and then pass these disks through via iscsi to the virtual VM SQL cluster

0 Likes 0 ·
anthony.green avatar image anthony.green Wizedude commented ·
Yes, that's correct, in the same way you did the original 3 node cluster
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.