Database Server Instance

Database Server Instance is used as a data store for the applications running under a tenant domain.<Add a better introduction>

This functionality is provided by the following feature in the WSO2 feature repository.

Name : RSS Manager Feature
Identifier : org.wso2.carbon.rssmanager.feature.group

This feature can be installed/uninstalled from a running Carbon instance using the instructions given in section Installing Features.

Follow the instructions below to create an instance.

1. First, specify your metadata repository in the $CARBON_HOME/repository/conf/etc/rss-config.xml file. For example, the following configuration uses a MySQL database by the name 'rssdb' as the metadata repository. This database is used to store all metadata related to each database accessed through this server instance, such as the users of a given database, time of creation, privilege templates of the users etc. 

<!-- RSS database used to store database servers, database instance information, users etc.. -->
<rss-mgt-repository>
    <datasource-config>
       <dataSourceClassName>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</dataSourceClassName>
       <dataSourceProps>
          <property name="url">jdbc:mysql://localhost:3306/rssdb</property>
          <property name="user">root</property>
          <property name="password">root</property>
       </dataSourceProps>
    </datasource-config>
</rss-mgt-repository>

2. The metadata repository should have a set of tables for metadata storage. Create these tables in the database mentioned in step 1 ('rssdb' in this example) by executing the script $CARBON_HOME/dbscripts/mysql/wso2_rss_mysql.sql on the database.

3. Log in to the management console and select "Database Server Instances" in the "Configure" menu.

4. The "Database Server Instances" window opens. Click the "Add Server Instance" link.

5. The "New Database Server Instance" window opens. Fill in the details accordingly.

For example,

6. Once the server instance is created, it will be listed on the window.

The server instance can be edited or deleted by clicking on the respective links associated with it. Using this database server instance, databases can be created in the Storage Server. For instructions, refer to section Relational Store Service.