:Configure a backup instance

Prerequisites

• The data source is an ApsaraDB RDS for MySQL instance.

• A backup instance is purchased, and an authorized account is added to the backup instance. For more information, see Purchase a backup instance and Add a database account.

  Note

  Make sure that the account has the permissions required to back up and restore the specified databases. For more information, see Account permissions.

Usage notes

• Cross-region backup is not supported.

• When DBS backs up a database, the performance of the database is affected. We recommend that you run backup tasks during off-peak hours.

• DBS automatically creates the following default backup policy when you configure a backup instance. You do not need to specify the backup cycle or retention period for backup sets.

  • Data backup: This feature is enabled by default and cannot be disabled. Data is backed up every Monday, Wednesday, Friday, and Sunday. The retention period of data backup sets is seven days. You can modify the backup policy for data backup based on your business requirements after you configure a backup instance. For more information, see View or modify the backup policy of a backup instance.

  • Log backup: By default, this feature is enabled, and logs are readable. You cannot disable this feature. The retention period of log backup sets is 30 days and cannot be changed.

Billing

After you start a backup instance, you are charged for backup fees and storage fees of backup sets. You cannot use resource plans to offset the fees of backup instances. No fees are charged if you configure a backup instance but do not start it.

Procedure

1. Access the Data Source page in the DBS console. In the top navigation bar, select a region. Then, click the ID of the desired instance.

2. In the left-side navigation pane, click Backup Policy.

3. On the Backup Policy page, click the Logical Backup tab.

4. Click Configure Backup Policy.

   

5. In the Select Backup Schedule step, select the backup instance that you want to configure and click Next.

   

6. In the Select Account to Authorize step, select the database account that you want to use and click Next.

   If no account is displayed, you can click Add Account to Authorize to add an account before you proceed to the next step. Make sure that the account has the permissions required to back up and restore the specified databases. For more information, see Account permissions.

7. In the Select Database and Table step, select the databases and tables that you want to back up, click the icon to move them to the Selected Objects section, and then click Submit.

   

8. Wait until the precheck is complete. Then, click Start in the Precheck dialog box.

   
   Note

   • If you want to perform other operations first, such as modifying the backup policy, you can choose not to immediately start the backup instance. However, DBS will automatically start the backup instance based on the backup policy.

   • You can click Start next to Backup Status on the Logical Backup tab to manually start the backup instance. After you click Start, DBS immediately initiates a full and incremental backup task.

9. Optional. View the progress of the backup task.

   In the left-side navigation pane, click Task Management. On the Backup Task tab, view the progress of the backup task.

References

• View or modify the backup policy of a backup instance

• Download a data or log backup set

• Create a restore task

FAQ

What do I do if a database account fails to pass the mysql JDBC Connect diagnostics when I add the database account?

The database account or password is incorrectly entered, or the database password contains special characters. For more information about how to troubleshoot this issue, see the "Usage notes" section of the Add a database account topic.