Monitor using NuoDB Insights

NuoDB Insights is an application monitoring tool for monitoring the health, resource consumption, workload, and performance of NuoDB databases. It provides real-time insights into database performance, errors and usage, helping users to identify and resolve problems, manage infrastructure, or review capacity planning. It uses open-source software such as Telegraf, InfluxDB, and Grafana, to collect raw metrics produced by the database or other sources, and condenses them into intuitive graphical display dashboards.

NuoDB Insights installs locally on the same nodes or hosts on which your database runs, and it supports all NuoDB database deployment environments. It can be installed before or after the database startup.

An application monitoring system consists of three core components:

Generating an information-dense graph of useful information from raw NuoDB statistics is done by stages of aggregation and filtering. NuoDB Collector, an automated, cloud-based data collection and analytics tool, utilizes the open-source collector, Telegraf. Telegraf performs some data processing to generate aggregate or average statistics before sending them to a time series database (such as InfluxDB or Prometheus) or to data aggregation services (such as Datadog or Sumo Logic).

Grafana, the visualization tool, performs further filtering and averaging to condense the information into a graph. The statistics generated by Telegraf under various labels are available in the InfluxDB database as selectable database columns for graph generation. The raw NuoDB statistics can also be generated to a local file using the nuocmd get stats command.

This section provides information to assist with interpreting the NuoDB metrics, describes important data points, and provides case studies on how to use NuoDB metrics using off-the-shelf software tooling, such as Grafana. NuoDB metrics can also be used with Sumo Logic and Prometheus.