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 a portion of the disk space is reserved for service needs and is unavailable for hosting databases. Read more in the instruction Using disk space in a ClickHouse® cluster.
You can select the configuration for each node group when creating a ClickHouse® managed database cluster. After a cluster is created, you can change the node group configuration. Read more in the instruction 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 DBMSs. 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 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 load profiles that are compute-intensive. 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 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 load profiles that are cache-intensive. For example, if the database performs multiple, rarely repeated queries to 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 (in ru-9, ru-2, ru-8, ke-1 pools) or AMD EPYC 9474F (in ru-3, ru-7, uz-1 pools) processors are used. 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 are used. You can view the disk performance and throughput 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 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, 10 vCPU requires 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, 10 vCPU requires a disk 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 vary across configuration lines. The processor frequency affects the speed of processing user queries, executing complex algorithms, and performing data operations. When a cloud server is under 100% load, the processor operates using Turbo Boost technology. Since the processor is emulated, a lower frequency will be displayed during testing.
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.