The order in which pools are defined is important; all
connections are routed to the first matching pool according to the attribute/value pairs established
using rp_pool_addattrib. See rp_pool_addattrib for more
information.
You define a pool using the OpenSwitch GUI configuration tool during or after installation, or by manually editing the OpenSwitch OpenSwitch configuration file. For example:
[POOL=POOL_A:MODE=CHAINED,CACHE=0] servers: SYB_SERV1 SYB_SERV2 SYB_SERV3 connections: type: client, site appname: isql username: ^test.*
In this example, POOL_A contains three servers: SYB_SERV1,
SYB_SERV2, and SYB_SERV3. It can be used by regular client
and site
handler connections
created by isql, or any user that starts with “test.”
If you do not supply any “connections” attributes when defining a pool, all connections are candidates for the pool.