This check monitors ClickHouse through the Datadog Agent.
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.
The ClickHouse check is included in the Datadog Agent package. No additional installation is needed on your server.
To configure this check for an Agent running on a host:
-
To start collecting your ClickHouse performance data, edit the
clickhouse.d/conf.yamlfile in theconf.d/folder at the root of your Agent's configuration directory. See the sample clickhouse.d/conf.yaml for all available configuration options.
-
Collecting logs is disabled by default in the Datadog Agent, enable it in your
datadog.yamlfile:logs_enabled: true
-
Add the log files you are interested in to your
clickhouse.d/conf.yamlfile to start collecting your ClickHouse logs:logs: - type: file path: /var/log/clickhouse-server/clickhouse-server.log source: clickhouse service: "<SERVICE_NAME>"
Change the
pathandserviceparameter values and configure them for your environment. See the sample clickhouse.d/conf.yaml for all available configuration options.
For containerized environments, see the Autodiscovery Integration Templates for guidance on applying the parameters below.
| Parameter | Value |
|---|---|
<INTEGRATION_NAME> |
clickhouse |
<INIT_CONFIG> |
blank or {} |
<INSTANCE_CONFIG> |
{"server": "%%host%%", "port": "%%port%%", "username": "<USER>", "password": "<PASSWORD>"} |
Collecting logs is disabled by default in the Datadog Agent. To enable it, see Kubernetes log collection.
| Parameter | Value |
|---|---|
<LOG_CONFIG> |
{"source": "clickhouse", "service": "<SERVICE_NAME>"} |
Run the Agent's status subcommand and look for clickhouse under the Checks section.
See metadata.csv for a list of metrics provided by this integration.
The ClickHouse check does not include any events.
See service_checks.json for a list of service checks provided by this integration.
Need help? Contact Datadog support.