Monitoring ClustrixDB with Grafana

ClustrixDB GUI provides information about current cluster operations and has historical information for the past 7 days (based on statd retention). If additional monitoring or a longer time range for historical data is required, external monitoring tools such as Grafana can be used. By exporting and storing clusters' statistical data outside of ClustrixDB, longer term observations can be made without affecting production database performance.

To use Grafana with ClustrixDB, you'll need to export data into time series format that Grafana understands. We looked at a few options and found InfluxDB (a time-series database) to work best best. The downloadable package includes dull instructions to get Grafana with InfluxDB working with ClustrixDB and are summarized here:

1. Download Grafana (Clustrix has use versions 5.0.2 and 5.2.3)

1. https://grafana.com/grafana/download

2. Download InfluxDB (Clustrix has used versions 1.4.2, 1.5.0, and 1.6.2)

1. https://portal.influxdata.com/downloads

2. Install python libraries for InfluxDB

3. Configure a Grafana database user for ClustrixDB

1. https://portal.influxdata.com/downloads

4. Download and configure clustrix_statd_to_influx scripts

1. clustrix_grafana.tar.gz

The package includes the following dashboards:

• ClustrixDB_Cluster_Load.json

• ClustrixDB Monitoring for multiple clusters (based on cluster_id tag).

• Looks at common metrics associated with cluster load.

• ClustrixDB_Stats.json

• ClustrixDB StatD Stats. View for a single cluster (choose from dropdown based off of cluster_id tag)

• Live_Cluster_Dashboard.json

• Displays information about a cluster including: Hotness, QPC (Query Planner Cache), Replication and Rebalancer.

More information on StatD Metrics that can be added as graphs in Grafana can be found here: Statd Metrics Documentation