VMware Cloud Community
soerenv
Contributor
Contributor
Jump to solution

MSCS - Clustering in a box

Hello All,

Is clustering in a box (CIB) possible and supported on vsan?

 

Thanks in advance.

0 Kudos
1 Solution

Accepted Solutions
Anton_Kolomyeyt
Hot Shot
Hot Shot
Jump to solution

For SQL Server the best thing you can do is to use AlwaysOn Availability Groups. This config requires Windows Cluster but does not require shared storage. See:


Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group - Canadian IT Professionals - ...


Let's assume you have 3 physical hypervisor hosts. So make:

HostA: Primary SQL Server VM

HostB: Secondary SQL Server VM

HostC: Windows VM with SMB3 share to handle MSFT cluster witness

Simple Smiley Happy

Good luck!

Anton

--

I want to find out what my possibilities are for Microsoft SQL Server 2012.

I know I have VMWare HA, but MS clustering gives some advantages regarding maintenance, and is also useful in case of OS error (BSOD).

I am also looking at the "Always On", but that is an SQL Server Enterprise Edition feature, and it has to be supported by the applications as well.

View solution in original post

0 Kudos
4 Replies
vThinkBeyondVM
VMware Employee
VMware Employee
Jump to solution

Officially (from VMware) vSAN is not supported on MSCS. However, as per my understanding, it may work for CIB. You can give a try in test environment. 

Message was edited by: Vikas


----------------------------------------------------------------
Thanks & Regards
Vikas, VCP70, MCTS on AD, SCJP6.0, VCF, vSphere with Tanzu specialist.
https://vThinkBeyondVM.com/about
-----------------------------------------------------------------
Disclaimer: Any views or opinions expressed here are strictly my own. I am solely responsible for all content published here. Content published here is not read, reviewed or approved in advance by VMware and does not necessarily represent or reflect the views or opinions of VMware.

Anton_Kolomyeyt
Hot Shot
Hot Shot
Jump to solution

Directly - no. But you may run "proxy" VM feeding some shared storage to MSCS. What exactly do you want to cluster?

--

Is clustering in a box (CIB) possible and supported on vsan?

soerenv
Contributor
Contributor
Jump to solution

I want to find out what my possibilities are for Microsoft SQL Server 2012.

I know I have VMWare HA, but MS clustering gives some advantages regarding maintenance, and is also useful in case of OS error (BSOD).

I am also looking at the "Always On", but that is an SQL Server Enterprise Edition feature, and it has to be supported by the applications as well.

0 Kudos
Anton_Kolomyeyt
Hot Shot
Hot Shot
Jump to solution

For SQL Server the best thing you can do is to use AlwaysOn Availability Groups. This config requires Windows Cluster but does not require shared storage. See:


Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group - Canadian IT Professionals - ...


Let's assume you have 3 physical hypervisor hosts. So make:

HostA: Primary SQL Server VM

HostB: Secondary SQL Server VM

HostC: Windows VM with SMB3 share to handle MSFT cluster witness

Simple Smiley Happy

Good luck!

Anton

--

I want to find out what my possibilities are for Microsoft SQL Server 2012.

I know I have VMWare HA, but MS clustering gives some advantages regarding maintenance, and is also useful in case of OS error (BSOD).

I am also looking at the "Always On", but that is an SQL Server Enterprise Edition feature, and it has to be supported by the applications as well.

0 Kudos