Configuring data source connection pooling for sharded installations
About this task
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 you have. For example, you could have a datasource named metadata_ds for the Metadata shard, a datasource named config_ds for the System Configuration shard, and so on.
- When multiple shards are defined, the shards must all use either datasource or direct JDBC calls: they cannot use both. Sterling Configure, Price, Quote
- Datasources for the Statistics, System Configuration, Transaction, and Master shard can be configured using either the System Management Administrator (SMA) or the manageDBpool API. To configure the datasource for a Metadata shard, you must use the manageDBpool API.
- At least three data sources must be specified for sharded database installations.
- If not set, the datasource name defaults to Pool ID.
To configure datasources for a sharded installation:
- Create the connection pools and datasources for each shard on your application server. See your application server documentation for specific configuration and operating instructions.
- Install the application.
- In a text editor, open (or create) the
customer_overrides.propertiesfile in the INSTALL\properties folder.
- In customer_overrides, add the line for your database from the following
- For Db2®, add
- For Oracle, add
datasourceNameis the logical name of the external datasource.
- For Db2®, add
- Save the customer_overrides file and run setupfiles.sh/cmd.
- 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.
- Build and deploy the EAR.
- Update the application server configuration to use
– where the value of
>is weblogic or websphere.
- Start the application server.