Do multi node clusters need to be virtualized ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hassan - 29 May 2006 08:54 GMT

I have heard that SQL servers could benefit if they are virtualized say
using VMWare or Virtual Server in production when setting up clusters on 4
way nodes such that in the event that 3 nodes fail, then the 4th node could
run those 3 virtual instances on the 4th node.

Is that worth thinking about ?

Reply to this Message

Mike Hodgson - 29 May 2006 09:22 GMT

No

--
*mike hodgson*
http://sqlnerd.blogspot.com

>I have heard that SQL servers could benefit if they are virtualized say
>using VMWare or Virtual Server in production when setting up clusters on 4
[quoted text clipped - 4 lines]
>
>

Reply to this Message

Michael Hotek - 30 May 2006 12:17 GMT

No, there is no benefit and there is no way I would configure a production
environment this way. In order to get either VMWare or Virtual Server up
and running, you need to install an OS on the host machine and then install
an OS within the VM. You now have a second OS running and consuming
hardware resources that is unnecessary. Then, you are not going to get any
failover whatsoever. The entire VM is running inside 1 or more files and
these files do not get copied anywhere or maintained up to date. So you are
introducing a lot more overhead as well as a configuration that has no
possibility of working the way you are wanting.

Signature

Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

>I have heard that SQL servers could benefit if they are virtualized say
>using VMWare or Virtual Server in production when setting up clusters on 4
>way nodes such that in the event that 3 nodes fail, then the 4th node could
>run those 3 virtual instances on the 4th node.
>
> Is that worth thinking about ?

Reply to this Message