Creating Databases

In order to add a database user, you must first 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 cluster by the name of WSO2_RSS, which provides the storage provisioning infrastructure. However, individual tenants can also define their own. When databases are created, the 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 cluster.  

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.

Creating a database

Follow the steps below to create a database.

1. Log in to the management console and select Databases under  RSS Manager .
   
2. Select environment and 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.

Attaching database users

1. 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. 
2. After attached User to Database it will display like below. 
   

3. The purpose of each of the links associated with the database user is described below.
   

   Explore database:

   This option opens the Database Console window, which displays the database tables and allows you to execute SQL queries on the data. For example,

   Create datasources:

   Datasource is the connection set up to a database from the server. A datasource is a resource for the user, who can use it to expose data as services across different cluster nodes of his/her tenant space.

   Edit Privileges:

   The Edit link allows you to change user privileges.

   Detach User

   Detach link allows you to detach user from database.