Data Management:Logical backup and restoration of a PolarDB-X instance

Features

Create a backup schedule

For more information, see Create a backup schedule.

Configure a backup schedule

1. Log on to the Data Management (DMS) console.

2. In the top navigation bar, choose Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

   Note

   If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > Security and disaster recovery (DBS) > Data Disaster Recovery (DBS) > Backup Plan.

3. Find the backup schedule that you want to configure and click Configure Backup Schedule in the Actions column.

4. On the Configure Backup Source and Destination page, configure the source and destination information, and then click Next.

   Category	Parameter	Description
   N/A	Backup Schedule Name	The name of the backup schedule. DBS automatically generates a backup schedule name. We recommend that you enter a descriptive name that is easy to identify. Backup schedule names do not need to be unique.
   Backup Source Information	Backup Method	The method that is used to back up data. By default, the backup method that you selected when you purchased the backup schedule is used. In this example, Logical Backup is used.
   	Database Location	Select PolarDB-X Instance.
   	Instance Region	The region in which the source database instance resides.
   	Database Type	Select PolarDB-X (formerly DRDS).
   	PolarDB-X Instance ID	Select the ID of the instance that you want to back up.
   	Database Name	Enter the name of the database that you want to back up.
   	Database Account	Enter the database account. The account must have the required permissions to back up the database. For more information, see Account permissions.
   	Password	The password of the account that is used to connect to the database that you want to back up. After you enter the username and password of the database account, click Test Connection next to the password to check whether the information about the database that you want to back up is valid. If the specified parameters are valid, the Test Passed message is displayed. If the Test Failed message is displayed, click Check next to Test Failed. Modify the information about the database that you want to back up based on the check results.
   	Cross-Border Data Transfer Compliance Commitment	Read and select the commitment checkbox.
   Backup Destination Information	Backup Storage Type	The storage type for your backup data. The following options are available: DBS Storage (Recommended): You do not need to create a storage space. Backup data is automatically stored in DBS. You are charged based on the amount of data stored in DBS. For more information about billing, see Billable items (DMS). OSS For User: You must create a bucket in the OSS console beforehand. For more information, see Create a bucket in the console. Note This topic uses DBS Storage as an example. If you select User-owned OSS, you must also configure the OSS Bucket Name parameter. Only the Standard storage class for OSS is supported. For large data volumes, consider purchasing a subscription-based DBS storage plan to offset fees for DBS Storage. Subscription plans are more cost-effective than pay-as-you-go plans.
   	Storage Encryption	Select a storage encryption method. The following options are supported: Encrypted (Recommended): Uses the industry-standard AES-256 algorithm for encryption. With server-side encryption, OSS encrypts objects upon upload and automatically decrypts them upon download. For more information, see Server-side encryption. Non-encrypted: disables encryption.

5. On the Edit Backup Objects page, click Next.

   DBS only supports backing up the entire distributed database.

6. On the Configure Backup Time page, configure the backup time and other settings, and then click Next.

   Parameter	Description
   Full Backup Frequency	The frequency of the backup schedule. Valid values: Periodic Backup and Single Backup. Note If you select Periodic Backup, you must configure the Full Data Backup Recurrence and Start At parameters.
   Full Backup Period	The days of the week on which DBS runs the backup schedule. You can select one or more days of a week. Select at least one day of the week.
   Start Time	The start time of the backup. We recommend that you set a point in time within off-peak hours. Example: 01:00. Note If a previous full data backup is not finished at the start time of the next backup, DBS skips the next backup.
   Incremental Backup	Incremental backup is not supported for PolarDB-X databases.
   Maximum Number of Parallel Threads for Full Backup	The maximum number of concurrent threads available for a full backup. You can set this parameter to adjust the backup speed. For example, you can reduce the number of backup threads to minimize impacts on the database.

7. On the Edit Lifecycle page, specify the retention period for full backup data in DBS Storage.

8. After the preceding configurations are complete, click Precheck in the lower-right corner of the page.

9. In the Precheck dialog box, click Start Task after the precheck is passed.

   Note

   • The backup schedule is active once its Status changes to Running.

   • If the backup schedule encounters an error, identify and fix the issue promptly. For more information, see How do I fix an abnormal DBS backup schedule?. If the issue persists after you follow the suggestions, join the DBS customer support group on DingTalk (group ID: 35585947) for assistance.

Restore data