All Products
Search

This Product

    Database Backup:Configure automatic download of backup sets

    Document Center

    Database Backup:Configure automatic download of backup sets

    Last Updated:Apr 11, 2024

    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.

    Pricing

    Database Backup (DBS) does not charge a fee for network traffic that is generated when you manually download a backup set.

    Limits

    Note

    Before you download a backup set, check its validity period. The download process takes an amount of time. If the backup set that you want to download is about to expire, we recommend that you extend the retention period of the backup set in advance to prevent data from being automatically deleted during the download process. After the backup set is downloaded, you can change its retention period to the original setting. For more information, see Modify the lifecycle of a backup schedule.

    Item

    Logical backup

    Physical backup

    Backup destination storage type

    Only DBS built-in storage is supported. Object Storage Service (OSS) buckets are not supported.

    Only DBS built-in storage is supported. OSS buckets are not supported.

    Full data

    The following types of databases are supported:

    • MySQL

    • SQL Server

    • MariaDB

    • PostgreSQL

    • Oracle

    • MongoDB

    Note

    MongoDB data is in the JSON format. Other data is in the CSV format.

    The following types of databases are supported:

    • MySQL

    • SQL Server

    Note

    • MySQL data is in the same format as the data generated by using Percona XtraBackup and is compressed.

    • SQL Server data is in the same format as the data generated by using the native backup command and is compressed.

    Incremental data

    The following type of database is supported:

    MySQL

    Note

    Data is in the native format of MySQL.

    The following types of databases are supported:

    • MySQL

    • SQL Server

    Note

    Data is in the same format as its full data.

    Procedure

    1. Log on to the Database Backup (DBS) console.

    2. In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.

    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. Configure the parameters that are described in the following table.

      Parameter

      Description

      Automatic 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 that is used by DBS to connect to the on-premises device. For more information, see Install a backup gateway.

      Important

      The automatic download of backup sets feature is not yet commercially available and does not ensure stable performance. To prevent data accumulation and other exceptions, we recommend that you do not use the same backup gateway to download the backup data of multiple backup schedules.

      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 configured 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 configured by the system and cannot be modified.

    6. Click OK.

      After you configure the automatic download of backup sets feature, DBS does not trigger the automatic download rule to download the historical backup data. DBS triggers the automatic download rule only when new full or incremental backup data is 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 tar xvf <Download task ID>.tar command to obtain the <Download task ID> file.

    What to do next