Working with Databases

The default databases that WSO2 products use to store registry, user management and product-specific data are the following H2 databases stored in the <PRODUCT_HOME>/repository/database directory:

• WSO2CARBON_DB.h2.db: used to store registry and user management data.
• RSS_DATABASE.ht.db: used to store RSS 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.  You can use the scripts provided with WSO2 products to install and configure several other types of relational databases in place of the default H2 database. However, note that in WSO2 Storage Server 1.1.0 version, you can only use H2, MySQL, MS SQL and PostgreSQL as the database type for the RSS specific databases.

The following topics explain how to change the default databases with a new database type:

• Setting up IBM DB2
• Setting up Derby
• Setting up H2 Database
• Setting up MS SQL
• Setting up MySQL
• Setting up MySQL Cluster
• Setting up OpenEdge
• Setting up Oracle
• Setting up Oracle RAC
• Setting up PostgreSQL