Discover how Aiven for ClickHouse delivers superior performance and value. We rigorously tested AWS & GCP instances for your workloads.
Arthur Ansquer
|RSS FeedSubscribe for the latest news and insights on open source, Aiven offerings, and more.
Aiven is proud to introduce our new pricing plans for Aiven for ClickHouse! Depending on your chosen region and plan, you can now double your compute power for the same price. On the other hand, if reducing costs is your priority, it's now possible to lower your total cost by up to 30% for the same compute power, depending on how you use the service. But how did we achieve this? This article explains how, and why Aiven’s nodes are the best for your ClickHouse workloads. Choosing Aiven offers peace of mind. We've already evaluated all the hyperscaler options for you, allowing you to focus on your business.
This benchmarking wasn't just about picking a few new VMs. It was a comprehensive research mission. We're excited to share our journey, our findings, and more importantly, how this translates into a faster, more flexible, and cost-effective Aiven for ClickHouse service for you.
Choosing the right compute instance for your workload is complex. Hyperscaler cloud providers offer a wide array of instance types with different CPU types and generations, varying memory-to-CPU ratios, and many storage options like network-attached storage, local instance store, and attached SSDs. All these options can be intimidating, making instance selection confusing.
By over-provisioning your instances, you over-spend. By under-provisioning, you risk losing your users to slow queries and customer incidents. Compounding this challenge, the number of available instance types grows annually, and the optimal type for your workload may not yet be available in your region.
To ensure that we offer the best price-performance available, we analyzed all the available options to find the sweet spot for Aiven for ClickHouse.
We chose ClickBench for our benchmark because it is a robust standard specifically designed for an analytical DBMS like ClickHouse.
Here’s a glimpse into our methodology:
us-west-2 and GCP us-central-1, including at least 1TB of storage for a fair baseline. For VMs with attached SSDs, we used that storage for benchmarks; for others, we used EBS gp3 on AWS or Hyperdisk on GCP.We cast a wide net, focusing on promising instance families from both AWS and GCP, including those with Intel, AMD, and ARM (Graviton) processors, and various RAM-to-CPU ratios and storage options. A key decision was prioritizing network-attached storage, like AWS EBS and GCP Hyperdisk, for its flexibility and dynamic disk sizing capabilities. This is a game-changer for Aiven for ClickHouse.
A key consideration was the performance of SSDs that we offer today, compared to the flexibility of network-attached storage. Because SSDs are limited in size and complex to upgrade, we chose network-attached storage so we could offer dynamic disk sizing (DDS).
General Purpose (EBS-backed)
Storage Optimized (Attached SSDs)
General Purpose (Hyperdisk/Persistent Disk)
Compute Optimized (Hyperdisk/Persistent Disk)
Our rigorous benchmarking led to clear winners, translating directly to improved price performance.
(Remember, the lower, the better!)
i8g instances (storage-optimized ARM with attached SSDs) showed excellent cold query performance, the m8g series with EBS emerged as our strategic choice:m8g performance was very close to i8g.m8g instances generally offer more vCPUs at comparable price points or memory configurations than i*g, aiding CPU-intensive background tasks like ClickHouse’s merges and supporting more concurrent client connections, very valuable for intensive usage of Aiven for ClickHouse.m series tends to be updated more regularly by AWS and has broader regional availability. This helps us keep your service on the cutting edge. The i3en (our old instance) came out in 2019, and its like-for-like SSD size successor, the i7ie (Intel, not even ARM!), only arrived in 2024 and is much more expensive.WINNER AWS: m8g instances with AWS EBS gp3.
The GCP landscape was more nuanced, with less dramatic differences between families, especially N-series and C-series instances:
WINNERS GCP: c4-standard** and especially their ARM equivalent** c4a-standard with GCP Hyperdisk with the best price/performance ratio overall.
In a nutshell:
Choosing Aiven for ClickHouse means you get the benefit of cutting-edge hardware, flexible storage, and the peace of mind knowing that we're constantly striving to provide the best possible platform for your analytical needs, ensuring optimal value for your investment.
We're excited to roll out these new plans! Start a new service with those new plans today.
For existing Aiven for ClickHouse services, migrations will be as smooth as a regular plan upgrade, directly in the console or with the Aiven API. Check out our FAQs highlighting all the processes to get started with a new plan.
Got questions about migrating or choosing the right plan? Contact our ClickHouse experts right now.
