You can define multiple pools that all match connection properties of a single incoming client connection. For example:
[POOL=POOL_A:MODE=CHAINED] servers: ... connections: appname: isql [POOL=POOL_B:MODE=CHAINED] servers: ... connections: username: test%
If the user “test” attempts to connect to OpenSwitch using isql, he or she is a candidate for both POOL_A and POOL_B. In this case, OpenSwitch uses the first matching pool as defined in the configuration file or as listed in rp_pool_help.
