Data Management:Logical backup and restore for RDS for MySQL

Create a backup schedule

Create a backup schedule.

Configure a backup schedule

1. Log on to the Data Management (DMS) 5.0 console.

2. In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

   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) > Backup Plan.

3. Find the backup schedule that you want to configure and click Configure Backup Schedule in the Actions column.

   

4. On the Configure Backup Source and Destination page, configure the backup source and destination, and then click Next.

   

   Table 1. Database configuration

   Section	Parameter	Description
   N/A	Schedule Name	The name of the backup schedule. DBS automatically generates a backup schedule name. We recommend that you enter a descriptive name that is easy to identify. Backup schedule names do not need to be unique.
   Backup Source Information	Backup Method	The method selected at purchase. In this example, Logical Backup is selected.
   	Database Location	RDS Instance
   	Instance Region	Select the region where the source instance resides. Note This parameter is displayed only when you select RDS Instance, PolarDB, ECS-Hosted Database, or No public network IP: Port's self-built database (accessed through the database gateway).
   	RDS Instance ID	Select the ApsaraDB RDS instance that you want to back up.
   	Database Account	Enter the source database username. The account must have the required backup permissions listed in Account permissions. Note For ApsaraDB RDS databases, a read-only account is sufficient for backups, but a read/write account is required for both backups and restores.
   	Password	Enter the password for the database account. After entering the credentials, click Test Connection to verify them. If the connection is successful, a "Test Passed" message appears. If the connection fails, click Diagnose next to the failure message and adjust your settings based on the results.
   	Connection Method	Available connection methods: Non-encrypted SSL-encrypted: Secure Sockets Layer (SSL) encrypts data at the transport layer to improve security and integrity. However, it may increase the response time of the network connection. Note Before you select SSL-encrypted, enable SSL encryption for the RDS instance. Step 1: Enable SSL encryption for an ApsaraDB RDS for MySQL instance.
   	Compliance warranty regarding cross-border data transfers	Read and agree to the compliance commitment by selecting the check box.
   Backup Destination Information	Backup Storage Type	Available storage types: DBS Built-in Storage (Recommended): Backup data is automatically stored in the built-in storage of DBS. No bucket creation is required. You are charged based on the amount of data stored. Billing (DMS). OSS For User: You must create an OSS bucket in advance. Create buckets. Note This example uses DBS Built-in Storage. If you select User-owned OSS bucket, you must also configure the Object Storage OSS Bucket Name parameter. Only the OSS Standard storage class is supported. For large backup volumes, purchase a DBS storage plan (subscription) to reduce costs compared to pay-as-you-go billing.
   	Storage Method	Available storage methods: Encrypted (Recommended): Uses the industry-standard AES-256 algorithm for server-side encryption at rest. OSS encrypts objects on upload and decrypts them on download. Non-encrypted: Encryption is disabled.

5. On the Edit Backup Objects page, move the databases or tables that you want to back up to the Selected box, and then click Next.

   Note

   • You can back up a single table, a single database, or multiple databases. Click Select All to select all existing databases. Supported backup objects vary by database type. Supported database types and features.

   • Databases created after schedule configuration are not backed up by default. Add them manually via Modify backup objects.

6. On the Configure Backup Time page, configure the backup time and other settings, and then click Next.

   Parameter	Description
   Full Backup Frequency	Select Periodic Backup or Single Backup as needed. Note If you select Periodic Backup, you must also configure Full Backup Cycle and Full Backup Start Time.
   Full Backup Cycle	Select the days of the week to perform the backup. You must select at least one day and can select up to seven days.
   Full Backup Start Time	Select a start time, for example, 01:00. Choose an off-peak time. Note If a previous full backup is still in progress at the specified start time, the current backup task is skipped.
   Incremental Backup	Specifies whether to enable incremental backup. Note If you enable this feature, make sure that binary log is enabled for the source database. The binary log feature is enabled by default for ApsaraDB RDS for MySQL. For self-managed databases, you must enable it manually. This parameter is displayed only when Full Backup Frequency is set to Periodic Backup.
   Maximum Concurrent Threads for Full Backup	Maximum number of concurrent threads for full backup. Lowering the thread count reduces database load.
   Backup Network Throttling	Network bandwidth limit in MB/s. Default: 0 (no limit).

7. On the Edit Lifecycle page, specify the retention period for full backup data in the DBS built-in storage.

   If you enabled Incremental Backup in the previous step, also configure the incremental backup retention period. Manage the lifecycle of backup data.

8. After the preceding configurations are complete, click Precheck in the lower-right corner of the page.

9. In the Precheck dialog box, after the precheck passes, click Start Task.

   Note

   • The backup schedule is configured after its Status changes to Running.

   • If the backup schedule fails or an error is reported, troubleshoot the issue promptly. Troubleshoot an abnormal DBS backup schedule. If the issue persists, join the DBS user support group on DingTalk (ID: 35585947).

Restore data

Related operations

• To change the backup source, objects, or policy (time, retention), use Manage a backup schedule.

• For cost details, check Billing FAQ.

• To reduce costs, pause the backup schedule when not needed. Pause or restart a backup schedule.