Load balancing MSSQL
NetScaler is the only certified load balancer that can load balance MySQL and MSSQL services. It can be quite complex, and there are many requirements that need to be in place in order to set up a proper load-balanced SQL server.
Let's go through how to set up a load-balanced Microsoft SQL Server running on 2008 R2. It is important to remember that using load balancing between the end clients and SQL Server requires that the databases on the SQL server are synchronized. This is to ensure that the content that the user is requesting is available on all the backend servers. Microsoft SQL Server supports different types of availability solutions, such as replication. You can read more about it at http://technet.microsoft.com/en-us/library/ms152565(v=sql.105).aspx ...
Get Implementing NetScaler VPX™ - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.