Load Balancing Among Query Servers

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

For details on how to define an ODBC DSN for use in query server load balancing, see “VerifyServerName parameter [Verify]” in System Administration Guide: Volume 1 > Connection and Communication Parameters.

Related concepts
Managing Disk Space in Multiplex Databases
Restricting Database Access
Disk Caching