Aiven for ClickHouse® concepts

Service architecture

Aiven for ClickHouse® is implemented as a multi-master cluster where the replication of data is managed by ClickHouse itself, the replication of schema and users is managed by ZooKeeper, and data backup and restoration is managed by Astacus.

Limits and limitations

By respecting Aiven for ClickHouse® restrictions and quotas, you can improve the security and productivity of your service workloads.

Online analytical processing

Online analytical processing (OLAP) is an approach to producing

ClickHouse® as a columnar database

Learn how columnar databases handle data and what benefits this approach

Indexing and data processing in ClickHouse®

ClickHouse® processes data differently from other database management systems. ClickHouse uses sparse and skipping indexes and a vector computation engine.

Disaster recovery in Aiven for ClickHouse®

Aiven for ClickHouse® prevents and mitigates emergencies or crises with multiple disaster recovery methods to keep your data safe and sound.

String data type in Aiven for ClickHouse®

Aiven for ClickHouse® uses ClickHouse® databases, which can store diverse types of data, such as strings, decimals, booleans, or arrays.

About querying external data in Aiven for ClickHouse®

Discover federated queries and their capabilities in Aiven for

Tiered storage in Aiven for ClickHouse®

The tiered storage feature introduces a method of organizing and storing data in two tiers for improved efficiency and cost optimization. The data is automatically moved to an appropriate tier based on your database's local disk usage.