SQL Clusters on Nutanix
Anyone running Traditional SQL Clusters on a Nutanix / HyperV implementation?
This topic has been closed for comments
Already have an account? Login
Login to the community
Login with your account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Assuming you mean a Failover Cluster configuration, then I believe this is (currently) not supported as this requires sharing the data accross all nodes.
I believe Nutanix does not support a CSV nor sharing a vhd(x) file.
We ended up using a SQL Server AlwaysOn configuration which is fully supported by Nutanix. Down side is that it requires an Enterprise license and more storage.
Hope this helps!
What part of SCSI3 persistant reservations are not supported? Is it only if shared VMDK's are used, or if, in a VMware example a SCSI adapter is set to physical bus sharing mode? Reason I am asking is I see a really good future use case with Storage Replica in the next version of Windows Server.
This still requires SCSI3 persistant reservations to talk to the underlying VMDK in Windows Failover Cluster manager, but the disks arent actually "shared" at the VMDK level as replication happens in-guest over SMB3 to the other cluster node. Reservations are only used to control locks to the destination replica at the OS level. I wrote about this in my blog here http://www.cloudypolitics.com/virtualize-windows-storage-replica-cluster-on-vsphere/
Hopefully with this feature we can create windows clusters on Nutanix using SQL Server Standard edition.
SCSI3 PR isn't implemented in the Nutanix SCSI stack as yet. So anything that requires SCSI3 PR, including Pass Through RDM's for Failover Clustering, will be prevented from working. However in the case of failover clustering there is a solution that will work on Nutanix using third party tools. If failover clustering for SQL Server and other applications is required then SIOS DataKeeper and other similar tools can be used to enable the traditional failover clusters.
These third party tools are supported by their respective vendors. I'll update this thread when there is more news on SCSI3 PR and also any validation / joint papers with SIOS and other vendors of similar technology.
Also SQL FCI aka MSCS aka Failover Cluster is now in tech preview with the use of in-guest iSCSI as of NOS 4.1.5.
Has this been tested yet?Jason
We have tested it internally in our QA and performance lab environments across the world under various different conditions for quite some time now (across all phases of testing). Performance may not be as good at the moment as it will be when the feature is GA. Tech Preview does not mean not tested. But it should be used in non-production environment until we fully GA the feature. It will become GA in a future release.
Is it going to be supported to synchronously replicate a pair of Windows Cluster VMs (VMWare) using Nutanix replication to another Nutanix cluster?
Is it even supported to have local Nutanix snapshotting of cluster pair of VMs?
Put another way, what options are there for protecting/DR of any cluster pair? Would prefer to keep away from SQL mirroring/log shipping.
I haven’t tested it, I’ll find out. But for SQL Server we would recommend FCI local site (clustering) with Availability Groups (replication) between sites. This will be application consistent, as anything we do at the storage level would only be crash consistent.
So here lies the problem with using AAGs for DR form a business PoV…….. it’s up against current SAN technologies like HP 3Par Cluster Extensions. This gives you multi-site synchronous stretched cluster capabilities under a SQL Standard license model. That deals with HA and DR. So, when we look at our current SQL project the SAN looks very appealing because it could make the difference between our SQL project costing £150k in SQL licenses or £600k. If Nutanix requires an Enterprise SQL license to achieve the same HA/DR capabilities via AAG, then the reduced TCO of any move from SAN to Nutanix could be negated by a need to go Enterprise, assuming of course there's no other driver to go Enterprise.
With the release of our v4.5 OS today we now support Windows Failover Cluster with in-guest iSCSI access with MPIO. This will help with your project and for other customers that need to support traditional failover clustering instead of or in addition to Always On Availability Groups.
so now nutanix support scsi right?.i am new to windows .can you provide some links about the traditional sql clutering?
SCSI3 PR isn't implemented in the Nutanix SCSI stack as yet. So anything that requires SCSI3 PR, including Pass Through RDM's for Failover Clustering, will be prevented from working. However in the case of failover clustering there is a solution that will work on Nutanix using third party tools. If failover clustering for SQL Server and other applications is required then SIOS DataKeeper and other similar tools can be used to enable the traditional failover clusters. These third party tools are supported by their respective vendors. I'll update this thread when there is more news on SCSI3 PR and also any validation / joint papers with SIOS and other vendors of similar technology.
@vcdxnz001 - Time for that update on the thread? :) . Since SCSI-3 PR support was added with AOS 5.17. How it affect WSFC configurations and related on each mayor hypervisor (AHV, ESXi and HyperV) running on Nutanix HCI. Thanks for sharing and commenting.
Here is a good reference: https://next.nutanix.com/archive-44/shared-storage-for-windows-server-failover-clusters-on-nutanix-27364
Now SCSI 3 PR is natively supported it works across hypervisors. For AHV if you connect vDisks to multiple VM’s and use WSFC it will natively work without any special configuration. Usually you would use a shared volume group between the VM’s for the cluster storage. This also works with RedHat and Linux clusters that use SCSI fencing. This is a major win and makes setting up failover clusters very simple.
For ESXi and Hyper-V you may need to use iSCSI connections to Volumes on AOS. Although I think you can pass the SCSI 3 PR command via SMB3 in Hyper-V, so it may also work natively with normal shared vDisks. Recommend using LTS release of 5.20 or above if possible so you get the latest features.
Here is a good article - http://longwhiteclouds.com/2020/11/09/simple-guest-os-clustering-without-complex-config/
Doing a WSFC configuration with WS2019 | ESXi 6.7 | AOS 22.214.171.124, all going well until we add a 5th disk. We are presenting using Nutanix Volumes. Then found this comment https://docs.microsoft.com/en-us/troubleshoot/windows-server/high-availability/scsi-3-persistent-reservation-test-fail. A sort of configured limit could be the reason?. Any advice? - thank you!
There is no configured limit. Are you using iSCSI connections to those volumes? I would suggest opening a support request for that.
Yes, using iSCSI connections. Already working with Nutanix Support.