O'Reilly logo

Implementing NetScaler VPX™ - Second Edition by Marius Sandbu

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required