Versions Compared

Key

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

NOTE TO WRITERS: Copy this version of the "Working with Databases" section to your docs, only if you have scripts in the product pack to create product-specific, storage or identity databases in addition to the main Carbon database.

The default databases that WSO2 products uses to store registry, user manager and product-specific data are the H2 databases in <PRODUCT_Home>/repository/database as follows:

  • WSO2CARBON_DB.h2.db: used to store registry and user manager dataexcerpt
  • hiddentrue

    NOTE TO WRITERS: Include following in the above list, only if you get scripts to create a product-specific DB in your product.

    <PRODUCT_NAME>_DB.h2.db: used to store product specific data 

These embedded H2 databases are suitable for development, testing, and some production environments. For most production environments, however, we recommend you to use an industry-standard RDBMS such as Oracle, PostgreSQL, MySQL, MS SQL, etc.

...

hiddentrue

...

.

In addition to the above databases, if the product uses features of WSO2 Identity Server or WSO2 Enterprise Store (ES), data which are specific to these will by default reside in the embedded Carbon database.  However, for production environments, we recommend you to use separate RDBMS databases to store identity-related and storage-related data.

You can use the scripts provided with WSO2 products to install and configure several other types of relational databases, including MySQL, IBM DB2, Oracle, and more. 

...