Webinar Slides. ClickHouse Monitoring 101: What to monitor and how
By Robert Hodges and Ned McClain
Slides for the Webinar, presented on Apr 1, 2020
Webinar recording is available here
You are about to deploy ClickHouse into production. Congratulations! But what about monitoring? In this webinar we will introduce how to track the health of individual ClickHouse nodes as well as clusters. We’ll describe available monitoring data, how to collect and store measurements, and graphical display using Grafana. We’ll demo techniques and share sample Grafana dashboards that you can use for your own clusters.
ClickHouse monitoring with Zabbix
Altinity is happy to introduce a new tool in ClickHouse environment – Zabbix template for monitoring ClickHouse. It is open source and available on github
Let’s walk in details on how to install and setup this template.
ClickHouse + Graphouse introduction
A few weeks ago we described how to setup ‘ClickHouse monitoring with Graphite’. Today we are going to look at this from a different angle: how ClickHouse can be used as a Graphite backend.
ClickHouse Monitoring with Graphite
Monitoring is an important part of operating any software in production. The proper monitoring solution needs to store metrics somewhere as well as provide visualization capabilities. ClickHouse does not have such a tool packaged, but there are several 3rd-party monitoring solutions that can be used. In this article, we will describe how to configure Graphite for monitoring ClickHouse metrics.
Analyze MySQL Audit Logs with ClickHouse and ClickTail
In this blog post, I’ll look at how you can analyze MySQL audit logs (Percona Server for MySQL) with ClickHouse and ClickTail. Audit logs are available with a free plugin for Percona Server for MySQL. Besides providing insights about activity on your server, you might need the logs for compliance purposes.