Sql-server – SQL Server 2008 Cluster Across Two VMWARE Hosts

clusteringsql-server-2008

Vmware ESX 5 from a Vcenter

Two Windows 2008 R2 VMs

I am attempting to setup Failover Clustering using two VMs from within a Vcenter. Each virtual machine resides on a seperate physical host following this schema:

vmware_mscs

The instructions for adding a disk to the first machine go as follows:

  1. In the vSphere Client inventory, select the newly created virtual machine and select Edit Settings. The Virtual Machine Properties dialog box appears.
  2. Click Add, select Hard Disk, and click Next.
  3. Select Raw Device Mappings and click Next.
  4. Select an unformatted LUN and click Next.
  5. Select a datastore and click Next.

This datastore must be on a SAN because you need a single shared RDM file for each shared LUN on the SAN.

My question is as follows. When two Windows 2008R2 servers are hosted on two different physical VMWare servers within a VCenter, is it absolutely necessary to have an unformatted LUN for the shared storage of a Windows Failover Cluster?

If not, what would be an alternative?

iSCSI is not an option.
Both servers must be installed on two seperate physical hosts.

Here is a link to the documentation.

http://www.vmware.com/pdf/vsphere4/r41/vsp_41_mscs.pdf

Goto page 21.

Best Answer

As said in the comments, I can (almost) conclusively confirm that you will require shared raw LUNs with RDM, when you want to cluster 2 x virtual (vmware) SQL Server nodes that are on different hosts, instead of using VMFS.

The VMWare documentation also explicitly mentions the use of unformatted LUNs

*I guess (and I have never done touched on it before) the only possible exception that spring to mind may be in you use SQL Server 2012 AlwaysOn on SSDs. Oh, and possibly iSCSI, which is as you said, not an option. *

Related Question