Overview

Updated on 2024-10-09 GMT+08:00

View PDF

NOTE:

This section applies only to MRS 3.2.0 or later.

ClickHouse Multi-Tenancy

The ClickHouse multi-tenancy feature enables you to manage cluster resources through the user > tenant role > resource profile management model. Currently, memory and CPU priority management is supported. The following figure shows a multi-tenancy model.

Click to enlarge

On the service configuration and tenant management pages of FusionInsight Manager, you can configure memory quotas for services, create tenants, associate ClickHouse services, bind logical clusters, set available memory and CPU priorities for tenants, and associate tenants with users. The following figure illustrates the role association between Manager and ClickHouse.

Click to enlarge

The following table lists the resource configurations supported by the current version.

Resource	Value Range	Description	Remarks
Service-level memory resource limit	0–1	Percentage of available ClickHouse memory to total server memory	For example, if the physical memory of the server is 10 GB and the limit is set to 0.9, the available memory of the ClickHouse service on the current server is 9 GB (10 GB x 0.9).
Tenant-level memory resource limit	0%–100%	Percentage of the available memory of the current tenant in ClickHouseServer	If this limit is set to 80, the total memory that can be used by the current tenant is calculated as follows: Total memory that can be used by the service x 80%
Tenant-level CPU priority	–20 to 19	NICE value of the OS associated with this value. A smaller value indicates a higher CPU priority of the process.	This feature depends on CAP_SYS_NICE of the OS. By default, this feature is disabled after the cluster is installed. To use this feature, enable it by referring to Configuring CPU Priority for ClickHouse Tenants.

Parent topic: ClickHouse Multi-Tenancy

Previous topic: ClickHouse Multi-Tenancy

Next topic: Configuring CPU Priority for ClickHouse Tenants

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot