VMware Cloud Community
paul_son
Contributor
Contributor
Jump to solution

MSCS in vSAN 6.1

I have a question about configuration SQL Server Cluster(MSCS) on vSAN 6.1.

is it right configuration that two SQL Servers on MSCS are running on same node.

Is it can that two SQL Servers running on different node based on shared volume(vSAN) configuration ?

1 Solution

Accepted Solutions
TheBobkin
Champion
Champion
Jump to solution

Hello,

What type of MSCS cluster are you aiming to set-up here?

Please note that the only supported iteration of this on vSAN is SQL Server Always On Availability Groups, MSCS with shared-disks is not supported:

"Microsoft Windows Server Failover Clustering (WSFC) is supported with VMware vSAN version 6.1 and later for SQL Server Always On AG (non-shared storage)."

kb.vmware.com/kb/2147661

Bob

-o- If you found this comment useful please click the 'Helpful' button and/or select as 'Answer' if you consider it so, please ask follow-up questions if you have any -o-

View solution in original post

3 Replies
GreatWhiteTec
VMware Employee
VMware Employee
Jump to solution

From an HA perspective, it doesn't make sense to have both VMs on the same host. Please refer to MSCS best practices for vSphere for VM placing.

For vSAN, you may want to read this document for best practices Storage and Availability Technical Documents

TheBobkin
Champion
Champion
Jump to solution

Hello,

What type of MSCS cluster are you aiming to set-up here?

Please note that the only supported iteration of this on vSAN is SQL Server Always On Availability Groups, MSCS with shared-disks is not supported:

"Microsoft Windows Server Failover Clustering (WSFC) is supported with VMware vSAN version 6.1 and later for SQL Server Always On AG (non-shared storage)."

kb.vmware.com/kb/2147661

Bob

-o- If you found this comment useful please click the 'Helpful' button and/or select as 'Answer' if you consider it so, please ask follow-up questions if you have any -o-

paul_son
Contributor
Contributor
Jump to solution

Very Thanks,

0 Kudos