Fixing the Dreaded ClickHouse Crash Loop on Kubernetes

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…

Connecting ClickHouse to External Data Sources using the JDBC Bridge

Connecting ClickHouse to External Data Sources using the JDBC Bridge

ClickHouse is never used as a standalone – it integrates with other data sources and exposes query results to applications. Upstream data for OLAP is sometimes in relational databases like MSQL SQL Server. The JDBC and ODBC bridges provide a…

My First ClickHouse Cluster on GCP

My First ClickHouse Cluster on GCP

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.

Meet the Open Source Analytics Community at OSA Con on Nov 2

Meet the Open Source Analytics Community at OSA Con on Nov 2

Our goal was to bring together a diverse set of presentations from the entire open source analytic community, rather than focusing on single projects or applications. We’ve succeeded and here’s just a sample of talks you’ll hear. 

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…

Monitoring ClickHouse on Kubernetes with Prometheus and Grafana

Monitoring ClickHouse on Kubernetes with Prometheus and Grafana

The ClickHouse Kubernetes operator is great at spinning up data warehouse clusters on Kubernetes. Once they are up, though, how can you see what they are actually doing? It’s time for monitoring!In this article we’ll explore how to configure two…