Monitor Cassandra Statistics Using BAM Toolbox

This toolbox is a tool used to monitor statistics of a Cassandra cluster managed by WSO2 Storage Server. You have to install this toolbox in WSO2 BAM, and start statistics publisher in Storage Server. Then statistics can be viewed graphically in the BAM dashboard. Use the following instructions to setup the BAM Toolbox.

To setup the BAM Toolbox:

1. Stop the BAM server if it is already started.
2. Open master-datasources.xml in BAM_HOME/repository/conf/datasources, and add the WSO2SS_STAT_DATASOURCE data source. This is where the summarized data is stored.

3. Add the following XML element to the <datasources> section and make the necessary changes.

   An H2 database is used to store summarized data.

   <datasource>
              <name>WSO2SS_STAT_DATASOURCE</name>
              <description>The datasource used for ss stat analyzer</description>
              <definition type="RDBMS">
                  <configuration>
   					<url>jdbc:h2:repository/database/samples/WSO2SS_STAT_DB;AUTO_SERVER=TRUE</url>
                      	<username>wso2carbon</username>
                      	<password>wso2carbon</password>
                      	<driverClassName>org.h2.Driver</driverClassName>
                      	<maxActive>50</maxActive>
                      	<maxWait>60000</maxWait>
                      	<testOnBorrow>true</testOnBorrow>
                      	<validationQuery>SELECT 1</validationQuery>
                      	<validationInterval>30000</validationInterval>
                  </configuration>
              </definition>
   </datasource>

4. Start the BAM server.
5. Stop the Storage Server if it is already started.

6. To start Cassandra statistics publisher, open cluster-monitor-config.xml in SS_HOME/repository/conf/etc, and set the <monitoring_enable> setting to true (default is set to false).

   Please note that this should be enabled in only one SS node because SS publishes data of the whole Cassandra cluster. (If you enable publishers in multiple SS nodes, duplicate data will be published to BAM.)

7. Set <bam_secure_url> and <bam_receiver_url> as well.
8. Provide the cron expression in <cron_expression> to schedule the publisher.
9. Provide the BAM admin credentials.

10. Start the Storage Server.

    Port offset may need to be changed.

11. In BAM, login to the dashboard in the left panel. Now the published and summarized Cassandra statistics are shown in the dashboard.