Microsoft SQL Cluster on Nutanix HCI environment

David Pérez Bonilla
David Pérez Bonilla used Ask the Experts™
on
Hi team,

Is it possible to create a Microsoft SQL Cluster in a Nutanix HCI environment with two Virtual Machines if the share storage is unique for the three hardware nodes? In negative case, which possibility exist to implementing virtual cluster to Microsoft SQL Server in this environment? I looking for a HA solution because actualy the Data Base is in unique Virtual Machine with the problem entails in the time to maintenance the server without interruption in te productivity.

Best Regards,
David.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014

Commented:
You will not gain any hardware redundancy by having a failover cluster (SQL) on top of a failover cluster (Nutanix) but you will be able to shut down one VM of the SQL cluster to patch it and the other VM in the SQL cluster will start serving the databases. There is still a brief outage of about 30 seconds as SQL cluster failover means a database starting up and when a database starts up the transaction log is checked in case any transactions need rolling back/forward. You can minimise that time by checkpointing the transaction log more often.
David Pérez BonillaSystem Administrator

Author

Commented:
Currently I do not have any cluster mounted, I only have one virtual machine. My question is to see if you can advise me how to implement HA in a virtual environment, or something that looks like mounting two virtual machines.
Top Expert 2014

Commented:
You just create4 another VM, install MSCS clustering and SQL on it and create a SQL shared storage cluster on it.

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-2017#ConceptsAndTasks will explain SQL clustering. Note you need SQL enterprise for shared storage clustering but you can implement FCI with standard edition I think.
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Philip ElderTechnical Architect - HA/Compute/Storage

Commented:
Make sure the Nutanix performance is as expected.
Top Expert 2014

Commented:
Hmm, I don't see Nutanix as being that relevant, read it as "how to implement SQL cluster in any virtual environment".

You'd probably be more qualified at telling someone how to set up SQL cluster than me nowadays, whether virtual or not.
David Pérez BonillaSystem Administrator

Author

Commented:
Hi
I think I need a Nutanix specialist because this platform has a particularity about storage (The unique shared volumen is managemented by Nutanix through CVM virtual machines) that don't permit the creation of an tradicional MSCS. Are there any specialist about Nutanix in Experts-Exchange?
Top Expert 2014

Commented:
It supports MSCS style shared storage via something they call Acropolis Block Services, so maybe you need a Nutanix specialist to set it up for you although there are videos on youtibe.
https://next.nutanix.com/blog-40/shared-storage-for-windows-server-failover-clusters-on-nutanix-27364
System Administrator
Commented:
I'll contact with Nutanix's support.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial