Balancing Query Loads

Using the SAP Sybase IQ network client to balance the query load among multiplex query servers requires an intermediate system that is able to dispatch the client connection to a machine in a pool.

To use this method, on the client system you create a special ODBC DSN, with the IP address and port number of this intermediate load balancing system, a generic server name, and the VerifyServerName connection parameter set to NO. When a client connects using this DSN, the load balancer establishes the connection to the machine it determines is least loaded.

Note: Third-party software is required. VerifyServerName simply allows this method to work.

Addtional Information

Administration: Database > Appendix: Connection and Communication Parameters Reference > Network Communications Parameters > VerifyServerName Communication Parameter [Verify]