ClickHouse configurations
Node group configurations
A Managed Databases cluster for ClickHouse consists of node groups. When creating a cluster, you can select the node group configuration: the number of vCPUs, 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 choosing a configuration, keep in mind that a portion of the disk space is reserved for service needs and is unavailable for database placement. For more details, see the instructions Using disk space in a ClickHouse cluster.
The configuration for each node group can be selected when creating a Managed Databases cluster for ClickHouse. After a cluster is created, you can change the node group configuration. For more details, see the instructions Scale 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 DBMSs. We recommend using this line if you are not sure about your load profile.
Intel® Xeon® Scalable or AMD EPYC™ processors are used. You can view the processor frequency for different lines in the Processors table.
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 compute-intensive load profiles. For example, if the database performs analytical queries, multiple subqueries, or data encryption.
Intel® Xeon® Scalable or AMD EPYC™ processors are used. You can view the processor frequency for different lines in the Processors table.
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 cache-intensive load profiles. For example, if the database executes multiple, rarely repeated queries against different parts of tables.
Intel® Xeon® Scalable or AMD EPYC™ processors are used. You can view the processor frequency for different lines in the Processors table.
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 (in pools ru-3, ru-7, uz-1). You can view the processor frequency for different lines in the Processors table;
- 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 throughput of disks for different lines in the Performance and throughput table.
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 frequency for different lines in the Processors table.
You can check configuration availability in regions in the Managed Databases availability matrix. Configuration limits depend on the pool.
Local disk
Network volume
* If a configuration has more than 8 vCPUs, the vCPU:RAM ratio must be at least 1:4. For example, for 10 vCPUs, at least 40 GB of RAM is required.
** If a configuration has more than 8 vCPUs, the vCPU:local disk ratio must be at least 1:32. For example, for 10 vCPUs, a disk of at least 320 GB is required.
If these configurations are not suitable, 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 vary across configuration lines. Processor frequency affects the speed of processing user queries, executing complex algorithms, and data operations. At 100% cloud server load, the processor runs with Turbo Boost technology. Since the processor is emulated, a lower frequency will be displayed during testing.
You can view the availability of configuration lines in regions in the Managed Databases availability matrix.