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 free quota for backup storage of an ApsaraDB RDS for MariaDB TX instance.
  • For information about the billing method and billable items, see Billable items, billing methods, and pricing.
  • 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.
  • Binary log files occupy the disk space of the RDS instance.
  • When the size of the existing binary log file reaches 500 MB or the duration of data write into the existing binary log file reaches 6 hours, the system starts to write data into a new binary log file. The earlier binary log file then is uploaded asynchronously.
  • You can uploaded binary log files to buckets in OSS.
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.

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Backup and Restoration.
  3. On the Backup and Restoration page, click the Backup Settings tab. On the Backup Settings tab, click Edit.
  4. 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 The cycle based on which you want to perform a backup. You can select one or more days of the week.
    Note For data security purposes, we recommend that you select at least two days of the week.
    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

  1. 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.

  2. 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
Create a backup task Used to create a backup file for an RDS instance.
Query the data backup files Used to view the list of backup files for an RDS instance.
Query backup settings Used to view the backup settings of an RDS instance.
Modify backup settings Used to modify the backup settings of an RDS instance.
Query backup tasks Used to obtain the list of backup tasks for an RDS instance.
Query log backup files Used to view binlogs of an RDS instance.