ApsaraDB for ClickHouse:Functions and features

Category

Feature

Description

References

Smooth scaling of ApsaraDB for ClickHouse Community-compatible Edition clusters

Scale-in and scale-out

ApsaraDB for ClickHouse Community-compatible Edition supports automatic scaling with balanced data distribution. You do not need to manually migrate data.

Scale-up and scale-down

If you need to modify the configurations or size of an ApsaraDB for ClickHouse Community-compatible Edition cluster, you can scale up or scale down the cluster. This helps you achieve an optimal balance between cost and performance.

Category

Feature

Description

References

Backup and restoration

Data backup

You can create a backup and configure a scheduled backup for an ApsaraDB for ClickHouse cluster.

Data restoration

You can perform data restoration for an ApsaraDB for ClickHouse cluster.

High reliability with the master-replica architecture

Master-replica architecture supported by ApsaraDB for ClickHouse Community-compatible Edition

ApsaraDB for ClickHouse Community-compatible Edition supports the master-replica architecture.

-

Cross-zone disaster recovery

Cross-zone disaster recovery

You can implement disaster recovery across data centers in some regions.

-

Disk encryption

Disk encryption supported by ApsaraDB for ClickHouse Community-compatible Edition

ApsaraDB for ClickHouse Community-compatible Edition provides the disk encryption feature.

Whitelist management

Whitelist management

You can view and modify the whitelist of an ApsaraDB for ClickHouse cluster.

Category

Feature

Description

References

Tiered storage supported by ApsaraDB for ClickHouse Community-compatible Edition

Tiered storage of hot data and cold data

ApsaraDB for ClickHouse Community-compatible Edition clusters of V20.8 and later support tiered storage of hot data and cold data.

Tiered storage of data in a cluster of the large-storage type

You can add a disk or expand a disk for an ApsaraDB for ClickHouse Community-compatible Edition cluster of the large-storage type.

-

Category

Feature

Description

References

Version upgrade

Smooth major engine version upgrade

You can smoothly upgrade the major engine version of an ApsaraDB for ClickHouse cluster.

Automatic minor engine version update

You can configure automatic updates of minor engine versions for ApsaraDB for ClickHouse clusters.

Monitoring and alerting

Performance monitoring

You can view the performance monitoring chart of an ApsaraDB for ClickHouse cluster in the ApsaraDB for ClickHouse console.

Alert configuration

ApsaraDB for ClickHouse provides the monitoring and alerting feature for you to monitor cluster status. You can configure alert rules for key metrics. This way, you can identify abnormal metric data at the earliest opportunity. This helps you identify and handle faults.

Parameter management

Kernel parameter management

You can view and modify the kernel parameters of an ApsaraDB for ClickHouse cluster, as well as view the impacts of kernel parameters and parameter values before and after the changes in a visualized way by using the ApsaraDB for ClickHouse console.

Cluster management

Cluster property query

You can query the basic properties of an ApsaraDB for ClickHouse cluster, such as the virtual private cloud (VPC), number of nodes, storage type, and dictionary configurations.

Cluster creation and modification

You can create, delete, and restart an ApsaraDB for ClickHouse cluster. You can also modify the specifications and O&M configurations of an ApsaraDB for ClickHouse cluster.

Account management

Account management

You can create and delete a database account. You can also query and modify the information of a database account.

Account permission management

You can specify, view, and modify the permissions of a database account.

Network management

Public endpoint management

You can configure and manage the public endpoint and port number of an ApsaraDB for ClickHouse cluster.

Resource management

Resource management

You can view the resources within the current account.

-

Category

Feature

Description

References

External tables

Support Object Storage Service (OSS) external tables

You can read data from an OSS external table.

Support MaxCompute external tables

You can read data from a MaxCompute external table.

Data synchronization

Synchronize data from Kafka

You can synchronize data from a self-managed Kafka cluster deployed on an Elastic Compute Service (ECS) instance or from an ApsaraMQ for Kafka instance to an ApsaraDB for ClickHouse cluster.

Synchronize data from MySQL

You can use Data Transmission Service (DTS) to synchronize data from a MySQL database, such as a self-managed MySQL database or an ApsaraDB RDS for MySQL database, to an ApsaraDB for ClickHouse cluster.

Synchronize data from Simple Log Service

You can enable the log delivery feature to synchronize data from Simple Log Service to ApsaraDB for ClickHouse.

Data migration

Import data from Apache Flink

You can use the Java Database Connectivity (JDBC) connector of ClickHouse or Flink SQL statements to import data from Apache Flink to ApsaraDB for ClickHouse.

Import data from MySQL

You can migrate data from ApsaraDB RDS for MySQL or PolarDB for MySQL to ApsaraDB for ClickHouse to perform real-time data analysis.

Import local data

You can use clickhouse-client or a Spark program to import data from a local file to ApsaraDB for ClickHouse.