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 the example provided by this topic, the logical backups of MySQL databases are configured.
- Log on to the DBS console.
- In the left-side navigation pane, click Data Source. On the Data Source page, select a region in the upper-left corner.
- Click Batch backup.
- In the dialog box that appears, set the Data source type and Backup Method parameters, and click Start Batch Backup.
If you want to perform backups for multiple databases at a time, all of the databases must be of the same engine and backup method. For example, you can perform logical backups for multiple MySQL databases at a time. You can also perform physical backups of multiple Oracle databases at a time. In the Data Source step, all available data sources are displayed.
- In the Data Source step, select the data sources that you want to back up and click Next Select Backup Objects. Note
- You can select one or more databases in this step. You cannot select data sources across pages. By default, a maximum of 20 data sources are displayed on each page. If you want to back up more than 20 data sources, we recommend that you perform batch backup operations multiple times.
- To search for a data source, you can enter the name of the data source or filter the data source based on the logical group of the data source.
- 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.
- 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 rightwards arrow to move these databases and
tables from the Available section to the Selected section. Click Next Configure Backup Settings. Note
- When you back up an entire database, additional database objects such as backup indexes and stored procedures are also backed up. The kinds of objects that can be backed up vary based on different databases. For more information, see Database engines and features.
- You can click One-click backup to back up all databases and relevant tables.
- In the Backup Configuration step, select a backup schedule specification, modify backup configurations, and then
click Next Configure Backup Policy.
- Click Select the specifications. In the dialog box that appears, select a backup schedule specification and click
- The backup schedule specifications that you select are applied to all data sources that are added to the batch backup. You cannot configure the backup schedule specification for each data source.
- The free quota for data backup, unit price, and backup and restoration performance vary based on specifications. For more information, see Select backup schedule specifications.
- Click Modify the backup configuration in bulk, modify the parameters described in the following table, and then click OK.
Section Parameter Description Basic Configuration maximum number of parallel threads for a full backup The maximum number of parallel threads available for a full data backup.Note The maximum number of actual parallel threads varies based on the backup schedule specifications displayed in the console. Incremental real-time backup Specifies whether to enable the incremental backup feature. Advanced Settings None NoneNote To modify backup configurations, you can click Modify the backup configuration in the Actions column.
- Click Select the specifications. In the dialog box that appears, select a backup schedule specification and click OK.
- 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. Note
- A backup policy includes 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 Create a backup policy template.
- To modify a backup policy, you can click Select an option in the Backup Strategy column.
- 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 complete the payment.
After the payment is successful, DBS automatically configures the backup schedule and performs a precheck. During the precheck, DBS initializes the backup schedule and checks the configuration environment.Note The precheck takes about 1 to 2 minutes to complete. The larger the data source, the longer the precheck takes. Click Precheck Progress to view details.
- After the precheck is successful, click Turn on backup.
After you click Turn on backup, DBS automatically starts the backup schedule. You can view the created backup schedule on the details page of the data source that you backed up.
What to do next
- What do I do if a backup schedule for a PolarDB for MySQL cluster fails due to a failed
precheck on the binary logging feature of the source database?
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.