Setting up BAM server in Multi Tenant mode

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.

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.

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>

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.

Setting up Hive

In this section you have to point the hive meta data store URL in the hive-site.xml. Please follow the below instructions for that.

Go to $BAM_HOME/repository/conf/advanced/hive-site.xml if you are using unix based machine. If you are using windows machine, please edit the hive-site-win.xml.
Please edit the following properties.

<property> 
  <name>javax.jdo.option.ConnectionURL</name> 
  <value>jdbc:mysql://localhost:3306/metastore_db</value>
  <description>JDBC connect string for a JDBC metastore</description> 
</property> 

<property> 
  <name>javax.jdo.option.ConnectionDriverName</name> 
  <value>com.mysql.jdbc.Driver</value>
  <description>Driver class name for a JDBC metastore</description> 
</property>

............

<property> 
  <name>javax.jdo.option.ConnectionUserName</name> 
  <value>root</value> 
  <description>username to use against metastore database</description> 
</property> 

<property> 
  <name>javax.jdo.option.ConnectionPassword</name> 
  <value>root</value> 
  <description>password to use against metastore database</description> 
</property>