Solved

IIS Failover Senerio.

Posted on 2007-12-05
8
1,434 Views
Last Modified: 2012-05-05
I administer some web application that require extremely high availability.  My organization has two data centers, both have independent subnets/vlans.  I would like to mirror my DB server from data center #1 to a DB server in data center #2 and then do the same with my web servers.

i know i can use the built-in mirroring functionality of SQL Server, but would be the best thing to use for IIS?  Can i use NLB even though they are on two different networks?  If I can use NLB, then can it be configured to only allow connections to the webserver in data center #2 if the web server in data center #1 is unavailable or will it be forced to do true load balancing?

I do not really need to load balance since the web apps I server aren't high traffic apps, they just require extremely high availability.

Thank you for your input!
0
Comment
Question by:jasco4617
8 Comments
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 250 total points
ID: 20415361
Microsoft's built in load balancing should be on the same subnet (network).  You could use a hardware NLB solution which might be able to span subnets.

Mirroring may not work the way you expect.  One copy is live, the other is not.
http://aspalliance.com/1388_Database_Mirroring_in_Microsoft_SQL_Server_2005.all
0
 
LVL 8

Expert Comment

by:digital_thoughts
ID: 20415394
I think as long as you can access the IIS Server in data center #2 from data center #1 and vice versa, then you should be able to use NLB without an issue.

Do the users access the web application via direct server url? i.e. http://servername/appname/ ? Or some other means? You might be able to use DNS to give you the failover you need, where it will attempt access on the primary server first, but if unavailable, it will try the second.
0
 
LVL 4

Author Comment

by:jasco4617
ID: 20415395
i thought about doing something like, the only problem is that if i have the hardware NLB in datacenter #1 and data center #1 goes down, then the NLB cluster it creates will go down.  If i am wrong on how that would act, then let me know.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 4

Author Comment

by:jasco4617
ID: 20415430
Digital...

the way it is currently set is that there is a single IP address that has a hostname of say hello.world.com.  that IP address is added to the IP address list for my NIC and then the IIS website is assigned that IP.

I am by far not a networking guy and I was unaware that DNS could do fail over.

Thanks.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 20417528
digital_thoughts: DNS cannot do the load balancing.  It will only support DNS round robin but that is not reliable because if a server dies, DNS round robin will continue to send requests to the dead server.  Also, NLB does not work properly in two sites.  All servers must be in the same subnet.  I know from experience.

In regard to the hardware NLB you actually use redundant hardware at one site.  If one goes down, the other takes over.

By the way, if you are really paranoid about losing a data center then you need 4 NLB devices or two NLB arrays.  One at each site.
0
 
LVL 4

Author Comment

by:jasco4617
ID: 20422751
tedbill...

in response to your first post:  

What I had in mind if MS's NLB could work would be to have a the NLB set so that the web server in the 2nd data center would only be used by setting the Load Weight to 100 on the appropriate web server.  Then configure the web app in the 2nd data center to point to the mirrored instance of the database.  That way if data center #1 goes down the mirrored DB will become the principle server and the web server in data center #2 would start receiving traffic.  

However, if NLB will not work across subnets and i can't get my organization to create a vlan that spans the two locations then that idea is useless.

Also, the web and db are located on the same server so if one goes down both do.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 20424407
Well I have managed to get NLB working across a subnets but it didn't work well (it was over a year ago so I can't remember why I decided not to use it)
0
 

Expert Comment

by:dtripp33
ID: 20508570
I have looked into an application that might help. Simple Failover http://www.simplefailover.com/ This will monitor your website(s) on many different levels and adjust where the DNS points to based on the results. It is highly customizable and fairly low cost.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

786 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