Versions Compared

Old Version 8

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

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

WSO2_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_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

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_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
CONSENT_MGTThis is used for data pertaining to user consents.<IS_HOME>/dbscripts/consent

<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 consent-mgt-config.xml file in <PRODUCT_HOME>/repository/conf/ as well.

...