This documentation is for WSO2 Storage Server 1.0.3. View documentation for the latest release.
Creating Databases - Storage Server 1.0.3 - WSO2 Documentation
Skip to end of metadata
Go to start of metadata

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.
  • No labels