Versions Compared

Old Version 7

changes.mady.by.user Gomathy Kumarakuruparan

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. 

Tip
titleBefore you begin

Before you begin, note that creating separate databases as shown below is not actually required and can be skipped. Instead, you can point all the datasources given below to a single database. This will NOT make a difference in performance. To do this, see the steps given within the flow of the deployment pattern setup in theConfiguring the datasources/wiki/spaces/IS530/pages/25560356 sub topic.

However, if you do want to separate the data logically into separate databases, you can follow the steps given below.

...

Database NameDescriptionScript locationDatasource file to be modified
USERSTOREWSO2_USER_DBAuthorization manager configurations, internal permissions and roles.
<PRODUCT_HOME>/dbscripts/

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

Note

Note that the corresponding 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/user-mgt.xml as well.

IDENTITY_DBContains identity related data, for example, OAuth 2.0, SAML 2.0, etc.
<PRODUCT_HOME>/dbscripts/identity/

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

Note

Note that the The data source name mentioned in the master data source -datasources.xml file should be included in the identity.xml file in <PRODUCT_HOME>/repository/conf/identity/identity.xml 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.
<PRODUCT_HOME>/dbscripts/metrics/
<PRODUCT_HOME>/repository/conf/datasources/metrics-datasources.xml
BPS_DBThis is used for data pertaining to the workflow feature.
<PRODUCT_HOME>/dbscripts/
<PRODUCT_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.
<PRODUCT_HOME>/dbscripts/
<PRODUCT_HOME>/repository/conf/datasources/master-datasources.xml

To understand this concept further, see the following diagram.

Image RemovedImage Added

For more information on the concept of sharing governance and config registry databases across the cluster, see the topic on Sharing Databases in a Cluster in the WSO2 Product Administration Guide.

...