Altinity Blog

Our series on managing large datasets in ClickHouse MergeTree tables continues. In Part 2 we discuss best practices for S3 bucket configuration, storage policies, and MergeTree table administration.

ClickHouse datasets are getting big. Store MergeTree table data on S3 object storage to handle them economically and flexibly. Part 1 covers architecture and storage organization.

These days new ClickHouse applications start with petabyte-sized datasets and scale up from there. Fortunately, ClickHouse gives you open-source tools for real-time analytics on big data: MergeTree backed by object storage as well as reading on data lakes. We’ll start...

A few weeks ago we discussed how to read external Parquet data from ClickHouse. The article raised some performance concerns when querying big collections of Parquet files out of AWS S3 buckets. Time flies fast. Altinity engineers have made some...

If controlling CI/CD bills is essential for you or you're interested in exploring non-AWS-oriented runner solutions for your projects hosted on GitHub, then read on and see how using Hetzner Cloud GitHub runners for ClickHouse helped us control our ClickHouse...

In this article, we give a short retrospective of Altinity contributions to ClickHouse and also introduce our view on how ClickHouse should evolve to be the best database on the planet! 

ClickHouse gives impressive performance out of the box. Our webinar will show you how to make it amazing. We start by providing a framework for performance that includes basic drivers like I/O and compute, as well as ClickHouse structures like...

ClickHouse is an extremely versatile DBMS. When presenting it to newbies, I sometimes describe it as a combination of four “F”-s: Fast, Flexible, Fun and Free. We often benchmark ClickHouse in different scenarios to demonstrate how fast it is. Case...

The Altinity ClickHouse Sink Connector is a great way to add sophisticated analytics to your organization with minimal impact to your production MySQL or PostgreSQL system. In this article, we’ll start a test environment and put the Sink Connector to...

Altinity released version 2.0 of the Altinity ClickHouse Sink Connector is here! This open-source, Apache 2.0-licensed project lets you mirror changes from a MySQL or PostgreSQL database into ClickHouse. Read more about the new features in this blog.

As part of our release support plan, we are glad to announce two new releases of ClickHouse 23.3 built by Altinity: 23.3.19.33.altinitystable and 23.3.19.34.altinityfips.

The Altinity Grafana Plugin for ClickHouse 3.0.0 is fully compatible with Grafana 10. Find out how to get it and see the roadmap. 15M downloads can't be wrong!