Database Backup (DBS) can use backup gateways to automatically download backup sets. This topic describes how to configure automatic download of backup sets.

Prerequisites

A backup gateway is added. DBS connects to on-premises devices by using the backup gateway. For more information, see Add a backup gateway.

Feature limits and formats

Limit Logical backup Physical backup
Backup destination storage type Only DBS built-in storage is supported. Object Storage Service (OSS) buckets are not supported.
Note If you store data in OSS buckets, you can download the data in the OSS console. For more information, see Download objects.
Only DBS built-in storage is supported. OSS buckets are not supported.
Note If you store data in OSS buckets, you can download the data in the OSS console. For more information, see Download objects.
Full data The following database engines are supported:
  • Self-managed MySQL or ApsaraDB RDS for MySQL
  • Self-managed SQL Server or ApsaraDB RDS for SQL Server
  • Self-managed MariaDB or ApsaraDB RDS for MariaDB TX
  • Self-managed PostgreSQL or ApsaraDB RDS for PostgreSQL
  • Self-managed Oracle
  • Self-managed MongoDB or ApsaraDB for MongoDB
Note MongoDB data is in the JSON format. Other data is in the CSV format.
The following database engines are supported:
  • Self-managed MySQL

    In the DBS console, you can download the physical backup sets of self-managed MySQL databases, but not those of ApsaraDB RDS for MySQL instances. You can download the backup sets of ApsaraDB RDS for MySQL instances in the ApsaraDB RDS console. For more information, see Download the backup files of an ApsaraDB RDS for MySQL instance.

  • Self-managed SQL Server
  • Self-managed Oracle
Note
  • MySQL data is in the same format as the data in Percona XtraBackup and is compressed.
  • SQL Server data is in the same format as the data generated by the native backup command and is compressed.
  • Oracle data is in the same format as the data backed up in Recovery Manager (RMAN) and is compressed.
Incremental data The following database engines are supported:

MySQL

Note Data is in the native format of MySQL.
The following database engines are supported:
  • Self-managed MySQL
  • Self-managed SQL Server
  • Self-managed Oracle
Note Backup data is in the same format as its full data.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
  3. Click Schedule ID or Manage in the Actions column corresponding to a backup schedule.
    Manage button
  4. On the Configure Task page, click Set backup set download rules in the Backup set download section.
    Note If the database engine of a backup schedule does not support the download of backup sets or the destination storage type is not DBS built-in storage, the Set backup set download rules button is unavailable in the console.
  5. Set the parameters that are described in the following table.
    Parameter Description
    Auto download status Specifies whether to enable automatic download. Select Enable.
    Target type By default, the parameter is set to the directory of the server on which the backup gateway is installed.
    Backup Gateway The backup gateway. For more information, see Add a backup gateway.
    Target location The type of the location and the corresponding directory to which the backup set is downloaded. Valid values:
    • Server directory
    • FTP direction
    • NAS direction
    • Minio direction
    Full data format This parameter is automatically specified by the system and cannot be modified.
    Note For more information about the data format of full and incremental backup sets, see the "Feature limits and formats" section of the Overview topic.
    Incremental data format This parameter is automatically specified by the system and cannot be modified.
  6. Click OK.

    The automatic download of backup sets is configured. DBS does not immediately download historical backup data after you configure the automatic download of backup sets. New full and incremental backup sets are automatically downloaded after they are generated.

  7. After the download is complete, decompress the downloaded package. By default, the backup sets are compressed in the <Download task ID>.tar.gz package.
    Run the following commands to decompress the downloaded package:
    1. Run the gzip -d <Download task ID>.tar.gz command to obtain the <Download task ID>.tar file.
    2. Run the jar xvf <Download task ID>.tar command to obtain the <Download task ID> file.

What to do next

You can view the download progress of backup sets in the DBS console. For more information, see View download progress.