Alibaba Cloud ClickHouse¶
Alibaba Cloud ClickHouse metrics display, including service status, log traffic, operation counts, overall QPS, etc.
Configuration¶
Install Func¶
It is recommended to enable Guance Integration - Extension - Managed Func
If you deploy Func by yourself, refer to Self-deployed Func
Enable Script¶
Note: Please prepare an Alibaba Cloud AK that meets the requirements in advance (for simplicity, you can directly grant global read-only permission
ReadOnlyAccess
)
Managed Version Enable Script¶
- Log in to the Guance console
- Click on the [Integration] menu, select [Cloud Account Management]
- Click [Add Cloud Account], choose [Alibaba Cloud], and fill in the required information on the interface; if cloud account information has been configured before, skip this step
- Click [Test], after a successful test click [Save]. If the test fails, check whether the related configuration information is correct and retest
- In the [Cloud Account Management] list, you can see the added cloud accounts, click on the corresponding cloud account, and go to the details page
- Click the [Integration] button on the cloud account details page, under the
Not Installed
list, findAlibaba Cloud-ClickHouse Community Compatible Edition
, click the [Install] button, and install it via the installation interface.
Manual Enable Script¶
-
Log in to the Func console, click [Script Market], enter the official script market, search for:
guance_aliyun_clickhouse_community
-
After clicking [Install], input the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.
-
Click [Deploy Startup Script], the system will automatically create a
Startup
script set and automatically configure the corresponding startup script. -
After enabling, you can see the corresponding automatic trigger configuration in "Management / Automatic Trigger Configuration". Click [Execute] to immediately execute once without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs.
We default collect some configurations, details see the Metrics section
Configure Custom Cloud Object Metrics
Verification¶
- In "Management / Automatic Trigger Configuration", confirm whether the corresponding tasks have the corresponding automatic trigger configuration, while you can view the corresponding task records and logs to check for any abnormalities
- In Guance, "Infrastructure / Custom", check if there are asset information
- In Guance, "Metrics" check if there are corresponding monitoring data
Metrics¶
After configuring Alibaba Cloud - Cloud Monitoring, the default metric sets are as follows. You can collect more metrics through configuration Alibaba Cloud Cloud Monitoring Metric Details
Metric Id | Metric Name | Dimensions | Statistics | Unit |
---|---|---|---|---|
clickhouse_cold_storage_data_cc |
Cold Storage Usage | userId,clusterId,app,pod |
Byte | Frequency |
clickhouse_conn_usage_count_cc |
Connection Count | userId,clusterId,app,pod |
Sum | Frequency |
clickhouse_cpu_utilization_cc |
CPU Utilization | userId,clusterId,app,pod |
% | Frequency |
clickhouse_delayed_inserts_cc |
Delayed Insert Count | userId,clusterId,app,pod |
Count | Count |
clickhouse_disk_utilization_cc |
Disk Utilization | userId,clusterId,app,pod |
% | Lines |
clickhouse_distributed_files_count_cc |
Distributed Table File Count | userId,clusterId,app,pod |
Count | Lines/Minute |
clickhouse_failed_insert_query_cc |
Failed Insert Query Count | userId,clusterId,app,pod |
Count | Count |
clickhouse_failed_query_cc |
Failed Query Count | userId,clusterId,app,pod |
Count | Count |
clickhouse_failed_select_query_cc |
Failed Select Query Count | userId,clusterId,app,pod |
Count | Count |
clickhouse_http_conn_usage_count_cc |
HTTP Connection Count | userId,clusterId,app,pod |
Count | Count |
clickhouse_memory_utilization_cc |
Memory Utilization | userId,clusterId,app,pod |
% | bytes |
clickhouse_network_rx_rate_cc |
Network Throughput In Rate | userId,clusterId,app,pod |
bps | bps |
clickhouse_network_tx_rate_cc |
Network Throughput Out Rate | userId,clusterId,app,pod |
bps | bps |
clickhouse_qps_cc |
QPS | userId,clusterId,app,pod |
Count | Count |