All Products
Search
Document Center

Data Management:Release notes

Last Updated:Feb 27, 2025

This topic describes the release notes for Data Management (DMS) and the built-in Data Disaster Recovery module and provides links to the relevant references.

Data Disaster Recovery provides the backup and restoration features for ApsaraDB RDS, PolarDB, ApsaraDB for MongoDB, Tair (Redis OSS-compatible), and AnalyticDB for PostgreSQL. The following tables describe the release notes of the features for these databases.

Release notes

2024

November

Feature

Category

Description

References

Normal Data Modify

New feature

The rollback ticket generation feature is supported to quickly generate rollback tickets to restore original data.

Normal Data Modify

October

Feature

Category

Description

References

Notification

New feature

Lark of International Edition is supported as a notification method.

Notebook

New feature

The historical execution tasks of Spark in Notebook resources can be viewed.

Manage Notebook resources

September

Feature

Category

Description

References

Data Disaster Recovery

New feature

The database and table restoration feature is supported for ApsaraDB RDS for MySQL Cluster Edition instances. You can start a database and table restoration task for an instance based on the instance ID on the Backup and Restoration page in the ApsaraDB RDS console.

Restore individual databases and tables

Knowledge base

New feature

The knowledge base management feature of DMS allows you to manually supplement business knowledge. The supplemented knowledge helps Copilot better understand and answer questions and implement automated decision-making and reasoning.

Knowledge base management

Policy management

New feature

DMS allows you to precisely configure the permissions, such as the query and change permissions, on data resources at different granularities, such as database instances and databases. You can also configure the operation permissions on DMS features.

Manage policies

Role management

New feature

DMS allows you to create custom roles and grant permissions to the roles. You can manage the resources and features of DMS by role in a fine-grained manner.

Manage roles

July

Feature

Category

Description

References

Security rules

New feature

The following rules are supported on the SQL Correct tab: the rule that specifies whether to skip the verification on the number of affected rows in the precheck for a data change ticket and the rule that specifies whether to submit a data change ticket if the specified number of affected rows is inconsistent with the result of the row count verification.

SQL Correct

May

Feature

Category

Description

References

Instance management

New feature

You can register an instance and modify the instance information in DMS. You can also log on to the database by using the ApsaraDB RDS secret created in Key Management Service (KMS).

Register an Alibaba Cloud database instance

When a database is registered in DMS, the Instance Source parameter can be set to Open Source MyBase Database.

Register a database hosted on a third-party cloud service or a self-managed database

March

Feature

Category

Description

References

SQL Console

Optimized feature

If you have any permissions on a database or table, you can adjust the column width of the table in the execution result section of the SQL Console tab. This resolves the issue that the displayed table data is incomplete due to excessive columns in the table.

Manage a database on the SQLConsole tab

Database logon

New feature

DMS automatically synchronizes the instance name when you switch from the ApsaraDB RDS console to the DMS console and log on to an ApsaraDB RDS instance to which you have never logged on from DMS.

Log on to a database instance

Data Disaster Recovery

New feature

The database and table restoration feature for ApsaraDB RDS for PostgreSQL instances allows you to restore databases and tables to the original instance from a backup set or to a specific point in time without the need to restore the full data of an instance. This feature can be used in scenarios such as data restoration after accidental operations, and historical data analysis.

Restore individual databases and tables

January

Feature

Category

Description

References

Data Disaster Recovery

New feature

The retention period of a backup set in a PolarDB for PostgreSQL cluster of Standard Edition is increased from 14 days to 7,300 days.

Configure a backup policy

New feature

The retention period of a backup set in a PolarDB for MySQL cluster of Standard Edition is increased from 14 days to 7,300 days.

Configure a backup policy

New feature

The cross-region backup feature is supported for PolarDB-X 2.0 instances. The system automatically migrates full backup data and incremental backup logs from one region to another after you configure a backup policy. You can also restore the data to a database instance in the destination region. This feature meets the requirements for high availability of databases and complies with the requirements of Multi-Level Protection Scheme (MLPS).

Cross-region backup

New feature

