Altinity Blog
-
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 crashes on startup. This article shows how to diagnose and fix them.
-
Loading 100B Rows in Minutes in Altinity.Cloud
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 we conducted some experiments in Altinity.Cloud.
-
ClickHouse Black Magic: Skipping Indices
ClickHouse indices are different from traditional relational database management systems. Instead, ClickHouse uses secondary ‘skipping’ indices. Those are often confusing and hard to tune even for experienced ClickHouse users. In this article we will dive into skipping indices and learn some of ClickHouse black magic.
-
Altinity Introduces macOS Homebrew Tap for ClickHouse
With our new Homebrew tap, macOS developers and systems operators can type in a few commands and retrieve their preferred version of ClickHouse. Keep reading to learn how!
-
Database on Fire: Reflections on Embedding ClickHouse in Firebolt
Review of Ben Wagner presenting How We Built Firebolt. Firebolt embedded ClickHouse as their query engine!
-
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 flexible way to connect and fetch data, especially in environments like Kubernetes.
-
Turning Pages of 2021
2021 was so far the best year for Altinity and ClickHouse. Sitting with a glass of wine in front of the fire and overlooking the Christmas tree or a snowstorm behind the icy window, let’s remember what has happened.
-
Redpanda and a ClickHouse Operator UI: December ‘21 SF Bay Area ClickHouse Meetup
The final SF Bay Area ClickHouse Meetup for 2021 took place on December 15th. We had talks on Redpanda event streaming to ClickHouse as well as Altinity Dashboard, a new UI for the ClickHouse Kubernetes Operator.
-
Introducing the Altinity Dashboard, a UI for the ClickHouse Operator
The Altinity Dashboard is a new UI aimed at making ClickHouse deployment in Kubernetes easy, painless and successful. It builds on the ClickHouse Operator for Kubernetes. We invite you to try it out!
-
Lessons on Building Analytic Applications with Altinity.Cloud
2021 has been a great year for Altinity.Cloud. Altinity.Cloud users have grown to almost a third of our subscription customers. So what have we learned? In this article, I would like to call out three points for anyone working on real-time analytics and ClickHouse.
-
Altinity.Cloud Extends Managed ClickHouse to ARM
ARM processors are hot. Amazon AWS and Apple have been building their own ARM processors for a few years already. Today we are happy to announce the first ever managed ClickHouse on ARM!
-
CVE-2021-44228 Log4J Vulnerability and ClickHouse
ClickHouse and Altinity products are not subject to CVE-2021-44228 based on knowledge available today. If you run any Java applications, you should check whether they have the affected Log4J library version. Check here for advice to detect and remediate the problem.
-
Keeping ClickHouse Open and Portable in Altinity.Cloud
ClickHouse is on the fast track to become the most popular analytic database on the planet. Learn how users can run in Altinity.Cloud or manage ClickHouse themselves
-
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.
-
Ultra-Fast Data Loading and Testing in Altinity.Cloud
Learn how you can load and test ClickHouse datasets with lightning speed and leverage the power of cloud operation with this Altinity.Cloud tutorial. PS…You’ll find it’s really easy too!
-
Altinity is SOC 2 Type II Compliant!!
Back in March, we told you we take the responsibility to protect customer data with the highest standards of security and it’s something we take very seriously. Today we are happy to announce that Altinity.Cloud is now SOC 2 Type II certified!
-
Data Visualization and JSON: October SF ClickHouse Bay Area Meetup
Time flies! The 27 October SF ClickHouse Meetup had three new talks on the themes of data visualization and JSON processing. The videos have been up for a while so here’s a quick summary as well as links in case you would like to watch them.
-
OSA Con 2021 Content is Online. See You in 2022!
OSA Con 2021, our first conference dedicated to open source analytics, is a wrap. We had a great conference with 22 talks by 31 presenters. I’m delighted that we could bring together so many different projects and applications under a single roof.
