Server load balancing and SQL
Posted on 2009-05-08
I am looking for some advice on technology.
Here is my issue: I have 3 Web servers that hosting 3 Web applications, all applications pointing to the same database server. I would like to create some load balancing for the SQL 2005 server and the Web applications servers, my vision is to be able to point users to another server if the current server have to much load on it, for example: assuming I have 100,000 customers using server 1, I would like to find a technology that will redirect users to server 2 if server 1 have 50,000 users. Now the tricky part is that server 2 will also point to database server 2, however from my knowledge I know you cannot have 2 SQL servers connected to the same database on the storage.
Is there any technology out there that can help with this? how enterprises that have millions of customers handle the load of the web servers and database server?