Altinity Blog
-
Momentum Dash is Building a More Centered Work Environment with PostHog and Altinity
Momentum Dash uses PostHog and Altinity to understand the needs of their two million users. Read how ClickHouse analytics drive product development.
-
Altinity Cumulative Release Notes for April through June 2022
Summer is here – and more updates to Altinity products! Here’s the latest releases for what our teams released since April.
-
Battle of the Views – ClickHouse Window View vs Live View
ClickHouse Live Views and Window Views are alternatives to query newly arrived data from event streams. In this article, we break down these experimental features and compare and contrast usage.
-
1 Trillion Rows in ClickHouse, Part 1: Altinity.Cloud Setup
1 Trillion rows is a lot but ClickHouse can handle it and so can you. Our first article in a blog series shows how to set up a large dataset in Altinity.Cloud — using features like multi-volume storage, fast server rescaling, and scheduled operation — at a minimal cost.
-
Trip Report: Amsterdam ClickHouse Meetup on 8 June
The June 8 meetup in Amsterdam was the first in-person ClickHouse community meetup in over 2 years. We bring you the first-hand report of ClickHouse talks, news, and updates.
-
Fast MySQL to ClickHouse Replication: Announcing the Altinity Sink Connector for ClickHouse
Want fast MySQL analytics? Then check out the Altinity Sink Connector for ClickHouse. Merging the power of ClickHouse with MySQL, the sink connector lets you replicate data from MySQL to ClickHouse in real-time.
-
Announcing Updates to 21.1 and 21.8 Altinity Stable Builds
Read the latest updates to 21.1 and 21.8 Altinity Stable Builds for ClickHouse — built in a secure environment and signed and maintained for three years. You’ll find a security update to the 21.1.10.3 release and changes to Community Build 21.8.15.7-lts and the previous Altinity Stable 21.8.13.1.
-
Too Wide or Not Too Wide — That is the ClickHouse Question
When it comes to ClickHouse, how many columns are too many? 100 columns? 5,000 columns? In our latest experiment, we put 10,000 columns to test using some configuration tweaks and enough memory. Click to find out what happened!
-
Migrating Data from Snowflake to ClickHouse using S3 and Parquet
Can your Snowflake application run on ClickHouse? Learn how to migrate data from Snowflake to ClickHouse via S3 object storage and Parquet. Low latency response, freedom to run anywhere, and outstanding cost efficiency await.
-
SF Bay Area ClickHouse Meetup News
Get a quick low-down of recent ClickHouse meetups and upcoming community events. Videos and slide decks are included!
-
Early Access to Altinity.Cloud Anywhere: Celebrating Open Source Databases @ Percona Live
Early access to Altinity.Cloud anywhere was announced at Percona Live – sign ups available now!
-
Altinity Cumulative Release Notes for Q1 2022
Our team has been busy coming out with new versions of our products since the beginning of the year, so we gathered the entire list for Q1 in one place.
-
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 what we’ve been working on together.
-
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.
