ClickHouse® Configurations
Node group configurations
A ClickHouse® Managed Database cluster consists of node groups. When creating a cluster, you can select the node group configuration — the amount of vCPU, RAM, and disk size. All nodes in a group will have the same configuration.
Configurations are divided into lines. Depending on the line, configuration, and pool, different processors and disks are used.
When selecting a configuration, keep in mind that part of the disk space is reserved for service needs and is unavailable for hosting databases. For more details, see the instructions Using disk space in a ClickHouse® cluster.
The configuration of each node group can be selected when creating a ClickHouse® Managed Database cluster. After a cluster is created, you can change the node group configuration. For more details, see the instructions Scaling a ClickHouse® cluster.
Configuration lines
The resource ratio in configuration lines can be:
You can view the availability of configuration lines in regions in the Managed Databases availability matrix.
Standard
A line of fixed configurations with a local disk and a balanced vCPU:RAM ratio, suitable for most DBMS. We recommend using this line if you do not know the load profile.
Intel® Xeon® Scalable or AMD EPYC™ processors are used. You can view the processor frequencies for different lines in the Processors.
You can view disk performance and bandwidth in different lines in the Performance and Bandwidth table.
CPU
A line of fixed configurations with a local disk and a balanced vCPU:RAM ratio. Suitable for load profiles that are demanding on compute. For example, if the database performs analytical queries, multiple nested queries, or data encryption.
Intel® Xeon® Scalable or AMD EPYC™ processors are used. You can view the processor frequencies for different lines in the Processors.
You can view disk performance and bandwidth in different lines in the Performance and Bandwidth.
Memory
A line of fixed configurations with a local disk and a balanced vCPU:RAM ratio. Suitable for load profiles that are demanding on caching. For example, if the database executes multiple, rarely repeating queries to different parts of tables.
Intel® Xeon® Scalable or AMD EPYC™ processors are used. You can view the processor frequencies for different lines in the Processors.
You can view disk performance and bandwidth in different lines in the Performance and Bandwidth.
HighFreq
A line of fixed configurations with a balanced vCPU:RAM ratio.
High-performance Enterprise-grade equipment is used:
- Intel® Xeon® Gold 6354 processors (in pools ru-9, ru-2, ru-8, ke-1) or AMD EPYC 9474F processors (in pools ru-3, ru-7, uz-1). You can view the processor frequencies for different lines in the Processors;
- RAM ECC Reg 3.2 GHz (in pools ru-9, ru-2, ru-8, ke-1) or RAM DDR5 ECC Reg 4.8 GHz (in pools ru-3, ru-7, uz-1);
- High-performance NVMe SSDs. You can view the performance and bandwidth of disks for different lines in the Performance and bandwidth.
Flex
A line of custom configurations with a local or network volume, in which you can choose the resource ratio.
You can view information about disks in the Disks instructions.
You can view disk performance and bandwidth in different lines in the Performance and Bandwidth table.
Intel® Xeon® Scalable or AMD EPYC™ processors are used. You can view the processor frequencies for different lines in the Processors.
You can view the availability of configurations in regions in the Managed Databases availability matrix. Configuration limits depend on the pool.
Local disk
Network volume
* If the configuration has more than 8 vCPU, the vCPU:RAM ratio must be at least 1:4. For example, for 10 vCPU, you need at least 40 GB of RAM.
** If the configuration has more than 8 vCPU, the vCPU:Local disk ratio must be at least 1:32. For example, for 10 vCPU, you need a disk with a capacity of at least 320 GB.
If these configurations do not suit your needs, you can order a custom configuration. Create a ticket and specify the resource ratio:
- vCPU:RAM — at least 1:4;
- vCPU:RAM:Local disk — at least 1:4:32.
Processors
Available processors differ between configuration lines. The processor frequency affects the speed of processing user queries, executing complex algorithms, and performing data operations. At 100% cloud server load, the processor operates using Turbo Boost technology. Since the processor is emulated, testing will show a lower frequency.
To view the availability of configuration lineups in the regions, see the Managed Databases availability matrix.
ClickHouse® is a registered trademark of ClickHouse, Inc. https://clickhouse.com.