• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

IIS Resilience

We have a website hosted on a Windows Server 2008 R2 server. We want to make the website more resilient and wondered what options there are to achieve it. The website stores data on a SQL Server.

Is it a question of introducing a second server, creating an IIS 'farm', configuring SQL database mirroring for the database and then setting up WNLB?

Any guidance on what's involved and steps would be appreciated.
  • 2
1 Solution
Aaron TomoskyTechnology ConsultantCommented:
I feel that the easier way is to virtualize things. That protects from hardware failure.

Next is Internet connection failure. After that is application load issues. IMO app load issues are the only good reason to mess with clusters and load balancing.

What are you looking to protect against?
HypervizorAuthor Commented:
We have all of that resilience already.

It's resilience at the database and IIS front-end that's important.
Aaron TomoskyTechnology ConsultantCommented:
I decided a while ago that the complexity of this type of setup wasn't worth any resiliancy that might get added. Frequently the single point of failure just shifts to the load balancer and doesn't disappear. I'll let someone else help from here. Sorry.
there are a few options to add resilience

Load Balancing is the way to add resilience to the front end
Easiest way is via a Windows NLB, just setup a second server, install IIS, create the NLB and copy webconfig/content over to the second box

We often use Hardware load balancers - of which we have two and they are clustered and then pointed at IIS server that are not in a window NLB because the are load balancing primarily for performance rather than resilience and hardware LB's do that better

At the SQL layer the expensive option is to have a Cluster of SQL servers but this means additional licencing and shared storage - you can do this within most hypervisors now.

The second option is SQL mirroring but this is only contingency and not automated failover. Also SQL mirroring is being depreciated in newer version of SQL so if you upgrade in the future you might not be able to support this configuration
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now