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 a database service instance.
First, configure Storage Server to connect to your metadata repository. This can be done in
<PRODUCT_HOME>/repository/conf/etc/rss-config.xmlfile. For example, the following sample configuration uses a MySQL database by the name
rssdbas 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.
The database user should have super admin privileges.
The metadata repository should have a set of tables for metadata storage. Create these tables in the database mentioned in step 1 (
rssdbin this example) by executing the script
<PRODUCT_HOME>/dbscripts/mysql/wso2_rss_mysql.sqlon the database.
Log in to the Storage Server management console and select Database Server Instances in the Configure menu.
Click the Add Server Instance link, fill in the details and click Save to complete. For example,
Field Description Database Server Instance Name Name of the database instance. Server Category
- RDS - Use this option if your relational database server setup is in the Amazon cloud.
- Local - Use this option if your relational database setup is installed locally.
Type Only MySQL is supported in this release. Support for Oracle, DB2 and other popular relational database management systems will be added in future releases. JDBC URL Administrative username and password
Click Save to complete. The new server instance appears as follows.
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.