skip to main content
Using the ADO Client : ADO Connection Attributes : Load Balancing
 

Load Balancing

Attribute

LoadBalancing (LB)

Description

Determines whether the data provider uses client load balancing in its attempts to connect to a list of OpenAccess SDK servers (primary and alternate). The list of alternate servers is specified by the Alternate Servers attribute.

Valid values

0 | 1
If set to 1, client load balancing is used and the data provider attempts to connect to the list of OpenAccess SDK servers (primary and alternate servers) in random order.
If set to 0, client load balancing is not used and the driver connects to each server based on their sequential order (primary server first, then, alternate servers in the order they are specified).

Example

Host=server1;Port=19986;User ID=test;Password=secret;Alternate Servers=(Host=server2:Port=19986,Host=server3:Port=19986, Host=server4:Port=19996);Load Balancing=1;
The data provider randomly selects an OpenAccess SDK server from the list of primary and alternate servers and attempts to connect. If that connection attempt fails, the data provider again randomly selects an OpenAccess SDK server from this list until all of the servers have been tried or a connection is successfully established.
See Configuring Connection Failover for more information about connection failover.

Default

0

GUI Tab

Failover tab