RousselTMLEARNING

Observability

SigNoz, ClickStack and ClickHouse best practices for observability

Production checklist for an observability platform on ClickHouse: OpenTelemetry instrumentation, batched ingestion, retention, replication, security and costs.

1. Collecting #

OpenTelemetry first.

Principles #

  • OpenTelemetry instrumentation only: the interface stays replaceable.
  • service.name, service.version and deployment.environment everywhere.
  • Collectors with the batch processor and a memory limit.
  • Trace sampling (tail sampling) beyond a few thousand spans per second.

2. Storing #

ClickHouse operated well.

Rules #

  • Per-signal retention with TTL.
  • Replication and backups (BACKUP to S3).
  • Tiered storage for old data.
  • Monitoring of parts, merges and slow queries.
  • Separate ClickHouse accounts for ingestion and reading.

Reference diagram and quick check #

Checklist.

Checklist #

  1. Applications instrumented with OpenTelemetry
  2. Collectors sized
  3. Replicated ClickHouse with TTL
  4. Alerts on critical services
  5. Tested backups
  6. Authenticated access to the interface

Related articles

Observability on ClickHouse: why a columnar database changes the game

Why more and more observability platforms store logs, traces and metrics in ClickHouse: columnar storage, com…

SigNoz: architecture and installation

SigNoz components (OpenTelemetry collector, ClickHouse, query service, interface, alerts), installation with …

Using SigNoz: APM, traces, logs, dashboards and alerts

Use SigNoz day to day: APM view of services, traces and logs explorers, query builder, ClickHouse and PromQL …

Keep learning

Support us

♥ SUPPORT US

Support RousselTM Learning

Courses, articles, labs and certificates stay free with no intrusive ads. A voluntary contribution, of any amount you choose, pays for hosting, lab environments and new content.

Contribute with PayPal Any amount · card or PayPal accountLearn more
QR code PayPal
Or scan this QR code with your phone

Thank you, every contribution counts!