Connect Data Visualization Tools

Install Grafana

If a Grafana instance is not already available, install the latest version of Grafana on the collecting Master Aggregator host.

Add the Grafana Monitoring Data Source

1. Connect to Grafana at http://<grafana-hostname>:3000 and log in using admin as both the username and password.

2. Add a monitoring MySQL data source with the following settings. The SingleStore data source port is 3306 by default.

   • Data source name: monitoring

   • Data source type: mysql

   • Data source host: <any-metrics-cluster-aggregator-host-or-a-load-balancer>

   • Data source port: 3306

   • Database name: metrics

   • User: Either root or the monitoring user specified earlier

   • Password: Either a secure password or blank if none

3. Alternatively, edit the sample.yaml file in the /etc/grafana/provisioning/datasources directory and add the following content, substituting the values in angle brackets with your SingleStore configuration.

   YAML

   Copy

   # # config file version
   
   apiVersion: 1
   
   datasources:
     - name: monitoring
       type: mysql
       url: <any-metrics-cluster-aggregator-host-or-a-load-balancer>:<port>
       database: metrics
       user: Either root or the monitoring user specified earlier
       secureJsonData:
           password: Either a secure-password or blank if none
       isDefault: true
       version: 1

4. Restart the Grafana server.

   Shell

   Copy

   sudo systemctl restart grafana-server

Connect the Grafana Dashboards

1. Download the cluster monitoring dashboards from SingleStore.

2. Import the dashboards into Grafana. To import a dashboard, click the + icon in the side menu, and then click Import. From here you can upload a dashboard JSON file, paste a Grafana.com dashboard URL, or paste dashboard JSON text directly into the text area.

3. Alternatively, edit the sample.yaml file in the /etc/grafana/provisioning/dashboards/ directory and add the following content.

   YAML

   Copy

   # # config file version
   apiVersion: 1
   
   providers:
   - name: 'default'
     orgId: 1
     folder: ''
     folderUid: ''
     type: file
     options:
       path: /var/lib/grafana/dashboards

   Next, copy the dashboard JSON files to the /var/lib/grafana/dashboards directory and ensure that the dashboards are owned by grafana:grafana (via chown grafana:grafana *).

4. Restart the Grafana server.

   Shell

   Copy

   sudo systemctl restart grafana-server

View Monitoring Data from Multiple Clusters (Optional)

You can view monitoring data from multiple source clusters in a single Grafana instance using the following steps:

1. Ensure that all cluster monitoring data is stored in a single database (on the metrics cluster). This will allow a single Grafana datasource to be configured.

2. On each source cluster, enable the exporter process.

3. On the metrics cluster, run sdb-admin start-monitoring for each source cluster and store the monitoring data in the same database.

4. Name each Source cluster to allow Grafana to identify the cluster. For more information, see Note.

5. Use the cluster tab in the Grafana UI to toggle between monitoring data from each source cluster.

   

Related Resources

• Additional information on Grafana