You can manually add different databases as data sources to Data Disaster Recovery. Data Disaster Recovery automatically synchronizes ApsaraDB RDS databases to the Data Disaster Recovery console. This way, you can use Data Disaster Recovery to manage and back up data sources.
Billing
You are not charged when you add a data source. You are charged if you enable backup for the added data source.
Features
Automatically add a data source.
To improve the user experience, the Disaster Recovery Data Source page is available in Data Disaster Recovery to replace the original Data Source page. You can access the Disaster Recovery Data Source page in the DMS console.
Only the specific databases can be automatically synchronized to the Disaster Recovery Data Source page, including ApsaraDB RDS for MySQL databases, ApsaraDB RDS for SQL Server databases, ApsaraDB RDS for PostgreSQL databases, and PolarDB for MySQL clusters. For more information, see Supported database types and features.
Manually add a data source.
Data Disaster Recovery allows you to add the following data sources: self-managed MySQL databases hosted on ECS instances, on-premises MySQL databases, and MySQL databases from third-party cloud providers.
Procedure
Automatically add a data source
Your Alibaba Cloud database instances are automatically synchronized to the Disaster Recovery Data Source page after you create these database instances. This section describes how to view the Alibaba Cloud database instances that are added.
Log on to the DMS console V5.0.
In the top navigation bar, choose .
NoteIf 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 . On the Disaster Recovery Data Source page, click the Cloud Database tab to view the added databases.
Manually add a self-managed database hosted on an ECS instance
This example describes how to manually add a self-managed MySQL database hosted on an ECS instance.
Log on to the DMS console V5.0.
In the top navigation bar, choose .
NoteIf 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 . On the Self-managed Database on ECS tab, click Add Data Source.
In the Add Data Source dialog box, select the ECS instance that you want to configure and click Next.
Configure the backup information.
Parameter
Description
Required
Engine Type
Only self-hosted MySQL databases hosted on ECS instances are supported.
Yes
Backup Method
The method that is used to back up data. Set this parameter to Logical Backup.
Yes
Port
Enter the port number of the self-managed database hosted on the ECS instance. The default port number of the MySQL database is
3306.Yes
Data Source Name
We recommend that you enter a descriptive name that is easy to identify. Data source names do not need to be unique.
No
Click OK.
On the Self-managed Database on ECS tab, you can view the added data source.
Manually add an on-premises database and a cloud database from a third-party provider
This example describes how to manually add a MySQL database from a third-party provider.
Log on to the DMS console V5.0.
In the top navigation bar, choose .
NoteIf 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 . In the upper part of the page, select a region. On the On-premise Database and Cloud Database from Third-party Provider tab, add the data source based on the data source type.
Automatic backup for services
NoteAutomatic backup for services is suitable when the data source is an on-premises self-managed database, a self-managed database from a third-party provider, or a self-managed database in a data center.
Choose and click Add Data Source.
In the dialog box that appears, configure the following parameters. Then, click OK.
Parameter
Description
Engine Type
The type of the database engine. Set this parameter to MySQL.
Backup Method
The method that is used to back up data. Set this parameter to Logical Backup. For more information, see Logical backup, physical backup, and snapshot.
Network Type
Public Network (Classic Network): accesses cloud resources over the Internet by using public IP addresses.
Proprietary Network (VPC/Leased Line): accesses cloud resources over the private network on the cloud to provide more flexible, secure, and controllable network environment. For more information, see What is a VPC?
ImportantClick Configure Whitelist in the console to learn how to add the CIDR blocks to the security settings of the source database. This way, Data Disaster Recovery can access the source database. For more information, see Manually add the CIDR blocks of DBS to the security settings of self-managed databases.
Proprietary Network (VPC/Leased Line)
The proprietary network in which the database that you want to back up is deployed.
NoteThis parameter is displayed only if you set the Network Access Type parameter to Proprietary Network (VPC/Leased Line).
Source Database IP Address
The endpoint used to connect to the database that you want to back up.
Port
The port used to connect to the database that you want to back up. The default port number of the MySQL database is 3306.
Data Source Name
We recommend that you use a descriptive name that is easy to identify.
Automatic backup for users
ImportantThe version of the MySQL databases must be 5.5.
Click Add Data Source. In the dialog box that appears, configure the following information, select the backup schedule that you want to use, and then click Next in the lower-right corner of the page.
Parameter
Description
Data Source Name
We recommend that you use a descriptive name that is easy to identify.
Engine Type
The type of database engine. Only MySQL is supported.
Engine Version
The version of the database engine.
Engine Parameters
{"lower_case_table_names":1}
If no backup schedule is available, click Purchase Backup Schedule to go to the buy page and purchase a backup schedule.
Description
Product Type
Select Backup Schedule. The pay-as-you-go billing method is not supported.
Region
The region in which you want to store the backup data.
Data Source Type
The type of the source database. Select MySQL.
Specification
Select xmicro. The free backup quota varies based on the backup schedule type. For more information, see Select a backup schedule type.
Backup Method
Select Physical Backup.
Storage Size
You do not need to select a capacity when you create the backup schedule. You are charged based on the amount of data that is stored in Data Disaster Recovery. For more information, see Storage fees.
Resource Group
The resource group that is used by the backup schedule. You can use the default resource group or select a resource group based on your business requirements.
Quantity
The number of backup schedules that you want to purchase. To back up multiple database instances, you must purchase multiple backup schedules. For example, if you want to back up Database Instance A and Database Instance B, you must purchase two backup schedules.
Subscription Duration
The subscription duration for the backup schedule that you want to purchase.
Upload a backup set to the specified bucket. For more information, see Upload data (automatic backup for users).
Then, click OK.
FAQ
Q: What do I do if the CIDR blocks of the Data Disaster Recovery server fail to be automatically added to the security groups of the ECS instances?
A: If you revoke the access permissions of Data Disaster Recovery on ECS instances, the CIDR blocks of the Data Disaster Recovery server fail to be automatically added to the security groups of the ECS instances. To resolve this issue, you must manually add the CIDR blocks of the Data Disaster Recovery server to the security groups of the ECS instances. For more information, see Manually add the CIDR blocks of Data Disaster Recovery to the security settings of self-managed databases.