The point-in-time restoration (PITR) feature for ApsaraDB RDS for MySQL instances is developed based on the log backup feature. After you turn on Restoration to Specific Point in Time and configure the Time Range of Specific Points in Time for Restoration parameter on the Backup Strategy tab, the system implements PITR based on the specified point in time and time range. The PITR feature resolves the issue that the restorable time range of your ApsaraDB RDS for MySQL instance is significantly shortened when the first full backup set of the instance is deleted due to expiration.

Configure the PITR feature

2023

December

Feature

Category

Description

References

Data Disaster Recovery

New feature

The backup download feature is supported for ApsaraDB RDS for PostgreSQL instances that use PL2 Enterprise SSDs (ESSD) and PL3 ESSDs.

Download backup files

New feature

The long-term backup retention feature is supported for serverless and cloud disk-based ApsaraDB RDS for MySQL instances. You can configure a retention policy for the backup files of an ApsaraDB RDS for MySQL instance. This way, the backup files are retained for a long period of time even if the ApsaraDB RDS for MySQL instance is released.

Retain backup files for a long period of time

November

Feature

Category

Description

References

Configuration item for unauthorized approval

New feature

The configuration item of allowing unauthorized users to approve tickets for workflows is added. After you enable this configuration item, you can authorize specific users who do not have the required permissions to approve the specified types or all types of tickets.

Configuration management

Data Disaster Recovery

New feature

The backup download feature for PolarDB for MySQL clusters allows you to download data in files of the following formats: CSV, SQL, and Parquet. This feature is applicable to data application scenarios such as on-premises development, test environment restoration, compliance auditing, and query analysis.

August

Feature

Category

Description

References

Unsubscription

New feature

You can unsubscribe from the billable features provided by the new version of DMS in the DMS console or on the Unsubscribe page in User Center.

Unsubscribe from billable features

Data Disaster Recovery

New feature

The cross-region backup and restoration feature is supported for ApsaraDB RDS for SQL Server instances for which Transparent Data Encryption (TDE) is enabled. This improves the backup and restoration capabilities provided by Data Disaster Recovery.

Optimized feature

The tabs on the Backup and Restoration page for ApsaraDB RDS for PostgreSQL, ApsaraDB RDS for SQL Server, and ApsaraDB RDS for MariaDB TX instances are adjusted. The Data Backup and Log Backup tabs are merged into the Base Backups tab. The original Backup Settings tab is renamed Backup Strategy. The features on the tab remain unchanged. The adjustments further simplify and optimize the backup and restoration management page and improve user experience.

New feature

The backup and restoration features are supported for AnalyticDB for PostgreSQL V7.0 instances.

July

Feature

Category

Description

References

Approval process configuration

New feature

DMS supports transferring an approval ticket to others and adding an approval node before or after an approval node.

Configure approval processes

Data Disaster Recovery

Optimized feature

The database and table restoration feature is supported for cost-effective ApsaraDB RDS for MySQL and YiTian ApsaraDB RDS for PostgreSQL instances that use the Advanced RISC Machine (ARM) architecture.

Optimized feature

The data restoration efficiency for ApsaraDB for MongoDB instances is improved by nearly 20 times. The data restoration, download, and playback are accelerated by using storage gateways.

Restore data

Optimized feature

The database and table restoration feature is supported for PolarDB for MySQL clusters that contain millions of tables.

Method 1 for database and table restoration: Restore data from a backup set

New feature

The secondary database preferred mode is supported for RDS instances that run RDS Cluster Edition. You can configure the system to perform physical backups on secondary RDS instances. This reduces the I/O loads on primary RDS instances and improves instance performance and stability.

Back up an ApsaraDB RDS for SQL Server instance

June

Feature

Category

Description

References

Task orchestration

New feature

When the scheduling cycle is set to Hour, you can schedule tasks within a specific time range.

Overview

Data Disaster Recovery

Optimized feature

  • The permissions on the links for downloading the backup files of released ApsaraDB RDS for MySQL instances are optimized.

  • The permissions on the links for downloading the log and data backup files of ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, and ApsaraDB RDS for SQL Server instances are optimized.

May

Feature

Category

Description

References

Data archiving

New feature

The data archiving feature of DMS allows you to perform multiple operations. For example, you can regularly archive the data of large tables to other databases, delete the data from source tables, and optimize the storage usage of source tables.

Blocking of system databases in DMS

New feature

