JDBC MultiPools

 

The following procedures describe how to use the Administration Console to set the attributes for configuring and managing MultiPools. Read about configuring and managing MultiPools in Managing JDBC Connectivity.

 

---

Configure a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in your domain.

3. Click the Configure a New JDBC MultiPool text link. A dialog displays in the right pane showing the tabs associated with configuring a new MultiPool.

4. On the General tab do the following:

   • Enter a value in the Name attribute field, then

   • Select either Load Balancing or High Availability from the drop-down list to chose how you want the connection pools selected from the MultiPool.

5. Click Create to create a MultiPool instance with the name you specified in the Name field. The new instance is added under the MultiPools node in the left pane.

6. On the Pools tab do the following:

   1. Select the connection pools from the Pool List in the Available column that you want to assign to the MultiPool.

   2. Click the mover control to move the connection pools you selected to the Chosen column.

7. Click Apply to save your assignments.

For what's next in the configuration process, see the Configuration Procedures in Managing JDBC Connectivity.

 

---

Clone a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in your domain.

3. Click the Clone icon in the row of the MultiPool you want to clone. A dialog displays in the right pane showing the tabs associated with cloning a MultiPool.

4. Enter a value in the Name attribute field. Click either the Load Balancing or the High Availability checkbox to to chose how you want the connection pools selected from the MultiPool.

5. Click Create to create a MultiPool instance with the name you specified in the Name field. The new instance is added under the MultiPools node in the left pane.

 

---

Monitor All Instances of a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in the domain.

3. Click the Monitor All Instances icon in the row of the MultiPool you want to monitor. A dialog displays in the right pane showing all instances of the MultiPool deployed across the connection-pool domain.

 

---

Assign a JDBC MultiPool to One or More Servers or Clusters

1. Click the instance node in the left pane under MultiPools for the MultiPool you want to assign. A dialog displays in the right pane showing the tabs associated with this instance.

2. Click the Targets tab.

3. Complete the following steps for the Servers or Clusters tab:

   1. Select the server in the Available column to which you want to assign the MultiPool.

   2. Click the mover control to move the target you selected to the Chosen column.

   3. Click Apply to save your assignments.

Configuration

Attribute	Description	Range of Values	Default Value
Name	This attribute sets the name of the JDBC Multi pool.	The name can be up to 256 alphanumeric characters, but may not contain commas or spaces.	Null
Algorithm Type	Chose how you want the connection pools selected from the MultiPool: Load Balancing. Distributes the connection requests evenly (round-robin from the next available pool) to its member pools. High Availability. Distributes the connection requests sequentially from an ordered list. That is, every time the Multipool is asked for a connection, it tries to get a connection from the first pool in its list. If unable to get a valid connection, it tries the next pool in its list. Process is repeated until a valid connection is obtained, or until the end of the list is reached, in which case an exception is thrown. Note that the Multipool will only move to the next pool in the list when there is a real problem with the pool, for example the database is down or the pool disabled. For the cases where all connections are busy, the Multipool behaves as a single pool and an exception is thrown.	Boolean True = selected False = not selected Boolean True = selected False = not selected	Not Selected Selected

Pools

Attribute	Description	Range of Values	Default Value
Pool List	This attribute retrieves the list of connection pools in the multi pool	List

Targets

Attribute	Description	Range of Values	Default Value
Targets Servers

Notes

Attribute	Description	Range of Values	Default Value
Notes	This attribute provides a space for user supplied information.	The value must be an alphanumeric string.	Null

Read about configuring and managing MultiPools in Managing JDBC Connectivity.