Skip to main content

Monitor Aiven for ClickHouse® metrics with Aiven for Grafana®

Push Aiven for ClickHouse® metrics to Aiven for Metrics or 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®.

Push ClickHouse® metrics to Aiven for 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 Manage integrations and choose the Store Metrics option with Store service metrics in a time-series database as its description.
  2. Choose either a new or existing Aiven for Metrics or PostgreSQL service.
    • 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 PostgreSQL, you can submit your Aiven for ClickHouse metrics to the existing service.

Provision and configure Grafana®​

  1. Choose the type of the target database service, and go to the target service's page in the Aiven Console. Under Manage integrations, click Grafana Metrics Dashboard to make the metrics available on that platform.
  2. 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 PostgreSQL as an additional data source for that existing Grafana.
  3. On the service Overview page for your Aiven for Grafana service, click the Service URI link. The username and password for your Aiven for Grafana service is also available on the same page.

Now your Aiven for Grafana service is connected to Aiven for Metrics or PostgreSQL as a data source and you can go ahead and visualize your ClickHouse metrics.

Open ClickHouse® metrics dashboard​

  1. In Grafana®, go to Dashboards > Manage.
  2. Double click the dashboard that bears the name of the metrics database.
  3. Browse the prebuilt dashboard or create your own monitoring views.