You can block system databases by configuring custom security rules in DMS. After the system databases are blocked, DMS does not collect the metadata of the blocked databases and you cannot view or search for these databases in DMS.

Block system databases in DMS

Data Disaster Recovery

New feature

The backup and restoration feature based on PolarStore and Elastic Compute Service (ECS) is supported for PolarDB for PostgreSQL clusters.

Backup and restoration

Price reduction

The unit price for network traffic that is generated during cross-region backups is reduced for ApsaraDB RDS for MySQL, ApsaraDB RDS for SQL Server, and ApsaraDB RDS for PostgreSQL instances, and PolarDB for MySQL clusters.

April

Feature

Category

Description

References

Management of data archived to dedicated storage

New feature

Archived data can be deleted from dedicated storage.

Delete the archived data from dedicated storage

Data Disaster Recovery

Restoration

The fast restoration feature is supported for individual databases and tables in ApsaraDB RDS for PostgreSQL instances that use standard SSDs or ESSDs. You can restore databases and tables to the original instance from a backup set or to a specific point in time without the need to restore the full data of an instance. This feature can be used in scenarios such as data restoration after accidental operations, and historical data analysis.

Restore individual databases and tables

New feature

The fast restoration feature is supported for individual databases and tables in ApsaraDB RDS for PostgreSQL instances that use standard SSDs or ESSDs. You can restore databases and tables to the original instance from a backup set or to a specific point in time without the need to restore the full data of an instance. This feature can be used in scenarios such as data restoration after accidental operations, and historical data analysis.

Use the high-frequency physical backup feature for an ApsaraDB RDS for MySQL instance

February

Feature

Category

Description

References

Instance management

Optimized feature

  • The Add Instance dialog box is optimized from the following aspects:

    • Data sources are divided into the following two types: Alibaba Cloud databases such as an ApsaraDB RDS for MySQL instance, and databases hosted on third-party clouds or self-managed data warehouses such as a ClickHouse data warehouse.

    • You can view the description message that appears if you move the pointer over a control mode. The message indicates the description or scenarios of the control mode.

  • In the instance list, you can filter instances by instance source.

Data Disaster Recovery

New feature

The fast restoration feature is supported for individual databases and tables in ApsaraDB RDS for MySQL instances that use standard SSDs or ESSDs. You can restore databases and tables to the original instance from a backup set or to a specific point in time. This feature can be used in scenarios such as data restoration after accidental operations, and historical data analysis.

Restore individual databases and tables

January

Feature

Category

Description

References

Classification and grading templates

Feature update

This feature is fully released with a number of interaction updates.

Manage DMS classification and grading templates

Data Disaster Recovery

New feature

PolarDB for MySQL allows you to use Data Disaster Recovery for logical backup.

Backup method 3: Use Data Disaster Recovery for logical backup

2022

December

Feature

Category

Description

References

Instance registration

Optimized feature

Instances of the Lindorm HBase database type can be added to DMS.

Sensitive data management

New feature

DMS classification and grading templates can be configured and the description of detection rules can be modified.

Log export

New feature

Operation logs can be exported to Alibaba Cloud Simple Log Service (SLS) in the DMS console. This allows you to perform statistical analysis on the DMS operation logs in Log Service.

Export operation logs of DMS to Simple Log Service

Data Disaster Recovery

Optimized feature

The cross-region backup feature is optimized. If your ApsaraDB RDS instance runs SQL Server 2017 EE on RDS Cluster Edition and the snapshot backup feature is enabled for the instance, you can use the cross-region backup feature to back up data from one region to another in the ApsaraDB RDS console for regulatory compliance or disaster recovery.

Use the cross-region backup feature for an ApsaraDB RDS for SQL Server instance

New feature

The cross-region backup feature is supported for ApsaraDB RDS for MySQL instances that use standard SSDs or ESSDs. You can use the cross-region backup feature to back up data from one region to another for regulatory compliance or disaster recovery.

Use the cross-region backup feature for an ApsaraDB RDS for MySQL instance

August

Feature

Category

Description

References

Simple mode

New feature

The DMS console in simple mode is tidy and easy to navigate. You can search for database instances without the need to switch to the console homepage.

Simple mode

Data Disaster Recovery

New feature

