As countless ClickHouse users have learned, Kubernetes is a great platform for data. It’s portable to almost every IT environment. Managed Kubernetes services like Amazon EKS simplify operation. And the Altinity Kubernetes Operator for ClickHouse lets you start complex ClickHouse clusters from a single resource file. But there’s still the…

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 how much faster we can accomplish the same task, so…

Written with Lead Support Engineer Mikhail Filimonov. And in such indices, although small pricks To their subsequent volumes, there is seen The baby figure of the giant mass Of things to come at large. -William Shakespeare ClickHouse indices are different from traditional relational database management systems (RDMS) in that: Primary…

If you are a technical person and use a Mac, it is virtually a given that the first thing you do on a fresh machine is install the Homebrew package manager. Nearly everything that is available through Homebrew can be installed manually by building from sources or just unpacking the…

There’s no better place to learn about databases on the web than the awesome CMU Database Group YouTube channel maintained by Andy Pavlo. Fall 2021 was no exception with the Vaccination Database Talks, Second Dose series. One of the talks was especially relevant for ClickHouse users: Ben Wagner presenting How…

Like a bridge over troubled water I will lay me down Paul Simon ClickHouse is a piece of art. It is very fast and efficient. In real applications, however, ClickHouse is never used as a standalone — it integrates with other data sources and exposes query results to applications. OLAP…

2021 has been a great year for Altinity.Cloud. Cloud users have grown to almost a third of our total subscription base. During that time both we and our customers have absorbed lessons on using ClickHouse effectively in the cloud. So what have we learned? In this article, I would like…

ARM processors are hot. Amazon AWS and Apple have been building their own ARM processors for a few years already. They use them in servers and notebooks and get outstanding results. Ampere builds server-class ARM processors for everybody else. At Altinity we could not stand aside from this A-march. Today…

As regular readers of this blog are aware, Altinity.Cloud now supports Google Cloud Platform, also known as GCP. I recently took the new capability out for a spin to see what it’s like to run ClickHouse there. Spoiler: it’s virtually identical to running on AWS, which we’ve supported since 2020…