# Read metrics from one or many ClickHouse servers [[inputs.clickhouse]] ## Username for authorization on ClickHouse server username = "default" ## Password for authorization on ClickHouse server # password = "" ## HTTP(s) timeout while getting metrics values ## The timeout includes connection time, any redirects, and reading the ## response body. # timeout = 5s ## List of servers for metrics scraping ## metrics scrape via HTTP(s) clickhouse interface ## https://clickhouse.tech/docs/en/interfaces/http/ servers = ["http://127.0.0.1:8123"] ## Server Variant ## When set to "managed", some queries are excluded from being run. This is ## useful for instances hosted in ClickHouse Cloud where certain tables are ## not available. # variant = "self-hosted" ## If "auto_discovery"" is "true" plugin tries to connect to all servers ## available in the cluster with using same "user:password" described in ## "user" and "password" parameters and get this server hostname list from ## "system.clusters" table. See ## - https://clickhouse.tech/docs/en/operations/system_tables/#system-clusters ## - https://clickhouse.tech/docs/en/operations/server_settings/settings/#server_settings_remote_servers ## - https://clickhouse.tech/docs/en/operations/table_engines/distributed/ ## - https://clickhouse.tech/docs/en/operations/table_engines/replication/#creating-replicated-tables # auto_discovery = true ## Filter cluster names in "system.clusters" when "auto_discovery" is "true" ## when this filter present then "WHERE cluster IN (...)" filter will apply ## please use only full cluster names here, regexp and glob filters is not ## allowed for "/etc/clickhouse-server/config.d/remote.xml" ## ## ## ## ## clickhouse-ru-1.local9000 ## clickhouse-ru-2.local9000 ## ## ## clickhouse-eu-1.local9000 ## clickhouse-eu-2.local9000 ## ## ## ## ## ## ## example: cluster_include = ["my-own-cluster"] # cluster_include = [] ## Filter cluster names in "system.clusters" when "auto_discovery" is ## "true" when this filter present then "WHERE cluster NOT IN (...)" ## filter will apply ## example: cluster_exclude = ["my-internal-not-discovered-cluster"] # cluster_exclude = [] ## Optional TLS Config # tls_ca = "/etc/telegraf/ca.pem" # tls_cert = "/etc/telegraf/cert.pem" # tls_key = "/etc/telegraf/key.pem" ## Use TLS but skip chain & host verification # insecure_skip_verify = false