Data Management:Logical backup and restore for RDS for MariaDB

Create a backup schedule

Configure a backup schedule

1. Log on to the Data Management Service (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 settings

   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 that is used to back up data. By default, the backup method that you selected when you purchased the backup schedule is used. In this example, Logical Backup is used.
   	Database location	RDS Instance
   	Instance Region	Select the region of the source database instance. 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 ID of the source RDS instance.
   	Database account	The username of the account that is used to connect to the database that you want to back up. The account must have permissions to back up the database. For more information, see Account permissions. Note For ApsaraDB RDS databases, read-only permissions are required for backup, and read and write permissions are required for backup and restoration.
   	Password	The password of the account that is used to connect to the database that you want to back up. After you enter the username and password of the database account, click Test Connection next to the password to check whether the information about the database that you want to back up is valid. If the specified parameters are valid, the Test Passed message is displayed. If the Test Failed message is displayed, click Check next to Test Failed. Modify the information about the database that you want to back up based on the check results.
   	Data cross-border compliance commitment	Read and select the compliance commitment.
   Backup Destination Information	Backup storage type	The storage type for your backup data. Valid values: DBS built-in storage (Recommended): No separate storage space required. DBS stores data in built-in storage and charges based on data volume. Billable items (DMS). OSS For User: You must first create a bucket in the OSS console. Create a bucket. Note This example uses DBS built-in storage. If you select user OSS, you must also configure the Object Storage OSS Bucket Name parameter. Only the OSS Standard storage class is supported. For large data volumes, purchase a subscription DBS storage package for lower costs compared to pay-as-you-go.
   	Storage encryption	Select a storage encryption method. Valid values: Encrypted (Recommended): Encrypts stored data by using the industry-standard AES-256 algorithm. OSS automatically encrypts objects on upload and decrypts them on download. Server-side encryption. Non-encrypted: Disables encryption for stored data.

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

   Note

   • Logical backup: Select specific databases and tables for a full backup. Depending on the database type, you can select entire databases or individual tables. Some database types also support incremental backup, which includes all incremental data without distinguishing between databases or tables.

     • Click Select All to back up the entire database. Supported backup objects and granularity vary by database type. Supported database types and features.

     • A backup schedule does not include databases created after configuration. Add new databases manually. Modify backup objects.

   • Physical backup: Back up the entire database instance only.

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

   Parameter	Description
   Full backup frequency	Select Periodic Backup or Single Backup. Note If you need to restore incremental data, we recommend selecting Periodic Backup and performing at least one full backup per week. Otherwise, restoring the database may require replaying a large number of binlogs, which can increase the Recovery Time Objective (RTO) and risk of failure.
   Full backup recurrence	This parameter is required if you set Full backup frequency to Periodic Backup. Select the days of the week for the backup. You must select at least one day.
   Full backup start time	This parameter is required if you set Full backup frequency to Periodic Backup. Select a start time for the backup, for example, 01:00. We recommend scheduling backups during off-peak hours. Note If a previous full backup is still in progress at the scheduled start time, the current backup task is skipped.
   Incremental backup	Specify whether to enable incremental backup. If enabled, ensure the target database has Binlog enabled. RDS MariaDB: View or enable Binlog from MariaDB backup settings. Self-managed MariaDB: Run SHOW VARIABLES LIKE 'log_bin'; to check the Binlog status. If log_bin is ON, Binlog is enabled. If it is OFF, Binlog is disabled. Note This parameter is displayed only when Full backup frequency is set to Periodic Backup.
   Maximum concurrent threads for full backup	The maximum number of concurrent threads for full backup. You can adjust this parameter to control the backup speed. For example, reducing the number of threads can lessen the impact on your database.
   Backup network speed limit	The limit on the network bandwidth. Unit: MB/s. You can set the limit based on your business requirements. The default value 0 indicates that the network bandwidth is unlimited. Note This parameter is displayed only when backing up a MySQL database.

7. In the Edit Lifecycle step, configure the lifecycle for full backup data in the Configure Full Data Backup Lifecycle section.

   Note

   If you set the Incremental Backup parameter to Enable in Step 6, you must configure the lifecycle for incremental backup data.

8. After the 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

   • When the Status of the backup schedule changes to Running, the configuration is complete.

   • If an error occurs, fix the issue. How to fix an abnormal DBS backup schedule. If the issue persists, contact support via the DBS DingTalk group (Group ID: 35585947).

Restore data

Related operations

• Modify backup source, objects, time, or retention policy: Manage a backup schedule.

• Understand backup schedule costs: Billing FAQ.

• Pause unused backup schedules to save costs. Pause or restart a backup schedule.