You may continue to use the historical monitoring, SingleStore’s former monitoring solution, if you are currently unable to migrate to SingleStore’s native monitoring solution.
Please note that historical monitoring has been deprecated in favor of SingleStore’s native monitoring solution and may no longer function in future versions of SingleStore DB.
SingleStore’s native monitoring solution is designed to capture and reveal SingleStore DB cluster events over time. By analyzing this event data, you can identify trends and, if necessary, take action to remediate issues.
Throughout this guide, the cluster that is being monitored will be referred to as the “Source” cluster, and the cluster that stores the monitoring data will be referred to as the “Metrics” cluster. The databases that store monitoring data will be referred to as the
SingleStore Native Monitoring Solution High-Level Architecture
In SingleStore’s native monitoring solution, the Metrics cluster utilizes a SingleStore pipeline to pull the data from the exporter process on the Source cluster and stores it in a database named
metrics. Note that this
metrics database can either reside within the same cluster as the Source cluster, or within a dedicated cluster.
When these event data is then analyzed through the associated Grafana dashboards, trends can be identified and, if necessary, actions taken to remediate issues.
The provided Grafana dashboards include:
|Active session history||Aggregated resource consumption by activity and activity type|
|Activity history||Resource consumption by a specific activity over time|
|Detailed cluster view||A “birds-eye view” of a single SingleStore DB cluster|
|Information schema view||Provides a view into
|Memory usage||Granular breakdown of memory use for a host|
|SingleStore DB status and variables view||Collected status variables from each host in the cluster|
|Node breakout||System metrics from each host in the cluster|
|Node drilldown||System metrics from each host in the cluster, with the ability to focus on a specific metric subsystem|
These instructions have been developed for SingleStore DB clusters that have been installed and deployed via
.deb packages as a
If your cluster was deployed via tarball as a non-
sudo user, change to the directory (
cd) in which
singlestoredb-toolbox was untarred, and run all
sdb-admin commands as
Note that the Grafana instructions will require a user with
sudo access to install and configure the associated Grafana components.
- A SingleStore DB 7.3 or later cluster to monitor (the Source cluster).
- Optional: A separate SingleStore DB 7.3 or later cluster to collect monitoring data (the Metrics cluster).
- This can be the same as, or separate from, the Source cluster.
- If you opt to use a separate cluster, we recommend a cluster with two aggregator nodes and two leaf nodes, each with 2TB disks and with high availability (HA) enabled.
- Clusters are managed with SingleStore DB Toolbox 1.9.3 or later.
- A Grafana 6.0.0 or later instance that can access the Metrics cluster.
- SingleStore DB Toolbox is recommended for managing the clusters as automation during setup is provided through
sdb-admincommands. While monitoring can be enabled through a series of SQL commands, the preferred method is to use SingleStore DB Toolbox.
|Default Port||Used by||Invoked by|
||SingleStore DB Studio||User browser|