All About Zookeeper (And ClickHouse® Keeper, too!)
ClickHouse clusters depend on ZooKeeper to handle replication and distributed DDL commands. In this webinar, we’ll explain why ZooKeeper is necessary, how it works, and introduce the new built-in replacement.
ClickHouse® Aggregation Fun, Part 2: Exploring and Fixing Performance
In Part 1 we showed how ClickHouse uses parallel processing power to collect aggregates. In Part 2, we’re showing how to make aggregations faster and more efficient.
ClickHouse® Aggregation Fun, Part 1: Internals and Handy Tools
Summarization is a powerful tool for understanding masses of data. Learn how to make this process efficient and fast through ClickHouse | in part 1 of our ClickHouse aggregation series.
ClickHouse® Black Magic, Part 2: Bloom Filters
Bloom filters are an important ClickHouse index type with mysterious parameters. Take a closer look at the theory behind bloom filters, parameter selection using queries on a test dataset, and effective tuning.
Announcing the New Altinity & PostHog Partnership
Today we’re excited to officially announce our partnership with PostHog. We’ve worked with PostHog’s teams on this integration and have collaborated on ClickHouse-related topics since 2020. It’s great to be able to share with the wider open source analytics community…
How to Set Up a ClickHouse® Cluster with Zookeeper
One of the first when working with ClickHouse is “How do I set up my own ClickHouse cluster™?” This guide is the answer.
Statement re: recently reported vulnerabilities in ClickHouse®
Hacker News published a report detailing ClickHouse vulnerabilities. The good news – these were fixed months ago, and the latest Altinity Stable Builds are already updated so they are not affected.
Fixing the Dreaded ClickHouse® Crash Loop on Kubernetes
As countless ClickHouse users have learned, Kubernetes is a great platform for data. It’s portable to almost every IT environment. But there’s still the occasional dark cloud. One of these is pod crash loops, which arise when a ClickHouse pod…
Loading 100B Rows in Minutes in Altinity.Cloud®
A few weeks ago the SingleStore team published interesting research in their blog. They demonstrated how to load 100 billion rows in a database in 10 minutes. While it did not seem outstanding for ClickHouse, we were intrigued to learn…
ClickHouse® Black Magic: Skipping Indices
ClickHouse indices are different from traditional relational database management systems. Instead, ClickHouse uses secondary ‘skipping’ indices. Those are often confusing and hard to tune even for experienced ClickHouse users. In this article we will dive into skipping indices and learn…
Altinity Celebrates Company Growth in 2021 and a Great Future in 2022
Read Altinity’s 2021 earnings report to learn more about YoY increase in ClickHouse service bookings and Altinity.Cloud subscriptions, product milestones, and plans for 2022.