The login distribution mode lets you specify how connections are distributed in logical clusters with multiple instances. The login distribution mode does not affect single-instance logical clusters.
Values are:
affinity – specifies that the instance accepting a connection retains it as long as the target logical cluster is running on that instance.
If the load profile specifies a load threshold, and the load on the instance is too high, the workload manager redirects the connection to the least loaded instance in a logical cluster.
If the target logical cluster is not running on the instance, the workload manager redirects the connection to the least loaded instance in a logical cluster.
round-robin – specifies that incoming connections are distributed in a round-robin fashion among the instances hosting a logical cluster. For example, if “SalesLC” is running on “ase1” and “ase2”, the workload manager sends the first connection to “ase1,” the next to “ase2”, and so on. Load scores are not included in the algorithm.
The Cluster Edition does not perform load-based redirection
(affinity or round-robin) for connections with the sa_role.
However, sa_role connections are redirected if a route
directs them to a logical cluster running on another instance.
Sybase recommends affinity mode for transactional applications with short, frequent connections, and round-robin mode for read-mostly applications where an application server establishes a persistent pool of connections to Adaptive Server.
