Aiven for ClickHouse Now Generally Available

Dec. 14, 2022 — Aiven has announced that its new real-time data warehouse service, Aiven for ClickHouse, is now generally available for production grade usage. Since the introduction of the beta version of the service just 3 months ago, Aiven has worked with the beta testers to iron out all glitches and to implement new capabilities. ClickHouse is now a fully supported member in the set of integrated, open source data services provided on the platform.

Faster Data Insights at Scale with ClickHouse

ClickHouse is a fast, open-source cloud data warehouse that’s fully open source. It allows you to generate analytical data reports in real time using advanced SQL queries. ClickHouse is built to process hundreds of millions of rows and tens of gigabytes of data per server per second. It supports industry-leading query performance, while significantly reducing storage requirements through the innovative use of columnar storage and compression.

ClickHouse is ideal for high volumes of low level ‘event’ data, such as IoT telemetry, clickstream data, log files and real-time market data.

More Than Just ClickHouse

Aiven for ClickHouse service runs on our reliable and battle-tested cloud management platform inheriting all of its great capabilities:

• Reliable operations with no downtime: Self-healing, reliable solution with a 99.99% uptime SLA, enterprise-grade monitoring and 24×7 proactive support. Ensure your business continuity with daily backups, rolling software upgrades for major and minor versions, and automated failover across multiple regions.
• Easy analytics pipelines: Integrate Aiven for ClickHouse with Apache Kafka or PostgreSQL data sources with a click of a mouse. Visualize powerful dashboards using Aiven for Grafana.
• Zero lock in: Guaranteed compatibility with open-source ClickHouse software protects you from software vendor lock-in. Our multi-cloud platform lets you choose your preferred cloud and makes it possible to later on easily migrate to different clouds.
• Security and compliance: Aiven services run on dedicated virtual machines with end-to-end encryption and our platform is ISO 27001:2013, SOC 2,GDPR, and HIPAA compliant.
• DevOps friendly: Gain programmatic access to your ClickHouse clusters with our powerful REST APIs, CLI access for CI/CD and Terraform tooling to integrate with your existing DevOps processes.
• Superior observability: Monitor your data infrastructure by easily connecting Aiven for ClickHouse with other Aiven services for ready-made monitoring dashboards and unlimited log storage and search. We also provide integrations for popular external services like Prometheus, Rsyslog, AWS CloudWatch and Google Cloud Logging.

Real-Life Experiences from Testing Aiven for ClickHouse

Aiven for ClickHouse beta was tested by companies from a wide range of industries, who have the need to gain real-time insights.

One of the early testers was Chatlayer by Sinch – a company providing AI-powered chatbot solutions to their customers. The Chatlayer solution includes advanced analytics capabilities to provide insights into the customers conversations, and when testing Aiven for ClickHouse in this area the results were very positive.

“We were positively surprised with the performance of Aiven for ClickHouse – it is really fast,” said Miguel Carvajal, Technical Lead at ChatLayer. “And thanks to the excellent data compression, we were able to save on costs compared to our previous solution.”

Source: Aiven