The advanced download feature is supported for ApsaraDB RDS for MySQL instances. You can use this feature to create advanced download tasks by point in time or backup set. You can set the Download Destination parameter to URL or directly upload the downloaded data to your OSS bucket to facilitate data analysis and offline archiving.

Download backup files

New feature

The high-frequency backup feature is supported for ApsaraDB for MongoDB replica set instances that use ESSDs. You can specify a backup frequency that ranges from 15 minutes to 12 hours for your ApsaraDB for MongoDB instance to increase the backup frequency.

Configure high-frequency backup for an instance

July

Feature

Category

Description

References

Data watermark

New feature

Watermark embedding and watermark extraction are supported.

  • Watermark embedding: Identification information is embedded into data or a file as a watermark to identify the data or file.

  • Watermark extraction: DMS provides the watermark extraction feature that allows you to check whether files are embedded with unperceivable watermarks.

Use data watermarks

Permission template

New feature

Resources such as instances, databases, and tables that have the same business attributes can be added to a permission template, and one or more users can be authorized to manage the resources in the permission template. By using a permission template, you no longer need to find the required users and resources one by one from a large number of users and resources or perform repeated operations to authorize the users to manage the resources.

Create a permission template

Data Disaster Recovery

New feature

The high-frequency physical backup feature is supported for ApsaraDB RDS for MySQL instances. You can enable the high-frequency physical backup feature for your ApsaraDB RDS for MySQL instance to increase the backup frequency.

Use the high-frequency physical backup feature for an ApsaraDB RDS for MySQL instance

New feature

The high-frequency snapshot backup feature is supported for ApsaraDB RDS for PostgreSQL instances. You can specify a backup frequency that ranges from 15 minutes to 12 hours for your ApsaraDB RDS for PostgreSQL instance to increase the backup frequency.

Use the high-frequency snapshot backup feature for an ApsaraDB RDS for PostgreSQL instance

March

Feature

Category

Description

References

Service discontinuation of the previous version of DMS Personal Edition

Discontinuation

The previous version of DMS Personal Edition is discontinued and replaced by DMS console V5.0 after July 31, 2023.

[Notice] Service discontinuation of the old version of DMS Personal Edition on July 31, 2023

Service discontinuation of the previous version of the DMS console

Discontinuation

The previous version of the DMS console is discontinued and replaced by DMS V5.0 console V5.0 after March 31, 2022.

What is DMS?

Data Disaster Recovery

New feature

The high-frequency snapshot backup feature is supported for ApsaraDB RDS for MySQL instances that use standard SSDs or ESSDs. You can specify a backup frequency that ranges from 15 minutes to 12 hours for your ApsaraDB RDS for MySQL instance to increase the backup frequency.

Use the high-frequency snapshot backup feature

New feature

The features of advanced download and data restoration from a downloaded backup set are supported for ApsaraDB RDS for MySQL instances that use standard SSDs or ESSDs. You can convert backup files to CSV files, download the backup files, and then restore the downloaded backup files to your on-premises MySQL databases.

Download backup files

New feature

The fast restoration feature for individual databases and tables is supported for ApsaraDB RDS for MySQL instances that use local SSDs. Compared with the standard restoration feature for individual databases and tables, the fast restoration feature for individual databases and tables accelerates data restoration by 2 to 10 times for ApsaraDB RDS for MySQL instances that use local SSDs.

Restore individual databases and tables

Optimized feature

A solution is added for the issue that data backups are performed at a time beyond the specified time windows in the China (Hohhot) region and central sites.

N/A

Fixed issue

  • The issue that MySQL table partitions cannot be sorted in ascending order after schema restoration is fixed.

  • The issue of security vulnerability caused by PostgreSQL connection strings is fixed.

N/A

February

Feature

Category

Description

References

Database migration

New feature

Service solutions can be encapsulated by using the database migration feature to migrate databases, perform checks, and delete the migrated source databases. In addition, the names of destination databases can be changed, pre-migration checks or post-migration data consistency checks can be performed, and migrated source databases can be deleted. This ensures the integrity of database migration throughout the lifecycle.

Database migration

Data warehouse development

New feature

Projects can be managed by workspace, business scenario, and task flow. Data warehouses can be managed at the layer level by using the data warehouse development feature. This facilitates data warehouse management in specific business scenarios and meets the complex requirements for data warehouse development and management.

Create a workspace

Data Disaster Recovery

Fixed issue

The issue that backup sets fail to be downloaded and restored is fixed.

N/A

January

Feature

Category

Description

References

Sensitive data audit

New feature

The sensitive data audit feature is supported to record the use of sensitive data in DMS.

Audit sensitive data

Queries for the progress of a lock-free schema change task

New feature

The progress of a lock-free schema change task can be viewed.

View the progress of a lock-free schema change task

Dependency check nodes in task orchestration

New feature

Dependency check nodes can be configured to allow a task flow to depend on the result of its previous cycle or another task flow.

Configure a dependency check node for a task flow

Data Disaster Recovery

Fixed issue

  • A solution is added for the issue that a DRDS backup set loses its UNIQUE constraint.

  • The issue that a MySQL table fails to be created because the partition order does not comply with MySQL rules when MySQL data is being restored is fixed.

  • The issue that CDM-based sandbox instances do not release ZFS file systems as expected is fixed.

  • The issue that TAR files fail to be downloaded and the IDs of ECS instances fail to be obtained after CDM-based sandbox instances restart in the China (Hangzhou) region is fixed.

  • The issue that the value of the live_mount parameter is invalid is fixed.

N/A

2021

November

Feature

Category

Description

References

Custom layout and style of the DMS console

New feature

The skin and interaction interface of the DMS console can be configured.

Customize the layout and style of the DMS console

Support for Object Storage Service (OSS) buckets

New feature

An OSS bucket can be registered in DMS. You can use an OSS bucket as the destination of data output nodes in offline data integration tasks or create cross-database Spark SQL nodes for the OSS bucket in the task orchestration module.

Register an OSS bucket

Data Disaster Recovery

Iterated feature

You are charged for the downloads of backup sets over the Internet.

Network traffic fees

October

Feature

Category

Description

References

Updates and commercial usage for the sensitive data protection feature

Iterated feature

The sensitive data protection feature is updated and released as a commercial feature. You can use the sensitive data protection feature to scan the metadata of databases to detect, mask, and manage sensitive data.

Overview

September

Feature

Category

Description

References

Support for Hologres and Db2 databases

New feature

DMS allows you to manage Hologres and Db2 databases and user permissions on the databases.

Supported database types and features

Conditional branch nodes in task orchestration

New feature

A conditional branch node can be used to perform conditional judgment in a task flow. This allows the task flow to run specific subsequent tasks based on specific conditions.

Configure a conditional branch node

SQL assignment nodes in task orchestration

New feature

An SQL assignment node can read data and assign the data to an output variable of the node.

Configure an SQL assignment node

Data Disaster Recovery

New feature

Self-managed NAS file systems that use the Server Message Block (SMB) protocol can be added to Data Disaster Recovery as storage pools.

Add and remove a storage pool

August

Feature

Category

Description

References

DMS V5.0

Iterated feature

The DMS console V5.0 classifies features based on scenarios and integrates the features of Data Transmission Service (DTS).

Switch between the previous and new versions of the DMS console

Data Disaster Recovery

New feature

The disaster recovery feature is further enhanced to allow you to create a privileged account in a sandbox instance.

Use the emergency recovery feature for an ApsaraDB RDS for MySQL instance

July

Feature

Category

Description

References

Offline integration

New feature

The offline integration feature provides a low-code tool that you can use to develop data processing tasks. You can combine various task nodes to form a data stream and configure periodic scheduling to process or synchronize data.

Overview

DevOps

New feature

The DevOps feature allows you to customize R&D processes, advance R&D processes stage by stage, and control the quality of R&D processes.

Data Disaster Recovery

New feature

Backup sets can be deleted.

Delete a backup set

June

Feature

Category

Description

References

Data Disaster Recovery

Optimized feature

The emergency recovery feature is enhanced.

Use the emergency recovery feature for a self-managed MySQL database

Optimized feature

For emergency instances, the reading of binary log files is accelerated at the backend, and snapshots can be generated based on binary log files without processing at the backend.

N/A

Fixed issue

  • The issue that the error message "dataset not exist" is displayed when you release a sandbox instance multiple times is fixed.

  • The issue of failing to restore a data source based on a backup schedule is fixed.

  • The issue of failing to specify the port number of a public endpoint in the console when you restore databases is fixed.

  • The issue of failing to obtain valid instance information and remap information when you perform logical backups for PolarDB for Oracle databases is fixed.

N/A

May

Feature

Category

Description

References

Script nodes in task orchestration

New feature

Script nodes and Database Gateway can be used to schedule scripts in a unified manner.

Configure a script node

PostgreSQL database management

New feature

DMS allows you to manage ApsaraDB RDS for PostgreSQL and AnalyticDB for PostgreSQL databases and user permissions on the databases.

Data Disaster Recovery

New feature

In addition to the built-in storage provided by Data Disaster Recovery, Data Disaster Recovery supports self-managed storage pools, such as OSS and NAS storage pools, to better manage backup data.

What is a storage pool?

Fixed issue

  • The issue of failing to delete expired backup sets is fixed.

  • The issue of failing to redeploy machines due to the soft deletion of a backup gateway is fixed.

  • The issue of failing to enable incremental backup for ApsaraDB RDS for MariaDB databases is fixed.

N/A

April

Feature

Category

Description

References

Dameng (DM) database

New feature

DMS allows you to perform various operations on a DM database. For example, you can import, query, change, export, and visualize data for a DM database. In addition, you can provide data services based on a DM database.

Supported database types and features

Category

New feature

The category feature can be used to classify tables. This helps DMS administrators, developers, and O&M engineers better manage and use tables.

Use the asset category feature

Tables page

Optimized feature

DMS allows you to view the technical metadata, business metadata, and management metadata of a table on the Tables page. Technical metadata includes the database instance and database to which the table belongs and the table name and fields. Business metadata includes the business description and tags of the table. Management metadata includes the owner of the table and your permissions on the table. DMS also allows you to perform specific management operations on the table on the Tables page. The Tables page can help you fully understand and efficiently use the data of a table.

Manage table details

Schema read-only role

New feature

In addition to the permissions that a regular user has, a user who is assigned the schema read-only role can query the metadata of a database instance, a database, and a table to view the details of the table or export the schemas of the database. However, the user must apply for the query permissions to query data.

System roles

Data Disaster Recovery

New feature

Full backup and synthetic backup are supported to reduce backup costs and resource overheads.

Create a true incremental-forever backup for an Oracle database

New feature

  • The parameter files that are used to create Oracle Windows services and Oracle standalone databases are restored.

  • A backup gateway can be configured at the frontend to disable databases before data is restored and enable databases after data is restored.

N/A

New feature

Data Disaster Recovery is available on Alibaba Gov Cloud and in the China (Heyuan) and China (Ulanqab) regions of the Alibaba public cloud.

N/A

Fixed issue

The issue of the repeated creation of incremental tasks for ApsaraDB for MongoDB instances that support primary/secondary switchover is fixed.

N/A

March

Feature

Category

Description

References

Task flow management

Optimized feature

After you configure or modify a task flow, you must publish the latest task flow to an online environment. This effectively prevents the modified task flow from being published before the modifications to the task flow are confirmed.

Publish or unpublish a task flow

SQL result set export

New feature

SQL result sets can be exported at regular intervals. This way, you can configure the system to automatically export relevant data after specified operations are performed.

Export SQL result sets

Syntax prompts for Redis on the SQL Console tab

Optimized feature

The syntax prompts for Redis are supported on the SQL Console tab. In addition, DMS allows you to enable the super SQL mode for MongoDB and Redis databases.

Overview

SQL review

Optimized feature

You can use the SQL review feature to review the submitted SQL statements and obtain optimization suggestions. This prevents the SQL statements that do not use indexes or do not conform to standards from being published to an online environment. This also reduces the risk of SQL injection attacks.

SQL review

Data analysis

Optimized feature

The data analysis feature allows you to go to the details page of a task in DTS within a few clicks.

Create data warehouses

Data Disaster Recovery

New feature

The multi-level storage pool feature is supported to allow data backups in Data Disaster Recovery to be automatically replicated across storage pools. You can configure backup policies that use multi-level storage pools to manage on-premises storage pools and storage pools in the cloud, and share data backups among storage pools. This enhances security and reduces backup costs.

Note

