Building A Better ClickHouse®

Building A Better 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! 

Tips for High-Performance ClickHouse® Clusters with S3 Object Storage

Tips for High-Performance ClickHouse® Clusters with S3 Object Storage

ClickHouse often runs in a cluster, and cluster operation poses some interesting questions regarding S3 usage. They include parallelizing data load across nodes, benefits of horizontal vs. vertical scaling, and avoiding unnecessary replication. In this article, we will discuss how…

ClickHouse® Object Storage Performance: MinIO vs. AWS S3

ClickHouse® Object Storage Performance: MinIO vs. AWS S3

ClickHouse now fully supports both AWS S3 and MinIO as S3-compatible object storage services. In this comparison, we will test the performance of AWS S3 and MinIO when used to store table data from two of our standard datasets: the…

Integrating ClickHouse® with MinIO

Integrating ClickHouse® with MinIO

In November 2020, Alexander Zaitsev introduced S3-compatible object storage compatibility with ClickHouse. In his article ClickHouse and S3 Compatible Object Storage, he provided steps to use AWS S3 with ClickHouse’s disk storage system and the S3 table function. Now, we…

ClickHouse® and S3 Compatible Object Storage

ClickHouse® and S3 Compatible Object Storage

ClickHouse is a polyglot database that can talk to many external systems using dedicated engines or table functions. In modern cloud systems, the most important external system is object storage. It can hold raw data to import from or export…