...
Setting up RSS (Relational Storage service)
Setting up Hive
Setting up Other BAM configurations
...
Setting up RSS (Relational Storage service)
RSS is required to obtain the tenant separated data storage which is required to store hive meta data. Therefore first of all we need to setup the RSS to work with MySQL server. Please follow the below steps in-order to configure the RSS.
Download the RSS mysql script from here.
Connect to the MySQL server form mysql client and execute the following queries.
| No Format |
|---|
create database rssdb;
use rssdb;
source C:\scripts\wso2_rss_mysql.sql; |
3. Go to $BAM_HOME/repository/conf/etc/rss-config.xml and edit as below
| No Format |
|---|
<wso2-rss>
<rss-type>MYSQL</rss-type>
<!-- 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>
<!-- WSO2 RSS instances are predefined constant server instances
to be used by users, the other type is User Defined RSS instances,
which are defined by individual tenants -->
<system-rss-instances>
<system-rss-instance>
<name>WSO2RSS1</name>
<dbms-type>MYSQL</dbms-type>
<server-category>LOCAL</server-category>
<admin-datasource-config>
<dataSourceClassName>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</dataSourceClassName>
<dataSourceProps>
<property name="url">jdbc:mysql://localhost:3306</property>
<property name="user">root</property>
<property name="password">root</property>
</dataSourceProps>
</admin-datasource-config>
</system-rss-instance>
</system-rss-instances>
</wso2-rss>
|