Altinity Blog

No fluff. No spam. Just the latest ClickHouse® content to your inbox.

Webinars

Showing Beautiful ClickHouse® Data with the Altinity Grafana Plugin

 • 
The Altinity Grafana Plugin for ClickHouse® is the most popular plugin for creating dashboards on ClickHouse data with over 16M downloads. In this webinar, we’ll reveal how it works and how you can use it to create flexible, attractive dashboards...
S3 and ClickHouse part 3
Blog

ClickHouse® MergeTree on S3 – Keeping Storage Healthy and Future Work

 • 
The final article of our series on managing large datasets in ClickHouse MergeTree covers how to clean up orphan S3 files. We conclude with ideas for future improvements to S3 storage management.
Blog

ClickHouse® MergeTree on S3 – Administrative Best Practices

 • 
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.
Blog

ClickHouse® MergeTree on S3 – Intro and Architecture

 • 
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.
Webinars

Petabyte-Scale Data in Real-Time: ClickHouse®, S3 Object Storage, and Data Lakes

 • 
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...
Blog

Building A Better ClickHouse® for Parquet in Practice

 • 
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...
Blog

Slash CI/CD Bills (Part 2): Using Hetzner Cloud GitHub Runners for Your Repository

 • 
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...
Blog

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! 
Webinars

ClickHouse® Performance Master Class – Tools and Techniques to Speed up any ClickHouse App

 • 
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...
Blog

Math Games in ClickHouse® — Solving Project Euler Problems

 • 
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...
Blog

Using Version 2.0 of the Altinity ClickHouse® Sink Connector

 • 
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...
Blog

Announcing Version 2.0 of the Altinity ClickHouse® Sink Connector

 • 
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.