All Products
Search
Document Center

Configure a backup plan

Last Updated: Dec 07, 2018

DBS offers features such as full backup, incremental backup, and data recovery. You need to create and configure a backup plan in order to use these features.

Procedure

After you have created a backup plan, you need to configure the plan in the DBS console by following these steps:

  1. Configure backup source and target
  2. Configure backup object
  3. Configure backup schedule
  4. Configure lifecycle
  5. Precheck

Configure backup source and target

  1. For more information about restricted databases, versions, and network environments, see DBS restrictions.
  1. For more information about required database permissions, see Database permissions.
  1. For more information about backup files, see How to select OSS buckets.
  1. DBS provides local and remote backup options. For more information about creating remote backups, see Create remote backups with DBS.
  1. You must select the same regions for your OSS buckets and DBS backup plans.
  1. You can click how to add a whitelist to find the IP address of the DBS server. You must allow DBS to access your database.

Configure backup object

You may have multiple databases in a database instance. You can select to backup the entire database instance, a specific database, or several tables.

Configure backup schedule

You can configure when to backup your database on this page. You can choose to perform backups weekly, or at specific time points. For example, you can perform a full backup at off-peak hours, such as 3 am.

You can also configure incremental backups. After you have enabled incremental backup, you can restore the database to a time accurate to seconds. Incremental backups generate more backup data and involve higher costs.

Configure lifecycle

DBS allows you to manage the lifecycle of backup sets to reduce storage cost. You can configure transfer and deletion policies for all backup sets stored in OSS. The following is an example of the maximum retention period of 730 days of a full backup set. The backup set will be deleted after 730 days have passed. A newly created backup set is first stored in OSS Standard storage for 180 days, and then moved to OSS Infrequent Access storage. After another 365 days, the backup is transferred to OSS Archive storage. You can configure similar policies for incremental backup sets. For more information about the lifecycle of backup sets, see Lifecycle of backup sets.

Precheck

After you have configured the backup plan, you can precheck the configurations, database connectivity, and database logging settings. If the precheck is successful, the backup plan will take effect immediately.

View backup plan

You can go to the DBS console to view details about your backup plans.

Appendix

SSL connection

Step 1: Create SSL certificate and private key

Version Description
MySQL versions earlier than 5.7 Use OpenSSL
MySQL 5.7 and later versions Run the following comand: /bin/mysql_ssl_rsa_setup
  1. For more information about installing OpenSSL, see Creating SSL and RSA Certificates and Keys using MySQL.

  2. For more information about installing mysql_ssl_rsa_setup, see mysql_ssl_rsa_setup — Create SSL/RSA Files.

  3. For more information about enable SSL in MySQL, see Set SSL encryption.

Step 2: Select SSL certificate and private key

Certificate file Description
ca.pem Self-signed CA certificate
ca-key.pem CA private key
server-cert.pem Server certificate
server-key.pem Server private key
client-cert.pem Client certificate
client-key.pem Client private key

Step 3: Upload SSL certificate and private key

When you configure the backup plan, select SSL Connection as the connection type, and upload your SSL certificate and private key.

  • CA Certificate
  • Client Certificate
  • Client Private Key