Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Database NameDescriptionScript locationDatasource file to be modified
USERSTORE_DBAuthorization manager configurations, internal permissions and roles.
<IS_HOME>/dbscripts/
<IS_HOME>/repository/conf/datasources/master-datasources.xml
IDENTITY_DBContains identity related data, for example, OAuth 2.0, SAML 2.0, etc.
<IS_HOME>/dbscripts/identity/
<IS_HOME>/repository/conf/datasources/master-datasources.xml
METRICS_DBMetrics 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_DBThis 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_DBShared 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

...