Page Comparison

This section guides you through the logical separation of data that you can do when clustering WSO2 Identity Server.

...

Database Name Description Script location Datasource file to be modified

USERSTOREWSO2_USER_DB

Authorization manager configurations, internal permissions and roles.

<IS_HOME>/dbscripts/

<IS_HOME>/repository/conf/datasources/master-datasources.xml

Note
The data source name mentioned in the `master-datasources.xml` file should be included in the `user-mgt.xml` file in `<PRODUCT_HOME>/repository/conf/` as well.

IDENTITY_DB

Contains identity related data, for example, OAuth 2.0, SAML 2.0, etc.

<IS_HOME>/dbscripts/identity/

<IS_HOME>/repository/conf/datasources/master-datasources.xml

Note
The data source name mentioned in the `master-datasources.xml` file should be included in the `identity.xml` file in `<PRODUCT_HOME>/repository/conf/identity` as well.

METRICS_DB

Metrics Database is used to store the runtime metrics data reported by the Metrics JDBC Reporter periodically. There are 5 tables to store metrics data for each metric type. The metric types are Counter, Meter, Gauge, Histogram, and Timer.

<IS_HOME>/dbscripts/metrics/

<IS_HOME>/repository/conf/datasources/metrics-datasources.xml

BPS_DB

This is used to create, drop, and truncate data pertaining to the workflow feature.

To create workflow related tables and indexes, use the scripts in the <IS_HOME>/dbscripts/bps/bpel/create directory.
To delete workflow related tables, use the scripts in the <IS_HOME>/dbscripts/bps/bpel/drop directory.
To remove workflow related data from tables, use the scripts in the <IS_HOME>/dbscripts/bps/bpel/truncate directory.

<IS_HOME>/repository/conf/datasources/bps-datasources.xml

REGISTRY_DB

Shared database for config and governance registry mounts in the product's nodes. This includes data on tenants and keystores.

<IS_HOME>/dbscripts/

<IS_HOME>/repository/conf/datasources/master-datasources.xml

...

Versions Compared

Old Version 7

New Version Current

Key