At the end of November, we’ll be migrating the Sematext Logs backend from Elasticsearch to OpenSearch

ClickHouse monitoring released

October 23, 2018

Yandex ClickHouse is an open source column-oriented database management system capable of real-time generation of analytical data reports using SQL queries. ClickHouse allows you to not only lower your TCO (Total Cost of Ownership) but also allows you to benefit from unmatched performance and scalability. With the release of the new Sematext Monitoring Agent, you can now monitor ClickHouse DB clusters. The setup, tuning and operations of ClickHouse require deep insights into the performance metrics such as locks, replication status, merge operations, cache usage and many more… The new ClickHouse integration supports over 70 different ClickHouse metrics for system, queries, merge tree, replication, replicas, mark cache, R/W buffers, dictionaries, locks, distributed engine and Zookeeper errors & wait times.Screen Shot 2018 10 15 at 12.45.38

ClickHouse key metrics in Sematext Cloud

How to use it

To monitor ClickHouse create a ClickHouse App in Sematext Cloud and install the Sematext Agent according to the setup instructions. Like magic, in less than a minute you will receive all ClickHouse metrics in your ClickHouse monitoring App.

Tips

Because ClickHouse heavily relies on ZooKeeper we recommend setting up ZooKeeper monitoring and log collection for related logs. By doing this you can benefit from combined dashboards thus having your favorite ZooKeeper and ClickHouse metrics together with related logs for faster troubleshooting. Save time, gain visibility: the benefits are endless.