As the summer (or winter) time is upon us, depending on where we are on the globe, we wanted to share some of our key highlights from the first half of 2022.
Despite the economic uncertainty that the Russian invasion of Ukraine is causing around the globe, businesses everywhere are looking for new ways to go to market faster, open up markets and speak to new audiences. The open source world in particular moves at creation-lightspeed and it’s important to not only keep up but to try and stay ahead.
At Altinity, we help our customers do just that: stay ahead of the curve by offering innovative solutions that enable them to go to market faster with new analytic applications based on ClickHouse.
Be it with our flagship product, Altinity.Cloud, or its latest iteration — Altinity.Cloud Anywhere — combined with our unique brand of ClickHouse support and services, helping customers get the most out of their open source ClickHouse environment is key to us.
It has allowed us to achieve some significant milestones in the first half of this year, which we’d like to share with you via this blog post.
Altinity Momentum Highlights – H1 2022
- 150+ new companies enrolled in Altinity.Cloud trials so far this year
- Altinity.Cloud revenue has increased 144% while helping customers run ClickHouse worldwide
- 65% increase in production accounts
- Customers run their clusters in 15 AWS regions and 9 GCP regions
- Announced new partners & customers including PostHog, Momentum Dash, and more
- Our open source Altinity Kubernetes Operator for ClickHouse has reached 1K+ stars on GitHub
- Lots of updates to Altinity software, including Altinity Stable for ClickHouse 22.3
Altinity Product Highlights
With Altinity.Cloud our goal is to offer our customers the most productive platform possible for real-time analytics on ClickHouse. You can create prod-ready clusters in AWS or GCP with ease, point your apps at ClickHouse, and start solving customer problems – fast!
This year, we’ve introduced a new flavor to allow customers to experience cloud management while owning their data: Altinity.Cloud Anywhere, which builds on top of Altinity.Cloud and all of its great and proven features. Altinity.Cloud Anywhere provisions new ClickHouse clusters running in your own Kubernetes and lets you manage them for as long as you need. You can control security policies, manage cloud expense, and protect your investment in data.
Top 5 New Altinity.Cloud Features
- Easy access to ClickHouse logs — we have added dashboards with flexible search functionality. For customers using Datadog we can send logs to their Datadog account as well.
- Cluster uptime schedule feature allows you to pause clusters automatically when not in use, and save costs on dev instances this way.
- New Workload dashboard gives a quick insight to the most resource consuming queries. We have also improved Schema explorer.
- Kafka connectivity tool helps to test connection to the external Kafka compatible broker and generate ClickHouse config.
- Altinity.Cloud recommends when new version of ClickHouse is available for an upgrade.
See Altinity Cloud Release Notes for more detail on features and improvements.
Altinity Stable Builds for ClickHouse
The Altinity Stable builds are releases of ClickHouse with extended maintenance that undergo rigorous testing to verify they are secure and ready for production, whether on premise or in the cloud – including Kubernetes. They build on the excellent community ClickHouse long-term support (LTS) releases. In short, they provide a secure, stable, pre-compiled binary release of ClickHouse server and client. Altinity Stable Builds are 100% open source and 100% compatible with ClickHouse community builds. We support them for up to three years.
Top 5 New Altinity Stable Build for ClickHouse 22.3 Features
- User defined functions
- Schema inference for SELECTs and INSERTs from external sources
- Asynchronous inserts
- Named connections for external data sources
- Production ready window functions and projections
See the 22.3 Release Notes article to learn more.
Altinity Content Highlights
Many of you will know us from the content that we publish on a regular basis in which we discuss all things ClickHouse, Kubernetes, our own products and related technologies and topics.
Our video tutorials on how to make the most out of ClickHouse are among the most popular resources for ClickHouse on the web, as are our how-to and other technical blogs.
Many thanks for following us and for viewing our content, which we trust is useful and helpful.
Below you will find our Top 5 most read blogs and viewed videos of 2022 so far!
Top 5 Most Read New Blogs
- Database on Fire: Reflections on Embedding ClickHouse in Firebolt
- Our CEO Robert Hodges reviews a talk by Ben Wagner that’s especially relevant for ClickHouse users: How We Built Firebolt. Hint: Firebolt embedded ClickHouse as their query engine! The talk is so good that it was worth a review in the Altinity blog and Robert covers what Firebolt is up to, then adds some thoughts on what it means for ClickHouse as well as analytic database users in general.
- ClickHouse Black Magic: Skipping Indices
- ClickHouse indices are different from traditional relational database management systems (RDMS) in that primary keys are not unique and there are no foreign keys nor traditional B-tree indices. Instead, ClickHouse uses secondary ‘skipping’ indices. Those are often confusing and hard to tune even for experienced users. However, when used properly they can dramatically improve query performance. In this article our CTO Alexander Zaitsev dives into skipping indices and explains some of the ClickHouse black magic.
- Connecting ClickHouse to External Data Sources using the JDBC Bridge
- In real applications, 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. But how can ClickHouse safely load and use third-party drivers that are not known in advance?
- Altinity Introduces macOS Homebrew Tap for ClickHouse
- If you are a technical person and use a Mac, it is virtually a given that the first thing you do on a fresh machine is install the Homebrew package manager. With our own Homebrew tap, macOS developers and systems operators can type in a few commands and retrieve their preferred version of ClickHouse. Our colleague Denis Glazachev explains how in this blog post.
- ClickHouse Aggregation Fun, Part 2: Exploring and Fixing Performance
- In this second article on ClickHouse aggregation fun, we apply our new knowledge to explore the performance of actual queries, so that we can understand some of the trade-offs around time and resource usage. We finish up with a list of practical tips to make aggregation even faster and more cost-efficient.
Top 5 Most Viewed New Videos
- A Day in the Life of a ClickHouse Query – Intro to ClickHouse Internals
- This webinar, hosted by Robert Hodges (Altinity CEO), is a gentle introduction to ClickHouse internals, focusing on topics that will help your applications run faster and more efficiently. It discusses the basic flow of query execution, digs into how ClickHouse handles aggregation and joins, and shows you how ClickHouse distributes processing within a single CPU as well as across many nodes in the network.
- Altinity Quickstart for ClickHouse: Build Your First App
- If you’re about to build your first analytic app on ClickHouse, then this Altinity Quickstart for ClickHouse video is for you. The webinar focuses on key skills to build an MVP that shows off the power of ClickHouse: defining tables, loading real data from sources, selecting data out again, and tweaking performance.
- All about Zookeeper (and ClickHouse Keeper Too)
- ClickHouse clusters depend on ZooKeeper to handle replication and distributed DDL commands. In this webinar, the Altinity engineering team explains why ZooKeeper is necessary, how it works, and introduces the new built-in replacement named ClickHouse Keeper. You’ll learn practical tips to care for ZooKeeper in sickness and health. You’ll also learn how/when to use ClickHouse Keeper. We share our recommendations for keeping that happy as well.
- High Performance, High Reliability Data Loading on ClickHouse
- Data loading is critical to real-time data warehouses on ClickHouse. This webinar covers three topics every ClickHouse app designer should understand. The first is how to achieve high performance on inserts. The second is the transaction model including when you can count on data being properly loaded. The third is data deduplication, which prevents data from accidentally loading twice. Alexander Zaitsev distills Altinity experience in all three areas to enable you to build your own high-performance analytic solutions.
- Building Beautiful Interactive Dashboards with Grafana and ClickHouse
- Grafana and ClickHouse are a very popular combination for interactive dashboards on big data. In this presentation, we’ll show you how to install Grafana on ClickHouse, and lead you through the steps to create nice-looking dashboards of your own. The talk covers how Grafana Dashboards work, how to program ClickHouse queries, and examples of some of our favorite widgets. We will also show debugging tricks.
PS.: If you would be interested in learning more about our products or getting more personalized support, please click here.