Page Comparison

...

Changing the identity/

...

BPS/social databases

The topics above show how to change the WSO2_CARBON_DB, which is used to store registry and user manager information. If you set up a separate database for identity, storage,   WSO2 Business Process Server (BPS), or social related data, the instructions are the same. In summary: 

1. Add a new datasource configuration to the following files for each of the separate databases that you need to create.

   For the identity database	Add it to the <PRODUCT_HOME>/repository/conf/datasources/master-datasources.xml file.
   For the storage databaseAdd it to the  <PRODUCT_HOME>/repository/conf/datasources/master-datasources.xml file. For the BPS database	Add it to the <PRODUCT_HOME>/repository/conf/datasources/bps-datasources.xml file.
   For the social database	Add it to the <PRODUCT_HOME>/repository/conf/datasources/social-datasources.xml file.

2. Create the database tables using the following scripts: 

   For the identity database	Use  <PRODUCT_HOME>/dbscripts/identity/mysql.sql	For the storage database	Use  <PRODUCT_HOME>/dbscripts/storage/mysql/resource.sql
   For the BPS database	Use  <PRODUCT_HOME>/dbscripts/bps/bpel/create/mysql.sql
   For the social database	Use  <PRODUCT_HOME>/dbscripts/social/mysql.sql

3. Update the following configurations, with the defined datasource name of the corresponding database configuration you added to the <PRODUCT_HOME>/repository/conf/datasources/master-datasources.xml file.

   • If you are setting up a separate database to store identity related data, update the following configurations in the <PRODUCT_HOME>/repository/conf/identity.xml file.

     Code Block
     language xml
     <JDBCPersistenceManager> <DataSource> <!-- Include a data source name (jndiConfigName) from the set of datasources defined in master-datasources.xml --> <Name>jdbc/WSO2CarbonDB</Name> </DataSource> </JDBCPersistenceManager>