If the directory/file paths specified in this guide do not exist in your WSO2 product, see Directory Structure of WSO2 Products to locate the paths applicable to your product.

Versions Compared

Key

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

...

The embedded H2 databases shipped with your product are suitable for development, testing, and some production environments. For most production environments, we recommend you to use an industry-standard RDBMS such as Oracle, PostgreSQL, MySQL, MS SQL, etc. Further, if you have features of WSO2 Identity Server or WSO2 Enterprise Store (ES) in your product, it is recommended to use separate RDBMSs for each, i.e., identity-related and storage-related data.  

To change the default database settings according to the above recommendation:

...

WSO2 products are shipped with scripts for creating the required tables in the Carbon database as well as other required databases. The scripts for creating tables for user management and registry data

...

are stored in the <PRODUCT_HOME>/dbscripts folder.

...

If

...

product-specific databases are required, and if features of WSO2 Identity Server or WSO2 Enterprise Store (ES) are used in the product,

...

there will be subfolders in the <PRODUCT_HOME>/dbscripts

...

 directory with separate scripts.

To change the default database settings according to the above recommendation, you simply have to set up new physical databases, point the product server to the new databases by updating the relevant configuration files in the product, and create the required tables using the scripts provided in the product pack. See the following sections for instructions:

...