This joint-webinar with Altinity and OpsVerse will show how OpsVerse is changing the observability game with real-time analytics on ClickHouse and software from Altinity. This talk is a two-fer: learn about how OpsVerse helps with observability and get inspiration to apply ClickHouse real-time analytics to your applications.
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.
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.
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.
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.
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.