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.
- 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.