The By 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
These embedded H2 databases are suitable for development, testing, and some production environments. For most production environments, however, we recommend you to are shipped with an embedded H2 database, which is used for storing user management and registry data.
The embedded H2 databases is only suitable for development and testing.
We recommend that you use an industry-standard RDBMS such as Oracle, PostgreSQL, MySQL, MS SQL, etc. In addition to the above databases, data that is specific to the WSO2 Identity Server resides 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 when you set up your production environment. You can change the default database configuration by simply setting up a new physical database and updating the configurations in the product server to connect to that database. The following section explains how to change the default databases: