This topic describes the release notes for ApsaraDB for ClickHouse and provides links to relevant references.
For more information about the release notes for open source ClickHouse, see Changelog.
April 2023
Feature | Description | References |
Data backup disabling | New feature ApsaraDB for ClickHouse allows you to disable the data backup feature for an ApsaraDB for ClickHouse cluster. |
March 2023
Feature | Description | References |
Scheduled restart of clusters | New feature ApsaraDB for ClickHouse allows you to restart an ApsaraDB for ClickHouse cluster at a scheduled time. | |
Tag management | New feature ApsaraDB for ClickHouse allows you to add tags to an ApsaraDB for ClickHouse cluster. | |
ZooKeeper configuration | New feature ApsaraDB for ClickHouse clusters provide 4-core 8 GB ZooKeeper for free by default. | None |
January 2023
Feature | Description | References |
Monitoring and alerting | New feature The following metrics are added:
| |
Upgrade of the major engine version | New feature The major engine version of ApsaraDB for ClickHouse clusters can be upgraded by migrating data between the clusters. |
December 2022
Feature | Description | References |
Release and mounting of a Classic Load Balancer (CLB) instance | New feature A CLB instance can be released and mounted for an ApsaraDB for ClickHouse cluster that is created after December 1, 2021. | |
Account management | New feature A database account of an ApsaraDB for ClickHouse cluster can be configured by executing SQL statements. |
October 2022
Feature | Description | References |
V22.8 |
|
September 2022
Feature | Description | References |
Parameter configuration | New feature The configuration of ApsaraDB for ClickHouse clusters that are created after December 1, 2021 can be modified in the config.xml file, and the change history can be queried. |
August 2022
Feature | Description | References |
Update of the minor engine version | New feature The minor engine version of ApsaraDB for ClickHouse clusters that are purchased after December 1, 2021, can be updated. An update of the minor engine version enhances performance, introduces new features, and fixes bugs. | |
Setting of a maintenance window | New feature The maintenance window can be set for one or more ApsaraDB for ClickHouse clusters at the same time. The clusters are upgraded within the set maintenance window to ensure the stability of the clusters. |
May 2022
Feature | Description | References |
Monitoring and alerting |
|
April 2022
Feature | Description | References |
Data backup and data restoration | New feature ApsaraDB for ClickHouse clusters of V20.3, V20.8, and V21.8 support data backup and data restoration. |
January 2022
Feature | Description | References |
HTTPS | New feature HTTPS can be used to encrypt transmitted data. | |
MaterializeMySQL engine upgrade |
| None |
TCP keepalive | New feature By default, the TCP keepalive feature is enabled to ensure connection reliability. | None |
December 2021
Feature | Description | References |
MaterializeMySQL engine upgrade | New feature The MaterializeMySQL engine supports the DECIMAL data type. | None |
November 2021
Feature | Description | References |
V21.8 |
| None |
October 2021
Feature | Description | References |
Preservation of binary log files | The enable_binlog_reserved parameter can be set to enable the preservation feature for binary log files in the MaterializeMySQL engine. This feature prevents data synchronization failures that occur when binary log files are deleted. This helps improve the stability of the MaterializeMySQL engine. |
August 2021
Feature | Description | References |
Cluster restart | ApsaraDB for ClickHouse allows you to restart a cluster. If an ApsaraDB for ClickHouse cluster becomes unavailable or the cluster must be restarted to fix issues, you can restart the cluster. | |
Optimization for monitoring | The layout of the monitoring page is optimized to improve user experience. | None |
ApsaraDB RDS for MySQL analytic instance | ApsaraDB RDS for MySQL analytic instances are supported by ApsaraDB for ClickHouse. You can synchronize data from an ApsaraDB RDS for MySQL instance to an ApsaraDB for ClickHouse cluster. This helps you analyze business data in a centralized manner. |
July 2021
Feature | Description | References |
Data migration between ApsaraDB for ClickHouse clusters | The data migration feature is available in the ApsaraDB for ClickHouse console. You can use this feature to migrate data between ApsaraDB for ClickHouse clusters of the same engine version or from a cluster of an earlier version to a cluster of a later version. |
May 2021
Feature | Description | References |
Multiple scale-out methods | Simple scale-out is supported. You can select one of the following scale-out methods:
| Modify the configurations of an ApsaraDB for ClickHouse cluster |
MaterializeMySQL engine upgrade |
| |
Performance optimization for horizontal scaling | clickhouse-copier is optimized to improve the efficiency of horizontal scaling. | Modify the configurations of an ApsaraDB for ClickHouse cluster |
March 2021
Feature | Description | References |
Data backup and data restoration | The data backup and data restoration feature is available. This feature prevents data loss and improves data security. |
February 2021
Feature | Description | References |
Tiered storage of hot data and cold data | Cold data and hot data can be automatically migrated. This reduces storage costs by more than 80% and does not degrade performance. | |
PL2 and PL3 enhanced SSDs (ESSDs) | PL2 and PL3 ESSDs can be used to store data. This improves I/O throughput by several times. | None |
Disk encryption | All data on data disks is encrypted based on block storage. If the data is leaked, unauthorized users cannot decrypt the data. This ensures data security. |
November 2020
Feature | Description | References |
China (Hohhot) and China (Hong Kong) regions available | N/A | None |
Optimization of log shipping | Log data in Log Service can be shipped to ApsaraDB for ClickHouse for real-time analytics. |
October 2020
Feature | Description | References |
China (Zhangjiakou), China (Chengdu), and Japan (Tokyo) regions available | N/A | None |
Account management and permission management on databases and data dictionaries | The features for managing accounts and permissions on databases and data dictionaries are available in the ApsaraDB for ClickHouse console. After you log on to the ApsaraDB for ClickHouse console, you can create accounts and change the passwords of the accounts. You can also grant the permissions on databases and data dictionaries to new users and modify the permissions on databases and data dictionaries for existing users. | Manage database accounts of an ApsaraDB for ClickHouse cluster |
Change of global parameter values | Values of global parameters can be changed in the ApsaraDB for ClickHouse console. The change takes effect after your cluster is restarted. |
August 2020
Feature | Description | References |
Balanced data distribution during a scale-out operation | Data is evenly distributed when nodes are added to a cluster. This prevents data skew issues. | None |
Query management | Query management is supported. Slow SQL queries can be identified, and running queries can be interrupted. | |
Specification of 4 cores and 16 GB memory | The specification of 4 cores and 16 GB memory is added to improve the processing capability of single nodes. | |
Data dictionaries | Data dictionaries can be configured in the ApsaraDB for ClickHouse console. If constant data exists or tables that store business data can be split into fact tables and dimension tables, data dictionaries can be used as a substitute for the dimension tables. This allows you to query the data dictionaries to obtain dimension data and improves query efficiency. | |
Resource queue | Resource queues are used to resolve the following issue that may occur in open source ClickHouse: A single large query that consumes a large number of resources can cause an instance to break down. |
July 2020
Feature | Description | References |
Integration with Quick business intelligence (BI) | ApsaraDB for ClickHouse clusters can be added as data sources in Quick BI to build BI systems. |
June 2020
Feature | Description | References |
V20.3 | ApsaraDB for ClickHouse V20.3.10.75 is released to fix engine bugs and enhance stability. | None |
Real-time data migration or synchronization from MySQL databases | Data in MySQL databases can be migrated or synchronized to ApsaraDB for ClickHouse clusters in real time. This allows you to interact with MySQL databases and analyze business data in real time. | |
Online log shipping and analytics | The online log shipping and analytics feature is supported. Enterprise users need to only create shipping tasks in the ApsaraDB for ClickHouse console and ship behavioral log data from Log Service to ApsaraDB for ClickHouse. This allows you to use ApsaraDB for ClickHouse to analyze log data based on multiple dimensions. |
May 2020
Feature | Description | References |
Integration with Data Management (DMS) | ApsaraDB for ClickHouse is integrated with DMS. This allows you to manage databases and tables, query data, and orchestrate and schedule SQL tasks online. | None |
February 2020
Feature | Description | References |
New specifications | The C4, C24, C64, and C104 specifications are added. HTTP ports are enabled. |