Creating Databases

Before adding a database user, you must create a database server instance. A database server instance acts as the container for the provisioned databases/database users.  By default, you have a database server instance cluster by the name WSO2_RSS providing the storage provisioning infrastructure but individual tenants can also define their own. Relational Storage Service of WSO2 Storage Server uses a round robin algorithm to select the next database server instance from the list pertaining to the WSO2_RSS database server instance cluster, 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.

1. Log in to the management console and select Databases under  RSS Manager .
   
2. Click the Add Database link and fill in the database information.  
3. The newly-created database appears in the Databases window. For example,
   
   Database URL allows you to point to the database from applications.
    
4. 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.