Monitoring Cassandra Statistics Using BAM Toolbox

The Cassandra Statistics Monitoring toolbox in WSO2 BAM can be used for monitoring Cassandra clusters managed by WSO2 Storage Server. With this toolbox Cassandra statistics are displayed in the BAM dashboard. You have to install this toolbox in WSO2 BAM, and start the statistics publisher in Storage Server as explained below.

Setting up 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.

Enabling SS to publish Cassandra statistics to BAM

1. Stop the Storage Server if it is already started.

2. 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.)

3. Set <bam_secure_url> and <bam_receiver_url> as well.
4. Provide the cron expression in <cron_expression> to schedule the publisher.
5. Provide the BAM admin credentials.

6. Start the Storage Server.

   Port offset may need to be changed.

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