Agent Check: SingleStore

Overview

This check monitors SingleStore through the Datadog Agent. SingleStore offers transactional and analytical processing of stored data. Enable the Datadog-SingleStoreDB integration to:

• Understand the health of clusters and nodes through metrics and events.
• Address drops in storage capacity.
• Improve resource utilization efficiency.

Setup

Follow the instructions below to install and configure this check for an Agent running on a host. For containerized environments, see the Autodiscovery Integration Templates for guidance on applying these instructions.

Installation

The SingleStore check is included in the Datadog Agent package. No additional installation is needed on your server.

Configuration

Host

Metric collection

1. Edit the singlestore.d/conf.yaml file, in the conf.d/ folder at the root of your Agent's configuration directory to start collecting your SingleStore performance data. See the sample singlestore.d/conf.yaml for all available configuration options.

2. Restart the Agent.

Note: By default, the SingleStore integration only collects metrics from the MV_GLOBAL_STATUS, AGGREGATORS, and LEAVES tables. To collect additional system level metrics (CPU, disk, network IO, and memory), set collect_system_metrics: true in your singlestore.d/conf.yaml file.

Log collection

1. Collecting logs is disabled by default in the Datadog Agent, enable it in your datadog.yaml file:

   logs_enabled: true

2. Add the log files you are interested in to your singlestore.d/conf.yaml file to start collecting your SingleStore logs:

     logs:
       - type: file
         path: /var/lib/memsql/<NODE_ID>/tracelogs/memsql.log
         source: singlestore
         service: "<SERVICE_NAME>"

   Change the path and service parameter values and configure them for your environment. See the sample singlestore.d/conf.yaml for all available configuration options.

3. Restart the Agent.

Containerized

For containerized environments, see the Autodiscovery Integration Templates for guidance on applying the parameters below.

Metric collection

Parameter	Value
<INTEGRATION_NAME>	singlestore
<INIT_CONFIG>	blank or {}
<INSTANCE_CONFIG>	{"host": "%%host%%", "port": "%%port%%", "username": "<USER>", "password": "<PASSWORD>"}

Log collection

Collecting logs is disabled by default in the Datadog Agent. To enable it, see Kubernetes Log Collection.

Parameter	Value
<LOG_CONFIG>	{"source": "singlestore", "service": "<SERVICE_NAME>"}

Validation

Run the Agent's status subcommand and look for singlestore under the Checks section.

Data Collected

Metrics

See metadata.csv for a list of metrics provided by this check.

Events

The SingleStore integration does not include any events.

Service Checks

See service_checks.json for a list of service checks provided by this integration.

Troubleshooting

Need help? Contact Datadog support.