Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before Before adding a database user, you must create a database server instance. A database server instance acts as a data store for the applications running under a tenant domain.    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.RSS uses  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 .
    Image Modified
  2. Click the Add Database link and fill in the database information.  
  3. The newly-created database appears in the Databases window. For example,
    Image Modified
    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,
    Image Modified

    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.