Database Backup (DBS) provides the batch backup feature to allow 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, configure Data source type and Backup Method, and click Start Batch Backup.
When you batch create backup databases, all of the databases must be of the same engine and backup method. For example, you can create logical backups for multiple MySQL databases at a time. You can also create physical backups of multiple Oracle databases at a time. The Data Source dialog box then displays all available data sources.
- In the Data Source step, select 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. The batch backup feature does not support selecting data sources across pages. By default, each page displays 20 data sources. If you need 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 its name or filter the data source based on its logical group.
- 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 right 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 the database. For more information, see Supported 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. Different backup schedule specifications cannot be applied to specific data sources in the batch.
- 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 following parameters, and then click OK.
Type Parameter Description The underlying 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 incremental backup. Advanced configuration 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 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
- Q: What do I do if a backup schedule for a PolarDB for MySQL cluster fails the 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.