Solved

sql 2008 cluster vmware

Posted on 2009-05-12
6
833 Views
Last Modified: 2012-05-06
would like to build a sql 2008 cluster in vmware environment

1... need high availability and processing power, sql is verry high utillized and i mean verry high millons of transactions a day
2...need failover
3....budget is huge for this, so not a issue in that regard

need some advice\sujestions from the guru's out there
what do you gents sujest i go about this

0
Comment
Question by:dano992
  • 3
  • 2
6 Comments
 
LVL 42

Accepted Solution

by:
paulsolov earned 500 total points
ID: 24371248
For a high IOPS SQL system the current version of VMWAre may not be the best solution.  The new vSphere 4.0 will be much better for SQL but even then I would hesitate to put such a system into a virtual environment..and I try to virtualize anything I can normally.

If you would like to do this anyway I would wait for vSphere 4.0, ensure that you configure either FT (Fault Tolerence) or a Microsoft Cluster (create a rule that prevents both nodes to be on the same  host).  Since current VMWare HA is not insteneous failvoer the MS cluster should do the job in a virtual environment.

My $.02
0
 
LVL 19

Expert Comment

by:vmwarun - Arun
ID: 24372180
Do you have SAN in you environment ?
0
 

Author Comment

by:dano992
ID: 24374266
yes there is going to be a SAN
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:dano992
ID: 24380839
what would be the point of creating a multi-node sql cluster in VMware (HA)?
since vmware provides high availability.
can someone give some insite on how vmware (HA) and mulit-node sql cluster work together?
assuming the sql servers are virtual servers
0
 
LVL 42

Expert Comment

by:paulsolov
ID: 24381014
HA availability in current version of VMWare is not the same as a Microsoft Cluster.  If a virtual machine fails it will start on a different host in the cluster after it is done rebooting on it.  There is essentially some downtime, albeit not a lot but in a high transaction environment you would be done for a few minutes.

With a Microsoft Clustering you have realtime failover.  The advantage of MS Clustering in VMWare with HA is that if the SQL doesn't require all the resources on the hardware you can use the remaining resources for other VMs and you can change and upgrade virtual hardware on the fly (one node at a time)
0
 

Author Comment

by:dano992
ID: 24384344
could you have 2 3 nodes each sql cluster in vmware environment?
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now