checkfleet

ClickHouse check

clickhouse — ClickHouse

/ping and SELECT version(), plus read-only replicated tables and replication delay.

checkfleet check clickhouse --config checkfleet.yml

Checks a ClickHouse server over its HTTP interface (zero-dep):

  • Reachability — /ping must return Ok. (ERROR if unreachable, BAD otherwise) and SELECT version() must answer (ERROR on failure); the healthy message carries the server version.
  • Replicated tables (system.replicas) — per table, BAD if the replica is read-only (usually a lost ZooKeeper/Keeper session), else replication delay WARN/BAD over delay_warn_seconds/delay_crit_seconds. Healthy tables produce no finding; a server with no replicated tables adds nothing.

Credentials come from env (username + password_env, sent as HTTP basic auth), never inline; insecure_skip_verify for self-signed HTTPS. Tested against an in-test fake HTTP server.

  clickhouse:
    delay_warn_seconds: 30
    delay_crit_seconds: 300
    targets:
      - {name: ch-01, url: http://ch-01:8123, username: monitor, password_env: CLICKHOUSE_PASSWORD}

See the full module reference for every check, or configuration for the config keys.