All WSO2 products are shipped with embedded H2 databases for storing data. These default databases are stored in the
Explained below are the default databases that you will find in the
database directory of your product.
- Carbon database:
WSO2CARBON_DB.h2.dbis the main Carbon database in a WSO2 product. This stores registry and user management data by default. In addition, if the product uses features of WSO2 Identity Server or WSO2 Enterprise Store (ES), data which are specific to those 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.
- Product-specific databases: In addition to the main Carbon database, your product may have other databases for storing product specific data.
Changing the default databases
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, simply set up new physical databases and create the required tables using the scripts provided in the product pack.
- The scripts for creating tables for user management and registry data will be stored in the
- If the product uses features of WSO2 Identity Server or WSO2 Enterprise Store (ES), you will find subfolders such as
<PRODUCT_HOME>/dbscripts/identitywith separate scripts.
See the following sections for instructions: