If the directory/file paths specified in this guide do not exist in your WSO2 product, see Directory Structure of WSO2 Products to locate the paths applicable to your product.
Page Comparison - Working with Databases (v.3 vs v.4) - Administration Guide 4.4.x - WSO2 Documentation

Versions Compared

Key

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

All WSO2 products are shipped with default embedded H2 databases (embedded) for storing data. These default databases are stored in the <PRODUCT_Home>HOME>/repository/database directory.

Default databases

Explained below are the default databases that you will find in the database directory of your product.

  • Carbon database: WSO2CARBON_DB.h2.db is the main Carbon database in a WSO2 product. This stores registry and user manager 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, however, we recommend you to use an industry-standard RDBMS such as Oracle, PostgreSQL, MySQL, MS SQL, etc.

...

hiddentrue

NOTE TO WRITERS: Include  following in the  above list, only if you get scripts to create DBs for identity and storage in your product.

...

Further, if you have features of WSO2 Identity Server or WSO2 Enterprise Store (ES)

...

 in your product, it is recommended to use a separate RDBMS for 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. 

Excerpt
hiddentrue

The following sections explain how to change the default databases:

NOTE TO WRITERS: Add the "Children Display" macro here.

See the following sections for more details:

...