Connect Data Visualization Tools
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
After configuring the metrics
database, you can connect data visualization tools such as Grafana to your cluster’s monitoring data.
Configure Grafana
-
Use the Deploy Grafana on Kubernetes instructions to deploy Grafana on the Kubernetes Metrics cluster.
-
Connect to the Grafana service via Web browser.
<Grafana-service>:<Grafana-port>
Use
kubectl get svc
to obtain the IP address and port of the Grafana service. -
Add a “monitoring” MySQL data source with the following settings.
-
Data source name:
monitoring
-
Data source type:
mysql
-
Data source host:
<name of the master pod>.
svc-<cluster name>. <namespace containing the Metrics cluster master pod>. svc. cluster. local -
Data source port:
3306
-
Database name:
metrics
-
User: A database user with read access to the metrics database
-
Password: This database user’s password
-
-
Download the cluster monitoring dashboards from SingleStore.
-
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.
Last modified: March 1, 2024