Working with Databases
- Former user (Deleted)
WSO2 Enterprise Integration is shipped with an embedded H2 database for storing data. This default database is located in the /database directory of the EI profile.
Default databases
Explained below are the default databases that you will find in the database directory.
- Carbon database:
WSO2CARBON_DB.h2.dbis the main Carbon database of the profile. This stores registry and user management data by default. However, for production environments, we recommend separate RDBMSs to store identity-related and storage-related data. - Product-specific databases: In addition to the main Carbon database, the Business Process profile and Message Broker profile also has profile-specific databases.
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 industry-standard RDBMSs such as Oracle, PostgreSQL, MySQL, MS SQL, etc.
WSO2 products are shipped with scripts for creating the required tables in all the required databases: The scripts for creating tables for user management and registry data are stored in the /dbscripts directory of your EI profile. If profile-specific databases are required, there will be subfolders in the /dbscripts directory with separate scripts.
Changing the default Carbon database: You simply have to set up new physical databases, point the product server to the new databases by updating the relevant configuration files, and create the required tables using the scripts provided in the product pack. See the following topics for instructions:
Changing the default profile-specific databases:The process of setting up and configuring product-specific databases is similar to changing the default Carbon database. However, depending on the product, there may be additional configuration files to update.