I'm trying to get a greater understanding around load balancing for Windows IIS Web servers and MSSQL database servers.
In our environment I have 2x IIS web servers and 2x MSSQL database servers. I am planning to put a fault tolerant ACE appliance for the web servers which connect to a shared database.
MSSQL db is mirrored to another server so if one of the db servers is down it automatically fails over to the 2nd server.
To fully load balance and keep high availability would I have to implement an MSSQL cluster? If you load balance the web servers, what considerations must be made for the database servers?