[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Hosting a critical application in MS Windows

Posted on 2011-09-22
10
Medium Priority
?
285 Views
Last Modified: 2012-05-12
What software should I be using if I am trying to make sure a MS SQL application has high availability.  Is ESXi a suitable candidate to do that?  Would you elaborate the process to provide high availability for hosting a critical application?
0
Comment
Question by:tommym121
[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
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 572 total points
ID: 36580809
But you could also use Microsoft Clustering:-

How much downtime can you afford?

Possibly, VMware Technology may give your High Availability with the following:-

VMware vSphere Availability Features

VMware High Availability - Decrease Downtime and Reduce Risk
http://www.vmware.com/products/high-availability/overview.html

VMware High Availability (HA) Product Briefs
http://www.vmware.com/pdf/ha_datasheet.pdf
http://www.vmware.com/files/pdf/VMware-High-Availability-DS-EN.pdf

VMware Fault Tolerance - Deliver 24 X 7 Availability
http://www.vmware.com/products/fault-tolerance/overview.html

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

0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580863
What you need is a combination of things. VMware has "high availability", but that doesn't mean 'continuously' running. There is a brief downtime in the event a host the MS SQL VM is on goes down. What you need, in conjunction with VMware HA is FT, and/or Microsoft Clustering, both of which are compatible on VMware vSphere. @hanccocka has provided links that further explain the technologies. You will first need to determine SLAs and potential downtime you can have, then go with the solution that 1. fits in with your requirements, and 2. that fits into your budget.

Regards,
~coolsport00
0
 

Author Comment

by:tommym121
ID: 36580865
It is a CRM system that is strategic to the entire company operations. we would like to have it on 24 hours.  It can be down for 30 min to an hour max. Ideally no downtime.

Even when we expand our operations and need hardware upgrade, we like to be able switch over to new hardware without any downtime if possible.
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580882
Well, you can use HA & FT. If you decide to implement MSCS, here is the VMware guide for that:
http://www.vmware.com/pdf/vsphere4/r41/vsp_41_mscs.pdf
0
 
LVL 10

Expert Comment

by:ImaCircularSaw
ID: 36580888
SQL Mirror on a seperate site with a witness server locally that can manage the quorum(sp?) and fail-over automatically.
0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580891
Since you actually can have "some" downtime, costs may determine what amt of downtime you can have. HA alone doesn't cover you in the event of a lost VM server. That is only for a ESX/i host failure. And the VM that is on the failed host will then be restarted on remaining working hosts in the HA Cluster. So, what you need is FT and/or MSCS as well.
0
 
LVL 123

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 572 total points
ID: 36580957
VMware vSphere HA will do what you need to do.

But note, if a host server fails, you will experience a downtime of between 1-2mins whilst the server is restarted.

If you require better availability you will need to use FT, but, remember with FT, if the OS fails because of a fault, the FT VM will also fail.
0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580975
HA will provide 'uptime RTO', but doesn't provide recoverability in the event of a corrupted VM. FT and/or MSCS helps with that since there is more than 1 VM (server) clustered for high availability. Another option is to only use HA, and have a current backup of the VM using Veeam Backup & Replication, vRanger, or other 3rd party VM backup tool.

~coolsport00
0
 
LVL 5

Assisted Solution

by:Sebastian Talmon
Sebastian Talmon earned 284 total points
ID: 36582940

you could use mirroring/replication at the database-level - for an SQL Server, this is a very common scenario

maybe this document is a nice overview:
http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/replicationanddbm.docx
"SQL Server Replication: Providing High Availability using Database Mirroring"


As the replication takes place at the database level, an error in your Windows-Installation only affects the faulty machine and not the replication partner (or the SQL data)


(but using the HA or FT features in VMware is also a good idea - but I would prefer using the database-based replication / maybe together with VMware HA or FT)
0
 

Author Closing Comment

by:tommym121
ID: 36599290
Thanks for all the help. Very informative.  I will post more specific questions for your further assistance. Thank.s
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
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.

649 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