The first step of consuming WSO2 RSS is to create a database for your application in the RSS storage space. RSS provides facility to create databases, tables and store and manage data related to applications running on a particular domain through the management console.
Database server instances
Before adding a database, you must create a database server instance. A database server instance acts as a data store for the applications running under a tenant domain. By default, you have a server instance by the name WSO2 RSS but individual tenants can also define their own. RSS uses round robin algorithm to select the next database server instance from the list when creating databases.
To create a server instance using the management console UI, see Database Server Instance. You can also create server instances directly in <PRODUCT_HOME>/repository/conf/etc/rss-config.xml file too. For instructions, see Changing the Default RSS Configuration.
Follow the steps below to create a database.
- Log in to the management console and select Databases under RSS Manager .
- Click the Add Database link and fill in the database information.
- The newly-created database appears in the Databases window. For example,
Database URL allows you to point to the database from applications.
- Click the Manage link to attach a user and a privilege template to the newly-created database. For example,
Available Database User: This drop-down list is populated by the users created for the RDBMS. Also see Creating Database Users.
Database Privileges Template: This drop-down list is populated by the privilege templates created in RSS. It sets the appropriate permission scheme for the database user selected above. Also see Creating Privilege Templates.