As of June 20, 2022, the public preview of the multi-level storage pool feature of Data Disaster Recovery ends. The feature is available only for users who have joined the public preview.

Notice on the end of the public preview of the multi-level storage pool feature

Optimized feature

  • The DescribeRegions operation is optimized. You can call this operation to query the regions in which Data Disaster Recovery is supported. This improves availability.

  • The restoration feature is optimized so that a sandbox instance can be restored to the point in time of the latest snapshot when the sandbox instance cannot be restored to a specific point in time.

  • Automatic access to data sources is disabled, which does not affect the backup set synchronization feature of the backup schedules that have been synchronized.

N/A

Fixed issue

Configuration issues are fixed in the Malaysia (Kuala Lumpur) region.

N/A

February

Feature

Category

Description

References

Data analysis

New feature

The data analysis feature can be used to create an AnalyticDB for MySQL V3.0 data warehouse with a few clicks from an ApsaraDB RDS for MySQL database. You can create reports, run recurring tasks, and visualize data in the data warehouse.

Create data warehouses

Data archiving

New feature

The data archiving feature can be used to periodically archive the data that is stored in ApsaraDB RDS for MySQL or PolarDB for MySQL databases to OSS.

Archive data to OSS buckets connected to Data Disaster Recovery

January

Feature

Category

Description

References

Risk audit reports

New feature

DMS allows you to generate risk audit reports for database instances. Risk audit reports collect and assess various risks that are involved in the O&M of database instances. Risk audit reports also provide optimization suggestions for you to improve the security and stability of your instances.

Generate a risk audit report

Schema version management

New feature

The schema versions of a table in a database can be saved to DMS. After you change the schema of a table in a database in DMS, DMS adds the latest schema to the schema version list of the database. You can download and compare schema versions and restore an earlier schema version in the schema version list.

Manage schema versions

Super SQL mode

New feature

After you enable the super SQL mode as a DMS administrator or a database administrator (DBA), all SQL statements that you execute on the SQL Console tab are executed without being limited by security rules.

Use the super SQL mode

SQL review

Optimized feature

You can use the SQL review feature to review SQL statements that perform lockless changes and obtain optimization suggestions. This feature is available for the instances that are managed in Flexible Management mode.

SQL review

Data factory

Optimized feature

The SQL editor that is used to edit the code of task nodes in task orchestration and data warehouse development is optimized. The SQL editor supports intelligent code completion.

Configure a task flow

Data Disaster Recovery

End of the public preview

As of January 28, 2021, the public preview of the sandbox feature provided by Data Disaster Recovery ends. After January 28, 2021, you are charged for the use of the sandbox feature.

  • If the sandbox feature is enabled for backup schedules after 00:00:00 on January 28, 2021 (UTC+8), you are charged based on the billing rules in the Sandbox fees topic.

  • If the sandbox feature is enabled for backup schedules before 00:00:00 on January 28, 2021 (UTC+8), Data Disaster Recovery extends the validity period of public preview to 00:00:00 on March 1, 2021 (UTC+8).

    To continue using the sandbox feature, enable the sandbox feature in the Data Disaster Recovery console.

Sandbox overview

New feature

MySQL databases can be backed up based on binary logs by using the physical backup method. This helps you achieve a recovery point objective (RPO) within seconds.

Back up binary logs of a MySQL database

2020

December

Feature

Category

Description

References

Features in the top navigation bar

New feature

Your frequently used features can be added to the top navigation bar. This allows you to use these features with ease.

Customize the layout and style of the DMS console

Shadow table synchronization

New feature

DMS provides the shadow table synchronization feature to automatically create a shadow table based on the schema of a source table. DMS generates the name of the shadow table by attaching a prefix or suffix to the name of the source table. You can use this feature for end-to-end stress testing.

Create shadow tables for synchronization

Validity periods for the maximum number of queries and the maximum number of rows that can be queried

Optimized feature

When you manage users, you can configure the validity periods for the maximum number of queries that a user can perform and the maximum number of rows that can be queried. This allows you to restrict queries in a short time period.

Manage users

SQL templates

Optimized feature

SQL templates are provided in the right-side panel of the SQL Console tab. A large number of common scripts such as SQL statements, programmable objects, and functions are provided.

Overview

User permissions on MariaDB databases

New feature

