Perform a backup for a cluster in OCP

This topic describes how to perform a backup for a cluster in OceanBase Cloud Platform (OCP).

Scheduled backup

You can create a backup strategy for a cluster to be backed up in OCP. This way, backup tasks can be started as scheduled based on this backup strategy.

1. Log on to the OCP console.

2. In the left-side navigation pane, choose Backup and Recovery > Backup.

3. On the Backup page, click New Backup Strategy in the upper-right corner.

4. Select the cluster to back up from the drop-down list.

   This topic describes how to perform a physical backup on an OceanBase cluster whose version is OceanBase Database V3.2.4.

5. Specify the following storage configuration parameters and click Test.

   Parameter	Description
   Storage Configuration Name	You can configure a custom configuration or select an existing configuration. For a custom configuration, specify the following fields. If you select an existing configuration, click Select Existing Configuration. Then, the system automatically populates the following fields.
   Storage Type	The type of storage media for backup files. Valid values: OSS: Alibaba Cloud Object Storage Service, a cloud storage service File: physical storage
   Storage Directory	The directory where backup files are stored.
   Alert Threshold for Backup Storage Capacity	The default threshold is 80%. An alert is triggered when the utilization of the backup storage reaches this threshold.
   Domain	Endpoint is only displayed when Storage Type is Object Storage Service (OSS). It is the domain name used to access the cloud storage of backup files.
   User	User is only displayed when Storage Type is OSS. It is the user used to access the cloud storage of backup files.
   AccessKey Pair	This parameter is displayed only when Storage Type is set to OSS. It is the AccessKey pair used to access the cloud storage of backup files.

   

6. Specify fields in the Scheduling Settings section.

   • Scheduling Cycle: If you set the scheduling cycle to one month, the maximum value of this parameter is 10 days.

   • If you need to perform physical backups, log backup must be enabled.

     

7. Schedule the clearing of expired backup files.

   Enable the automatic backup clearing feature and configure retention days of the backup files.

   Note

   If the backup destination is set to OSS, you cannot configure the automatic clearing of expired backup files in OCP. However, you can execute SQL statements to manually clear expired backup files. For more information about the operation, see Automatically clear backup data for clusters.

   

8. Specify alert thresholds. You can specify the timeout threshold for data backup tasks, alert threshold for log backup delays, and alert threshold for the number of days without successful data backup. After you set a threshold, an alert is triggered when the threshold is reached.

   

9. (Optional) Configure a secondary backup task.

   Secondary backup is the process to back up backup files. To perform a secondary backup, you must enable and configure secondary backup. For more information about the operation, see Perform a secondary backup for a cluster in OCP.

   Note

   When you enable secondary backup, the log splitting feature is automatically enabled by default.

   1. Configure scheduling settings for a second backup task.

      

   2. Configure storage settings for a second backup task.

      Note

      The backup files of secondary backup and regular backup tasks must be restored at different locations. This is because a secondary backup task backs up the existing backup files and ensures that an OceanBase database can be restored when a disaster affects the backup data of a regular backup task.

10. Click Submit.

Back up now

You can create an instant backup task in OCP to initiate an instant backup operation.

1. Log on to the OCP console.

2. In the left-side navigation pane, choose Backup & Recovery > Backup. Then, choose Back Up Now > Back Up Cluster in the upper-right corner of the page.

3. Select the cluster to back up.

   Select the cluster to back up in the drop-down list. The system automatically populates the Storage Configuration fields.

4. Click Test to test the storage configuration.

5. Select a data backup method.

   Full Backup and Incremental Backup methods are supported.

   Notice

   You must perform a full backup before you can perform an incremental backup. Otherwise, the following error is returned during the precheck: "full data backup needed before incremental data backup."

6. Click Back Up Now.