This topic describes how to set backup policies for an RDS MariaDB instance. The system backs up the instance data according to the backup policies. MariaDB TX does not support manual backup.
Precautions
- The backup files occupy the backup space of the RDS instance. If the used backup space exceeds the quota of free backup space, additional fees are incurred. For more information, see View the quota of free backup space for an RDS MariaDB instance.
- For information about the billing method and billable items, see Pricing, billing items, and billing methods.
- For information about the pricing of backup space, see ApsaraDB RDS MySQL pricing.
- Do not perform DDL operations during the backup. Otherwise, tables are locked and consequently the backup fails.
- Back up data and logs during off-peak hours.
- If the data volume is large, the backup may take a long time.
- Backup files are retained for a specified time period. Download the backup files to your computer before they are deleted.
Overview
DB engine | Data backup | Log backup |
---|---|---|
MariaDB | Supports snapshot backup, but does not support physical backup or logical backup. |
Note You cannot access the buckets for storing the uploaded binary log files in OSS.
|
Procedure
ApsaraDB for RDS can automatically back up databases according to the backup policy you set.
- Log on to the RDS console.
- Select the target region.
- Find the target RDS instance and click the instance ID.
- In the left-side navigation pane, click Backup and Restoration.
- On the Backup and Restoration page, click the Backup Settings tab. On the Backup Settings tab, click Edit.
- In the Backup Settings dialog box, set the backup parameters and click OK. The following table describes the parameters.
Table 1. Backup parameters Parameter Description Data Retention Period The data retention period spans from 7 days to 730 days. The default retention period is 7 days. Note For MySQL 5.7 Basic Edition (with SSDs), the data retention period is 7 days and cannot be changed.Backup Cycle Select one or more workdays. Backup Time You can select any time period, which is measured in the unit of hour. We recommend that you select a time period during off-peak hours. Log Backup The status of the log backup function. Notice If you disable the log backup function, all log backup files are deleted and the time-based data restoration function becomes unavailable.Log Retention Period - The number of days in which log backup files are retained. The default retention period is 7 days.
- The log retention period spans from 7 days to 730 days and must be shorter than or equal to the data retention period.
Note For MySQL 5.7 Basic Edition (with SSDs), the log retention period is 7 days and cannot be changed.
FAQ
- Can I disable the data backup function for an RDS MariaDB TX instance?
No, the data backup function must be enabled, and the backup file retention period ranges from 7 days to 730 days.
- Can I disable the log backup function for an RDS MariaDB TX instance?
Yes, you can disable the log backup function as needed.
APIs
API | Description |
---|---|
CreateBackup | Used to create a backup file for an RDS instance. |
DescribeBackups | Used to view the list of backup files for an RDS instance. |
DescribeBackupPolicy | Used to view the backup settings of an RDS instance. |
ModifyBackupPolicy | Used to modify the backup settings of an RDS instance. |
DescribeBackupTasks | Used to obtain the list of backup tasks for an RDS instance. |
DescribeBinlogFiles | Used to view binlogs of an RDS instance. |