DMS allows you to manage user permissions on MariaDB databases.

Manage user permissions on MySQL databases

User permissions on AnalyticDB for MySQL databases

New feature

DMS allows you to manage AnalyticDB for MySQL databases and user permissions on the databases.

Manage user permissions on MySQL databases

Schema design

Optimized feature

The GUI that is used for schema design is improved.

Design schemas

Task orchestration

Optimized feature

The status statistics about task flows and the task flow list can be viewed on the homepage of the Task Orchestration tab. In addition, a task flow can be created by using a template.

Configure a task flow

Notification

Optimized feature

By default, the notification feature is enabled. This allows relevant contacts to receive notifications at the earliest opportunity.

Manage notification rules

November

Feature

Category

Description

References

Operation audit

Optimized feature

DMS provides the operation audit feature in addition to the basic features of operation log management. You can use the operation audit feature to view and manage tickets, logon information, operation logs, and the SQL statements that were executed on the SQL Console tab. You can also use the operation audit feature to troubleshoot database issues with ease and audit the operations that were performed on databases.

Audit operations

Optimization suggestions for the SQL review feature

New feature

After you submit SQL statements for data changes or on the SQL Console tab, DMS reviews the submitted SQL statements based on the specifications in security rules and provides optimization suggestions. This can help you review SQL statements and optimize the submitted SQL statements before data changes are submitted. This can also prevent database exceptions from being caused by SQL statements that have potential issues.

SQL review optimization

Support for ApsaraDB for Lindorm and ApsaraDB for Cassandra databases

New feature

DMS allows you to manage ApsaraDB for Lindorm and ApsaraDB for Cassandra databases in a centralized manner. You can register ApsaraDB for Lindorm and ApsaraDB for Cassandra instances in DMS. You can also manage permissions and sensitive fields, query data by executing SQL statements, and change data in the databases.

Supported database types and features

Alibaba Cloud Security Token Service (STS) token

New feature

STS can be used to assign a token to a self-managed O&M platform. Then, the platform can access databases that are managed in DMS without logon.

N/A

Data Disaster Recovery

New feature

Batch operations can be performed on data sources. For example, add multiple data sources at a time, back up databases from multiple data sources, and manage multiple data sources at a time. Multiple backup tasks can be managed at a time based on backup policies and logical groups.

New feature

Recovery drills are supported to verify the integrity of backup data and the reliability of the disaster recovery system.

Perform disaster recovery drills

October

Feature

Category

Description

References

Data import

New feature

DMS allows you to select the import mode, the file type, or the execution policy as needed. This can improve the efficiency of data import.

Import data

DMS Database Lab on the Alibaba Cloud International site (alibabacloud.com)

New feature

DMS Database Lab is available on the Alibaba Cloud International site (alibabacloud.com).

N/A

Data Disaster Recovery

New feature

MariaDB 10.0 and 10.3 databases can be backed up, including ApsaraDB RDS for MariaDB TX instances and self-managed MariaDB databases.

Back up a MariaDB database by using logical backup

September

Feature

Category

Description

References

Notification

New feature

  • DMS supports a variety of notification methods, such as text messages, emails, and Webhook.

  • DMS can send notifications about the status updates of tickets and task flows to users.

Manage notification rules

Data Disaster Recovery

Optimized feature

Backup sets can be queried by using built-in Data Lake Analytics (DLA), without the need to restore databases.

Overview

Optimized feature

The data of the server that hosts your databases can be backed up in a centralized manner. The data includes logs, programs, and attachments.

Back up files

New feature

DMS allows you to create Data Disaster Recovery sandbox instances to make physical backup data available for use.

Sandbox overview

August

Feature

Category

Description

References

Metadata access control

New feature

After you enable the metadata access control feature for an instance or a database, only authorized users can view metadata of the instance or database. This further enhances data security.

Metadata access control

Sharing of tickets and the SQL Console tab of databases

Optimized feature

DMS allows you to share the SQL Console tab of a database or a ticket with other users by generating a share link. This enhances the efficiency of a business team.

Share the SQLConsole tab or a ticket

Database grouping

New feature

DMS allows you to add databases that are of the same engine type and deployed in the same environment to a database group. Then, you can apply a data change or a schema change to the databases at a time.

Database grouping