Database Backup (DBS) provides the batch backup feature that allows you to back up one or more databases. This topic describes how to back up one or more databases. In this example, logical backups of MySQL databases are configured.

Prerequisites

A data source is added to DBS. You can use one of the following methods to add data sources:

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Data Source. On the Data Source page, select a region in the upper-left corner.
  3. Click Batch backup.
    Batch backup
  4. In the dialog box that appears, configure Data source type and Backup Method, and then click Start Batch Backup.

    You can use the batch backup feature only for databases that use the same database engine and backup method. For example, you can create logical backups of multiple MySQL databases at a time. You can also create physical backups of multiple Oracle databases at a time. In the Data Source dialog box, all available data sources that meet the specified conditions are displayed.

    Data source type
  5. In the Data Source step, select the data sources that you want to back up and click Next Select Backup Objects.
    Data Source
    Note
    • You can select one or more databases in this step. The batch backup feature does not allow you to select data sources across pages. By default, 20 data sources are displayed on each page. If you need to back up more than 20 data sources, we recommend that you perform multiple batch backup operations.
    • To search for a data source, you can enter the name of the data source in the search box. You can also filter the data source based on the logical group to which the data source belongs.
    • If the database username and password are not configured for the data source that you want to back up, you must configure the username and password. For more information, see Configure the account and password for a data source.
  6. In the Backup Object step, select the data sources that you want to add. Select the databases and tables that you want to back up and click the right arrow to move these databases and tables from the Available section to the Selected section. Click Next Configure Backup Settings.
    Backup Object
    Note
    • When you back up an entire database instance, the permission data and stored procedures are also backed up.
    • You can click One-click backup to back up all databases and tables in the database instance.
  7. In the Backup Configuration step, select a backup schedule specification, modify the backup configurations, and then click Next Configure Backup Policy.
    1. Click Select the specifications. In the dialog box that appears, select a backup schedule specification and click OK.
      Select the specifications
      Note
      • The backup schedule specification that you select applies to all data sources that you add in this batch backup. You cannot select a backup schedule specification for each data source.
      • The free quota for data backup, unit price, and backup and restoration performance vary based on backup schedule specifications. For more information, see Select backup schedule specifications.
    2. Click Modify the backup configuration in bulk. In the dialog box that appears, modify the following parameters and click OK.
      Section Parameter Description
      The underlying configuration maximum number of parallel threads for a full backup The maximum number of concurrent threads available for a full data backup.
      Note The maximum number of actual concurrent threads varies based on backup schedule specifications in the console.
      Real-Time Transaction Log Backup Specifies whether to enable incremental backup.
      Advanced configuration N/A N/A
      Note To modify the backup configurations, you can also click Modify the backup configuration in the Actions column.
  8. In the backup policy step, click Batch apply backup strategies. In the dialog box that appears, select a backup policy that you want to apply and click OK. Then, click Next Purchase Backup Schedule.
    Backup Strategy
    Note
    • A backup policy contains configuration items for a backup schedule, such as the backup method, storage method, backup frequency, backup cycle, and backup start time. For more information, see Manage backup policy templates.
    • To modify a backup policy, you can click Select an option in the Backup Strategy column.
  9. In the Purchase Schedule step, check the order information, read and select service terms, and then select Auto-renewal at expiration based on your business requirements. Click Batch order, and then complete the payment.
    Purchase Schedule

    After the payment is successful, DBS starts to configure the backup schedule and performs a precheck. During the precheck, DBS initializes the backup schedule and checks the configuration environment.

    Precheck
    Note The precheck takes about 1 to 2 minutes. The larger the data source, the more the time a precheck requires to complete. Click Precheck Progress to view the precheck progress.
  10. After the precheck is successful, click Complete.
    Complete

    After you click Complete, DBS automatically starts the backup schedule. You can view the created backup schedule on the details page of the destination instance.

    Data source details

What to do next

FAQ

  • Q: What do I do if a backup schedule for a PolarDB for MySQL instance fails the precheck on the binary logging feature of the source database? The precheck fails because the binary logging feature is not enabled for the PolarDB for MySQL instance

    A: The precheck fails because the binary logging feature is not enabled for the PolarDB for MySQL instance. You can enable the binary logging feature for your instance in the PolarDB for MySQL console. For more information, see Enable binary logging.