Solved

"Host" clustering rather than "appliation" clustering vitual servers in VMWare environment.

Posted on 2014-09-24
8
169 Views
Last Modified: 2014-09-26
Greetings all,

I need to cluster two virtual Windows 2008 R2 servers with SQL installed that are on separate ESX hosts.  In the documentation I have found I am only seeing how to cluster SQL.  What I would like to do is cluster two complete servers.  Does this make sense?  Two identical servers clustered - not two applications (SQL) on the servers.

Anyone seen this before?  If so - can you point me in the right direction for some good documentation.  I'm having trouble coming up with just the right combination of words to get good Google search results.
0
Comment
Question by:yccdadmins
  • 3
  • 3
  • 2
8 Comments
 
LVL 61

Expert Comment

by:gheist
ID: 40342343
That is what vmware FT does, but it is slow in general.
SQL clustering is native to SQL server, and clustering rest of windows offers no added value.
0
 

Author Comment

by:yccdadmins
ID: 40342363
VM "FT"?
0
 
LVL 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 40342381
FT = VMware Fault Tolerence

What are you trying to do, because VMware FT, both Servers are Locked Stepped, if the first server breaks or has a BSOD, so will the second server.

Because they are identical;...

Are you trying to HA the server or the service or application ?

load balance, available, or resilient ?

have you seen Double Take ?

VMware Fault Tolerance Product Brief

http://www.vmware.com/files/pdf/VMware-Fault-Tolerance-FT-DS-EN.pdf

VMware vSphere Availability Guide ESX 4.1vSphere
http://www.vmware.com/pdf/vsphere4/r41/vsp_41_availability.pdf

But it has many caveats!
0
 

Author Comment

by:yccdadmins
ID: 40345123
Hello and thank you for all of the information.

I am trying to figure out the best way to provide failover without both servers and their SQL having to point back to a single storage array.  The common way to set this up is to set up two servers, cluster SQlL and have them both pointing back to a shared array where the data resides.  There is always replication between arra

The best way I can describe what I'm looking for is machine (or VM) failover rather than application - everything is written/changed on both servers (not just changes to SQL) and if one server fails it doesn't matter.  Basically, clustered servers rather than a clustered service.
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 118
ID: 40345162
This can be achieved with VMware FT with lots of caveats or Double Take which works with physical or virtual.
0
 
LVL 61

Expert Comment

by:gheist
ID: 40345462
You must patch windows monthly. None of FT solutions covers that downtime while SQL server cluster goes through just fine...
0
 

Author Comment

by:yccdadmins
ID: 40346139
I think the links you have provided have me set.  Thanks for saving me some search time for sure!
0
 
LVL 118
ID: 40346196
no problems....
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
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…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

914 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

17 Experts available now in Live!

Get 1:1 Help Now