Connect MySQL & RDS to Data Disaster Recovery - Data Management - Alibaba Cloud - Data Management

Billing

Adding a data source does not incur any charges. Billing begins only after you enable backups for the added data source.

Features

Automatic discovery of data sources
- The features of the former Database Backup Service (DBS) data source page are now available on the Disaster Recovery Data Source page to improve user experience. You can access these features in the
- Automatic discovery of disaster recovery data sources currently supports only specific database instances, including ApsaraDB RDS for MySQL, ApsaraDB RDS for SQL Server, ApsaraDB RDS for PostgreSQL, and PolarDB for MySQL. For more information, see Supported database types and features.
Manual addition of data sources

You can add MySQL databases from a self-managed database on ECS or an on-premises or third-party cloud database to Data Disaster Recovery.

Procedure

Automatic discovery

Note

Automatic data source discovery is fully automated. Your cloud database instances are added as data sources upon creation. This section explains how to view them.

Log on to the DMS console V5.0.
In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Disaster Recovery Data Source.

Note
If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Disaster Recovery Data Source.
Click the Cloud Database tab to view your added cloud databases.

ECS self-managed database

Note

This section uses a self-managed MySQL database on an ECS instance as an example to show how to manually add a data source.

Log on to the DMS console V5.0.
In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Disaster Recovery Data Source.

Note
If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Disaster Recovery Data Source.
On the Self-managed database on ECS tab, click Add Data Source.
In the Add Data Source dialog box, select the target ECS instance and click Next.

Configure the backup information.

Parameter	Description	Required
Engine type	Only self-managed MySQL databases on ECS instances are supported.	Yes
Backup method	Only logical backup is supported.	Yes
Port	The port of the self-managed database on the ECS instance. The default port for MySQL is `3306`.	Yes
Data source name	The name does not need to be unique, but a descriptive one is recommended for easier identification.	No

Click OK.

You can view the added data source on the Self-managed database on ECS tab.

On-premises and third-party cloud

Note

This section uses a MySQL database from a third-party cloud provider as an example to show how to manually add a data source.

Log on to the DMS console V5.0.
In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Disaster Recovery Data Source.

Note
If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Disaster Recovery Data Source.

Select a region at the top of the page. On the On-premises or third-party cloud databases tab, add the data source by following the instructions for your chosen backup type.

Automatic backup (product-managed)

Note

This backup type is suitable for self-managed databases, including those in data centers, on-premises, or from other cloud providers.

On the On-premises and Third-party Cloud Databases > Product Automatic Backup page, click Add Data Source.

In the dialog box that appears, configure the following parameters and click OK.

Parameter	Description
Engine type	Select the database engine type. Currently, only MySQL is supported.
Backup method	Only logical backup is supported. For more information, see Differences between logical backup, physical backup, and snapshot.
Network access type	Public (Classic Network): Accesses cloud resources over the internet by using public IP addresses. Virtual Private Cloud (VPC)/leased line: A private, isolated cloud network dedicated to your account that offers a flexible and secure environment. For more information, see What is Virtual Private Cloud (VPC). Important Add the required CIDR blocks to your source database's security settings by following the instructions in the How to Add Whitelist section of the console. This ensures that Database Backup Service can access your database for backups. For instructions, see Manually add the CIDR blocks of DBS to the whitelist of a self-managed database.
Virtual Private Cloud (VPC)/leased line	Select the target VPC. Note This parameter is required only when Network access type is set to Virtual Private Cloud (VPC)/leased line.
Source Database Endpoint	The connection endpoint of the source database.
Port	The connection port of the source database. The default port for MySQL is 3306.
Data source name	We recommend that you use a descriptive name for easy identification.

Automatic backup (user-managed)

Important

Currently, only MySQL 5.5 data sources are supported.

Click Add Data Source. In the dialog box that appears, configure the parameters, select a target backup plan, and then click Next.

Parameter	Description
Data source name	We recommend that you use a descriptive name for easy identification.
Engine type	The database engine type. Only MySQL is supported.
Engine Version	Select the version of the database engine.
Engine Parameters	{"lower_case_table_names":1}

If no backup plan is available, click Purchase Backup Plan to open the purchase page.

Parameter	Description
Product Type	Select Backup Instance (Subscription). This specifies a subscription-based backup instance; pay-as-you-go is not supported.
Region	Select the region where you want to store backup data.
Data source type	Select MySQL.
Specification	Select xmicro. For information about the free quota provided by this specification, see Backup plan specifications.
Backup method	Select Physical Backup.
Storage Space	You do not need to specify a storage capacity when creating the backup instance. You are billed for the actual data stored in the Database Backup Service (formerly DBS) built-in storage. For more information about billing, see Storage fees.
Resource group	Select the default resource group or a custom resource group to manage your backup instances.
Quantity	Purchase one backup instance for each database instance you want to back up. For example, to back up two database instances, you need two backup instances.
Subscription Duration	Select the subscription duration for the backup instance.

Upload the backup set to the specified bucket. For instructions, see Upload data for an automatic backup (user-managed).
After the upload is complete, click OK.

FAQ

Q: What do I do if the automatic addition of Database Backup Service IP address CIDR blocks to an ECS security group fails?

A: Automatic whitelisting fails if you revoke Database Backup Service's access permissions to ECS resources. In this case, you must manually add the Database Backup Service IP address CIDR blocks to the ECS instance's security group. For more information, see Manually add the CIDR blocks of DBS to the whitelist of a self-managed database.