Monitor Aiven for ClickHouse® metrics with Aiven for Grafana®

Push Aiven for ClickHouse® metrics to Aiven for Metrics or Aiven for PostgreSQL®, and integrate with Aiven for Grafana® to monitor your metrics on Grafana dashboards.

For more information on the metrics, see Aiven for ClickHouse® metrics exposed in Aiven for Grafana®.

Metrics storage options

Aiven provides two options for storing your Aiven for ClickHouse metrics:

• Aiven for Metrics: A managed time-series database service built on Thanos, optimized for long-term metrics storage and querying

  No external Thanos access

  While Aiven for Metrics uses the Thanos architecture internally, you cannot connect your Aiven-managed services to any external (non-Aiven) Thanos endpoint. Connect to Aiven for Metrics instead.

• Aiven for PostgreSQL: A relational database that can store metrics data using TimescaleDB extension

Push ClickHouse® metrics to Metrics or PostgreSQL

To collect metrics about your Aiven for ClickHouse service, configure a metrics integration and nominate somewhere to store the collected metrics.

1. On the service Overview page for your Aiven for ClickHouse service, go to Integrations, and click Go to Integrations > Store Metrics.
2. In the Metrics integration window:
   1. Choose either a new or existing Aiven for Metrics or Aiven for PostgreSQL service.
      • For Aiven for Metrics: This provides a Thanos-based time-series database optimized for metrics storage and long-term retention
      • For Aiven for PostgreSQL: This stores metrics in a relational format, suitable if you prefer SQL-based querying
      • If you choose to use a new service, follow instructions on how to create a service.
      • If you're already using Aiven for Metrics or Aiven for PostgreSQL, you can submit your Aiven for ClickHouse metrics to the existing service.
   2. Click Enable.

Provision and configure Grafana

1. In the Aiven Console, go to your metrics storage service (Aiven for Metrics or Aiven for PostgreSQL) page.
2. On the service Overview page, go to Integrations, and click Go to Integrations > Grafana Metrics Dashboard to make your metrics available in Aiven for Grafana.
3. In the Dashboard integration window:
   1. Choose either a new or existing Aiven for Grafana service.
      • If you choose to use a new service, follow instructions on how to create a service.
      • If you're already using Grafana on Aiven, you can integrate your Aiven for Metrics or Aiven for PostgreSQL as an additional data source for that existing Grafana.
   2. Click Enable.

note

Now your Aiven for Grafana service is connected to your metrics storage service as a data source. After a few minutes, your metrics are available for visualization on a Grafana dashboard.

Open ClickHouse metrics dashboard

1. In the Aiven Console, go to the Overview page of the integrated Aiven for Grafana service, and click the Service URI link.
2. Log in to Grafana using the username and password available on the Aiven for Grafana service Overview page > Connection information.
3. In Grafana, go to Dashboards and open your Aiven for ClickHouse metrics dashboard.
4. Browse prebuilt views or create your own monitoring views.