I am looking into SharePoint but have some problems to understand how to plan the servers in order to get good availability at the same time as using load balancing. I have basically planned for the most basic setup which is
Two Front end servers
One Application server
Two SQL servers
I want two front servers in order to get good up time so if one server craches the system should still work, the same applies for the SQL servers. I will have some sites that always needs to be up while some others are less important and can be down for a while. Therefor I want to have load balancing between the servers. If a server crashes I can afford to close some sites and that the other sites are a slower.
The problem is that I can understand how the load balancing is working. So I have looked into NLB in windows 2008. Lets say that I install that on my front end servers. Would that mean that my system will work even if one of my two front end server crashes?
This is how I understand it is working, I have a domain called Foo. The users tries to access Foo which routes to front end server 1, The NLB will then dependent on the load route the user to front end server 2 or keep the user at front end server 1.
The thing I can't understand is this, the DNS needs to route the user to a server that then can route the user dependent on the load. But What if front end server 1 crashes that are running the NLB. Will the user then still be able to access Foo thorugh front end server 2?
The same question applies to the databases? How does that work? Will I need to purchase some extra hardware or will SharePoint or SQL take care of both availability and load balancing?