When users come to Altinity.Cloud, many are not trying to replace non-analytical databases like MySQL or PostgreSQL. They want to migrate data to ClickHouse and keep it in sync with the database, just like a mirror. In this post, we look at a ‘pure ClickHouse’ approach, highlighting interesting features and problems that require external tools.
2022 is almost over. Santa Claus is decorating his sleigh for the holiday voyage, and people all around the world are preparing to celebrate the new year. Let’s have a seat and take a quick look back to what Altinity was in 2022, and imagine what we can do in 2023.
Altinity.Cloud Anywhere introduces a new concept of an “open cloud” that allows you to plug other clouds or on-prem deployments into Altinity management plane. The only requirement is Kubernetes.
Since its inception, Altinity has contributed to and maintained many open source projects that are accelerating ClickHouse development and adoption. Read our open source story!
Read the latest updates to 21.1 and 21.8 Altinity Stable Builds for ClickHouse — built in a secure environment and signed and maintained for three years. You’ll find a security update to the 21.1.10.3 release and changes to Community Build 21.8.15.7-lts and the previous Altinity Stable 21.8.13.1.
When it comes to ClickHouse, how many columns are too many? 100 columns? 5,000 columns? In our latest experiment, we put 10,000 columns to test using some configuration tweaks and enough memory. Click to find out what happened!
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 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.
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.
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.
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!
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!
