?
Solved

sql 2008 cluster vmware

Posted on 2009-05-12
6
Medium Priority
?
863 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 42

Accepted Solution

by:
paulsolov earned 1500 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
The Ideal Solution for Multi-Display Applications

Check out ATEN’s VS1912 12-Port DP Video Wall Media Player at InfoComm 2017. Kerri describes how easy it is to design creative video walls in asymmetric layouts and schedule detailed playlists ahead of time with its advanced scheduling feature.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

777 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