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
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 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 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:
By default, WSO2 ML is shipped with a H2 database as the WSO2 ML Database which stores WSO2 ML-specific data. This WSO2 ML version supports only MySQL and H2 types to replace this WSO2 ML Database. For instructions on how to change the default H2 WSO2 ML Database, see the following: