VMWare HD vs Microsoft Clustering

Posted on 2010-03-30
Medium Priority
Last Modified: 2013-11-11
We currently have a non virtualized MSCS installation for our SQL server and web serives in an active/passive config. We are going to virtualize with VM Ware in the next couple of months and are wondering if VMWare HD is an acceptable replacement for a Microsoft cluster.

We have lalmost no tolerance for SQL downtime. Currently, when we do windows updates on the cluster node1, we are able to flip to node2 before rebooting node1. Down time is less than 30 seconds.

We are hoping to achieve something similar with VMWare HD. Can you setup VMWare HD as a 2 node solution?

Any thoughts on using MSCS on virtual machines?

Hoping we can get some comments from some that have been down this road.

Question by:NTS_Support
  • 3
LVL 40

Accepted Solution

coolsport00 earned 2000 total points
ID: 29119060
In reality "NTS_Support", due to your SLA for SQL, you should implement MSCS within your new VMware Infrastructure (see guide: http://www.vmware.com/pdf/vsphere4/r40/vsp_40_mscs.pdf). And, I'm assuming you're meaning HA, and not HD? :)  HA and DRS are really more geared towards keeping VMs up in the virtual infrastructure, in the event an ESX host goes down, but not really anything to do with the event of a VM going down. That's where MCSC comes into play.

To implement HA/DRS, you need to place at least 2 ESX hosts in a cluster and enable those features on the cluster.

Hope that helps.


Author Comment

ID: 29119853
Must have TVs on my mind today :) thanks for the advice. Any gotchas when installing MSCS in a virtual environment?
LVL 40

Expert Comment

ID: 29120394
Ha...yeah, may be. Who wants to be at work, anyway? :P

No real 'gotchas'; just follow the Guide there. It's pretty much the same as in the physical world. The Guide provides a few scenarios on how to configure it, as far as where to place the VMs. I think it's obvious that the VMs should be on separate hosts, but you can keep them on 1 host. If you're only going to have 1 host, then there's obviously no choice...but then you're looking at having a single-point of failure, at least ESX host-wise.

Hope that helps.

LVL 40

Expert Comment

ID: 29120875
Oh...and just keep in mind also that Sys Req's for SQL in a physical world still apply virtually (i.e. RAM). A single vCPU should be all that's needed CPU-wise, but if you run into performance issues (rare that you would), you can always increase the vCPU of the VM.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

August and September have been big months for VMware—from VMworld last month to our new Course of the Month in VMware Professional - Data Center Virtualization. We reached out to Andrew Hancock, resident VMware vExpert, to have a more in-depth discu…
The article describes step by step how to validate the SRA software certificate once installed on the Site Recovery Manager server. I hope it will be very useful for all administrators of virtualized environments.
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question