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 data<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.
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.
The following sections explain how to change the default databases: