Defining a pool

NoteThe 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.