SAP Sybase IQ provides partial load balancing through distributed query processing, or full load balancing through a network client (which requires third party software).
DQP (distributed query processing) occurs automatically for qualifying queries on multiplex servers that meet requirements.
Multiplex servers must have established MIPC (multiplex interprocess communication connections). The logical server of the current connection must have at least one other available member node. The shared temporary dbspace must have available writable files.
Using a network client to balance the query load among multiplex query servers requires an intermediate system that can dispatch the client connection to a machine in a pool.
To use this method, create a special ODBC DSN on the client system, 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.
Administration: Database > Appendix: Connection and Communication Parameters Reference > Network Communications Parameters > VerifyServerName Communication Parameter [Verify]
Administration: Multiplex > Distributed Query Processing