Configuring data source connection pooling for sharded installations

In a sharded database installation, you can have five types of shards: Metadata, Statistics, System Configuration, Transaction, and Master. You must configure a datasource on your application server for each shard and colony that you have.

About this task

To configure datasources for a sharded installation:

Procedure

  1. Create the connection pools and datasources for each shard on your application server. See your application server documentation for specific configuration and operating instructions.
  2. Install the application.
  3. In a text editor, open (or create) the customer_overrides.properties file in the INSTALL\properties folder.
  4. In customer_overrides, add the line for your database from the following list:
    • For DB2®, add jdbcService.db2Pool.datasource=datasourceName
    • For Oracle, add jdbcService.oraclePool.datasource=datasourceName

      where datasourceName is the logical name of the external datasource.

  5. Save the customer_overrides file and run setupfiles.sh/cmd.
  6. Use the System Management Administrator (SMA) or manageDBpool API to add the datasource attribute to the selected pools.
    Note: You cannot add the datasource attribute for the metadata pool in the SMA. You must use the manageDBpool API instead.
  7. Build and deploy the EAR.
  8. Update the application server configuration to use -Dvendor=<appserver>

    – where the value of <appserver> is weblogic, jboss, or websphere.

  9. Start the application server.