Skip to content

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

  1. Log in to the Guance console
  2. Click on the [Integration] menu, select [Cloud Account Management]
  3. 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
  4. Click [Test], after a successful test click [Save]. If the test fails, check whether the related configuration information is correct and retest
  5. 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
  6. Click the [Integration] button on the cloud account details page, under the Not Installed list, find Alibaba Cloud-ClickHouse Community Compatible Edition, click the [Install] button, and install it via the installation interface.

Manual Enable Script

  1. Log in to the Func console, click [Script Market], enter the official script market, search for: guance_aliyun_clickhouse_community

  2. After clicking [Install], input the corresponding parameters: Alibaba Cloud AK ID, AK Secret, and account name.

  3. Click [Deploy Startup Script], the system will automatically create a Startup script set and automatically configure the corresponding startup script.

  4. 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

  1. 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
  2. In Guance, "Infrastructure / Custom", check if there are asset information
  3. 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

Feedback

Is this page helpful? ×