SQL Server Failover Clustering Now Supported Under Virtualization for Production Use! (And A Final TechEd Update)
Clustering Virtual Machines in Production
Yesterday (5/19/09), the KB article which details the support policy for SQL Server failover clusters was officially updated to include support for clustering guests/Virtual Machines … including in production. So anyone who talked to me at TechEd last week, I was right until yesterday 🙂
Now a couple of points which the KB does not say currently (and I hope it will):
1. Don’t put both of your guests under the same hypervisor. It makes no sense, and creates a single point of failure for both of your cluster nodes. Nothing will stop you from doing this since both of your guests have no idea they are virtual machines.
2. Don’t mix physical and virtual/guest nodes. Choose a single strategy. There is nothing that will prevent you from mixing node types, but it really makes no sense to me.
Remember that each of the virtual/guest nodes running under the hypervisor of your choice must also meet the requirements for Windows failover clustering as if they were nodes on physical hardware. That means they must have redundant everything, which goes back to my point #1.
Other helpful links which apply:
KB943984 The Microsoft Support Policy for Windows Server 2008 Failover Clusters
KB309395 The Microsoft support policy for server clusters, the Hardware Compatibility List, and the Windows Server Catalog (pre-Windows Server 2008)
KB327518 The Microsoft SQL Server support policy for Microsoft Clustering
This is all good timing as I am finishing up my book. It does make things a bit difficult as some chapters are done, but this will make it in one way or another.
It was a good week. Thanks to everyone who came to the booth and to my session. I do look and incorporate feedback from the sessions I do, so anyone who posted evaluations, it’s helpful.
The Tech Talk I did (Clustering Microsoft SQL Server 2008 with Windows Server 2008) is also posted, so have a look. It has some demos and is about 20 minutes long give or take.
We got a requirement to create a SQL Failover Cluster where Node 1 would be Physical and Node 2 would be Virtual, Just wanted to know if it is possible?
In case this is possible, on what all platforms it will be supported by Microsoft apart from HyperV.
Thanks for your time,
Technially yes. As long as the WSFC passes validation, it’s a valid cluster if one node is physical and the other is virtual. The VM-based node must meet the standards for SQL Server and Windows virtualization set forth in the KBs above to be supported. I assume you’re going to be using iSCSI for storage since the same disks will need to be presented. Having said that, I can tell you that it is NOT a common architecture and not something I would really recommend unless you had a good reason. Just the potential perf differences alone in a failover scenario unless tested would be a big red flag.