This documentation is for WSO2 Business Activity Monitor 2.2.0. View documentation for the latest release.

Unknown macro: {next_previous_link3}
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

In this section we shall see how to standalone WSO2 BAM to work in MT mode. To run BAM in MT mode, you need to have MySQL server. This is required to use it as Hive Meta Store. Therefore please install MySQL server if you haven't installed it in your machine.

This topic includes the following sections.

  1. Setting up RSS (Relational Storage service)

  2. Setting up Hive

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

  1. Download the RSS mysql script from here.

  2. Connect to the MySQL server form mysql client and execute the following queries.

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

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

<dataSourceProps>

...

<property name="user">root</property>

<property name="password">root</property>

</dataSourceProps>

property name “user” indicates the username of the MySQL server and “password” as name implies the password of the MYSQL server. Please edit the configuration accordingly for your MySQL set-up.

 

 

  • No labels