Database Backup (DBS) provides the batch backup feature, which allows you to back up one or more databases. This topic describes how to back up one or more databases. Logical backups of MySQL databases are configured in this example.
- Before you back up one or more databases, you must add one or more data sources. You
can use one of the following methods to add data sources:
- Add a data source
- Add multiple data sources at a time
- Configure automatic access to a data sourceNote If your data source is automatically added, you must configure the account and password for the data source. For more information, see Configure the account and password for a data source.
- You can use the batch backup feature only for the databases that use the same database engine and backup method. For example, you can perform logical backups on multiple MySQL databases at a time. You can also perform physical backups on multiple Oracle databases at a time.
- 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.
- Configure Data source type and Backup Method, and then click Start Batch Backup.
The system lists the available data sources that meet the specified conditions.Note For more information, see Backup methods.
- In the Data Source step, select the data sources that you want to back up and click NextBackup Object.Note
- You can select a single database in this step.
- The batch backup feature does not allow you to select data sources across multiple 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 backups.
- 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 account and password are not configured for the data source that you want to back up, you must configure the account 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.Note
- If 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.
- Click NextBackup Configuration.
- In the Backup Configuration step, select a backup schedule specification, modify the backup configurations, and
then click NextBackup Strategy.
- Click Select the specifications. In the dialog box that appears, select a backup schedule specification and click
- 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 an instance type.
- Click Modify the backup configuration in bulk. In the dialog box that appears, modify the following parameters and click OK.
Category 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. Incremental log real-time backup Specifies whether to enable incremental backup. Advanced configuration None NoneNote To modify the backup configurations, you can also 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 Strategy 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 NextPurchase Schedule.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 strategy.
- 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. Click Batch order, and then complete the payment.
After the payment is successful, the system starts to configure the backup schedule and perform a precheck. A precheck includes initializing the backup schedule and checking the configuration environment.Note The precheck takes about 2 minutes. A larger data source requires more time. Click Precheck Progress to view the precheck progress.
- Click Turn on backup.
After you click Complete, the system automatically starts the backup schedule. You can view the created backup schedule on the details page of the destination instance.