Microsoft SQL Cluster on Nutanix HCI environment
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.
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.
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.
ASKER
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.
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.
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.
Make sure the Nutanix performance is as expected.
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.
You'd probably be more qualified at telling someone how to set up SQL cluster than me nowadays, whether virtual or not.
ASKER
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?
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?
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
https://next.nutanix.com/blog-40/shared-storage-for-windows-server-failover-clusters-on-nutanix-27364
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.