At Instana we are operating our Clickhouse clusters on m5.12xlarge AWS EC2 instances and similar sized custom build Google Cloud instances. The biggest cost driver however is not the size of the instance, but the EBS volumes / persistent SSDs…
ClickHouse external dictionaries are a “ClickHouse way” to handle multi-dimensional schema. ClickHouse Dictionaries Explained was the very first article in the Altinity blog three years ago. ClickHouse has improved significantly since then, and dictionaries have achieved a new level of…
My name is Meo and I’ve been a DataBase Administrator (DBA) for the last 35 years of my life. After getting a degree at the University in Turin (Italy) many years ago, I started working with relational databases, and I’m…
The ClickHouse Kubernetes operator is great at spinning up data warehouse clusters on Kubernetes. Once they are up, though, how can you see what they are actually doing? It’s time for monitoring!In this article we’ll explore how to configure two…
Kafka is a popular way to stream data into ClickHouse. ClickHouse has a built-in connector for this purpose — the Kafka engine. This article collects typical questions that we get in our support cases regarding the Kafka engine usage. We…
ClickHouse clusters apply the power of dozens or even hundreds of nodes to vast datasets. In this webinar, we’ll show you how to use the basic tools of replication and sharding to create high performance ClickHouse clusters. We’ll study the…
We are delighted to announce that Altinity Stable Release is updated to 19.16.17.85. The release includes several bug fixes not present in the previous 19.16.14.65 release.
A common use case in time series applications is to get the measurement value at a given point of time. For example, if there is a stream of measurements, one often needs to query the measurement as of current time…
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…
We are delighted to announce that Altinity Stable Release is updated to 19.16.14.65. The release includes several important bug fixes not present in the previous 19.16.12.49, and one compatibility fix that is important for future upgrades.
In data analytics, analysts often use moving averages. Moving averages help to smooth data series as well as identify long term trends. New Live View tables start to bring real-time capabilities to ClickHouse.One of the applications of Live View tables…
Materialized views are the killer feature of ClickHouse, and the Altinity 2019 webinar on how they work was very popular. Watch this replay to learn how to use materialized views to speed up queries hundreds of times. We’ll cover basic…
We use cookies to enhance your experience. By consenting, we can process data like browsing behavior or unique IDs. Without consent, some features may not work as expected.