Adding a database shard

You can add a new database shard.

About this task

To add a new database shard:

Procedure

In the DB Shard List panel, choose Create DB Shard. The Manage DB Shard Connection window displays.
Table 1. Manage DB shard connection window
Field Description
Manage DB Shard Connection
Shard Id Enter a unique identifier for the new database shard.
Save Click this button to save the details of the new database shard.
Reset Click this button to clear the database shard details.
Shard Parameter List
Name The name of the parameter associated with the given database shard. By default, the following parameters are added to the Shard Parameter List whenever you create a new database shard:
  • user—Enter the username to connect to the database shard.
  • password—Enter the password to connect to the database shard.
  • url—Enter the JDBC URL to connect to the database shard. The JDBC URL should be in this format: jdbc:{DBType}://{HostName}:{Port}/{schema}?{prop}
  • driver—Enter the JDBC driver name for the database shard.
  • dbvendor—Enter the database vendor name (for example, DB2 or Oracle) for the database shard.
Value The value of the parameter.
Add Param Click this button to add a new parameter to associate with the database shard.
Delete Param Click this button to delete the selected parameter from the Shard Parameter List.
Note: If you are using JDBC data sources, you must first create the JDBC data source and then create a shard with the same name.