Database Server Instance

Database Server Instance is a RDBMS server instance which is used as a data store for the applications running under a tenant domain. This database server instance is used to store database servers, database instance information, users etc..

Follow the instructions below to create a database service instance.

1. First, configure Storage Server to connect to your metadata repository. This can be done in <PRODUCT_HOME>/repository/conf/etc/rss-config.xml file. The metadata repository stores all metadata related to each database accessed through this server instance, such as the users of a given database, time of creation, privilege templates of the users etc. 
   
   For example, the following sample configuration uses a MySQL database by the name rssdb as the metadata repository.
   

   <!-- RSS database used to store database servers, database instance information, users etc.. -->
   <rss-mgt-repository>
       <datasource-config>
          <dataSourceClassName>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</dataSourceClassName>
          <dataSourceProps>
             <property name="url">jdbc:mysql://localhost:3306/rssdb</property>
             <property name="user">root</property>
             <property name="password">root</property>
          </dataSourceProps>
       </datasource-config>
   </rss-mgt-repository>

   The database user should have super admin privileges.

   
   

2. The metadata repository should have a set of tables for metadata storage. Create these tables in the database mentioned in step 1 (rssdb in this example) by executing the script <PRODUCT_HOME>/dbscripts/mysql/wso2_rss_mysql.sql on the database.

3. Log in to the Storage Server management console and select Database Server Instances in the Configure menu.
   

4. Click the Add Server Instance link, fill in the details and click Save to complete. For example,
     
   

   Field	Description
   Database Server Instance Name	Name of the database instance.
   Server Category	RDS - Use this option if your relational database server setup is in the Amazon cloud.  Local - Use this option if your relational database setup is installed locally.
   Type	Only MySQL is supported in this release. Support for Oracle, DB2 and other popular relational database management systems will be added in future releases.
   JDBC URL
   Administrative username and password

   You can use this database server instance when creating databases to store and manage data related to applications running on a particular domain. See Creating Databases.