Backup and restore

OceanBase Deployer (obd) allows you to back up and restore tenants by using commands since V3.2.0. This topic describes the tenant backup and restore procedures.

Prerequisites

Make sure that the following conditions are met:

• You have installed obd V3.2.0 or later. We recommend that you install the latest version. For more information, see Install obd.

• obshell has been installed in the cluster where the tenant to back up or restore resides and is running properly.

• You have configured an appropriate backup destination.

Back up a tenant

This section describes how to back up the obmysql tenant in the test cluster. You need to modify related information based on the actual situation. We recommend that you use Alibaba Cloud Object Storage Service (OSS) as the backup destination.

1. Configure the backup information.

   OSS

   NFS

   AWS S3

   obd cluster tenant set-backup-config test obmysql -d 'oss://oceanbase-test-bucket/backup/data?host=****.aliyun-inc.com&access_id=****&access_key=****&delete_mode=delete' -a 'oss://oceanbase-test-bucket/backup/log?host=****.aliyun-inc.com&access_id=****&access_key=****&delete_mode=delete'
   

   Here, oss:// indicates that OSS is used as the backup destination type, the bucket name is oceanbase-test-bucket, the storage paths in the bucket are /backup/data and /backup/log, and ? is used to separate other parameters of the path. The host parameter specifies the host address of the bucket. The access_id and access_key parameters specify the access key of the account to access OSS. The cleanup mode is set to delete.

   For more information about the parameters in data backup path, see SET DATA_BACKUP_DEST.

   obd cluster tenant set-backup-config test obmysql -d 'file:///data/nfs/backup/data' -a 'file:///data/nfs/backup/log'
   

   obd cluster tenant set-backup-config test obmysql -d 's3://oceanbase-test-bucket/backup/data?host=s3.<region>.amazonaws.com&access_id=****&access_key=****&s3_region=****&delete_mode=delete' -a 's3://oceanbase-test-bucket/backup/log?host=s3.<region>.amazonaws.com&access_id=****&access_key=****&s3_region=****&delete_mode=delete'
   

   Here, s3:// indicates that S3 is used as the backup destination type, the bucket name is oceanbase-test-bucket, the storage paths in the bucket are /backup/data and /backup/log, and ? is used to separate other parameters of the path. The host parameter specifies the domain name of S3. The access_id and access_key parameters specify the access key of the account to access S3. The s3_region parameter is required, and it specifies the region where the S3 bucket is located. The cleanup mode is set to delete.

   For more information about the parameters in data backup path, see SET DATA_BACKUP_DEST.

2. Perform backup.

   Perform full backup

   Perform incremental backup

   obd cluster tenant backup test obmysql
   

   obd cluster tenant backup test obmysql -m incremental
   

3. View the backup task.

   obd cluster tenant backup-show test obmysql
   

   Here is an example of viewing the backup task of the obmysql tenant in the test cluster. The OBServer node in this example is 10.10.10.1. You must modify the information based on the actual situation. The output is as follows, where the value of the task_status column is COMPLETED, indicating backup success.

   +---------------------------------------------------------------------------------------------------------+
   |                               backup task details of backup tenant obmysql                              |
   +-----------+----------------------------------+----------------------------------+-------------+---------+
   | tenant_id | start_timestamp                  | end_timestamp                    | task_status | comment |
   +-----------+----------------------------------+----------------------------------+-------------+---------+
   | 1002      | 2025-03-26T14:56:47.623096+08:00 | 2025-03-26T14:58:15.234362+08:00 | COMPLETED   | -       |
   +-----------+----------------------------------+----------------------------------+-------------+---------+
   

4. (Optional) Cancel the backup task.

   obd cluster tenant backup-cancel test obmysql
   

   You can run this command to cancel a backup task not in the COMPLETED state. A few minutes after this command is executed, you can run the obd cluster tenant backup-show command to verify whether the backup task has been successfully canceled. The output is as follows, where the value of the task_status column is CANCELED, indicating that the backup task has been canceled.

   +--------------------------------------------------------------------------------------------------------------------+
   |                                    backup task details of backup tenant obmysql                                    |
   +-----------+----------------------------------+----------------------------------+-------------+--------------------+
   | tenant_id | start_timestamp                  | end_timestamp                    | task_status | comment            |
   +-----------+----------------------------------+----------------------------------+-------------+--------------------+
   | 1002      | 2025-03-26T15:15:49.728777+08:00 | 2025-03-26T15:16:18.547451+08:00 | CANCELED    | Operation canceled |
   +-----------+----------------------------------+----------------------------------+-------------+--------------------+
   

Restore a tenant

This section describes how to create the restore_1 tenant in the obtest cluster and restore the backup data to this tenant. You must modify the information based on the actual situation.

1. Perform restore.

   OSS

   NFS

   AWS S3

   [root@ob-WB01191894-20250325105059 ~]# obd cluster tenant restore obtest restore_1 'oss://oceanbase-test-bucket/backup/data/?host=***.aliyun-inc.com&access_id=***&access_key=***' 'oss://oceanbase-test-bucket/backup/log/?host=***.aliyun-inc.com&access_id=***&access_key=***' --memory_size=2G --max_cpu=2
   

   You can use command options to configure resources available for the tenant to restore. If you do not specify the options, all remaining resources of the cluster are used to create the tenant. For more information, see the obd cluster tenant restore section in Cluster commands.

   [root@ob-WB01191894-20250325105059 ~]# obd cluster tenant restore obtest restore_1 'file:///data/nfs/backup/data' 'file:///data/nfs/backup/log' --memory_size=2G --max_cpu=2
   

   You can use command options to configure resources available for the tenant to restore. If you do not specify the options, all remaining resources of the cluster are used to create the tenant. For more information, see the obd cluster tenant restore section in Cluster commands.

   [root@ob-WB01191894-20250325105059 ~]# obd cluster tenant restore obtest restore_1 's3://oceanbase-test-bucket/backup/data?host=s3.<region>.amazonaws.com&access_id=****&access_key=****&s3_region=****' 's3://oceanbase-test-bucket/backup/log?host=s3.<region>.amazonaws.com&access_id=****&access_key=****&s3_region=****' --memory_size=2G --max_cpu=2
   

   You can use command options to configure resources available for the tenant to restore. If you do not specify the options, all remaining resources of the cluster are used to create the tenant. For more information, see the obd cluster tenant restore section in Cluster commands.

2. View the restore task.

   obd cluster tenant restore-show obtest restore_1
   

   Here is an example of viewing the restore task of the restore_1 tenant in the obtest cluster. You must modify the information based on the actual situation. The output is as follows, where the value of the task_status column is SUCCESS, indicating restore success.

   +--------------------------------------------------------------------------------------------------------+
   |                            restore task details of restore tenant restore_1                            |
   +-----------+----------------------------------+---------------------------------+-------------+---------+
   | tenant_id | start_timestamp                  | end_timestamp                   | task_status | comment |
   +-----------+----------------------------------+---------------------------------+-------------+---------+
   | 1         | 2025-03-26T15:27:00.930773+08:00 | 2025-03-26T15:32:11.33193+08:00 | SUCCESS     | -       |
   +-----------+----------------------------------+---------------------------------+-------------+---------+
   

3. View tenants in the cluster.

   obd cluster tenant show obtest
   

   The output is as follows:

   +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
   |                                                                                    tenant basic info                                                                                    |
   +-------------+-------------+--------------------+--------------+---------+---------+-------------+---------------------+---------------------+---------------+-------------+-------------+
   | tenant_name | tenant_type | compatibility_mode | primary_zone | max_cpu | min_cpu | memory_size | max_iops            | min_iops            | log_disk_size | iops_weight | tenant_role |
   +-------------+-------------+--------------------+--------------+---------+---------+-------------+---------------------+---------------------+---------------+-------------+-------------+
   | sys         | SYS         | MYSQL              | RANDOM       | 3.0     | 3.0     | 1G          | 9223372036854775807 | 9223372036854775807 | 2G            | 3           | PRIMARY     |
   | restore_1   | USER        | MYSQL              | RANDOM       | 2.0     | 2.0     | 2G          | 9223372036854775807 | 9223372036854775807 | 6G            | 2           | PRIMARY     |
   +-------------+-------------+--------------------+--------------+---------+---------+-------------+---------------------+---------------------+---------------+-------------+-------------+
   

4. (Optional) Cancel the restore task.

   You can run the following command to cancel the restore task of a tenant. Note that you can cancel only a restore task not in the SUCCESS state.

   obd cluster tenant restore-cancel obtest restore_1
   

   To verify whether the restore task has been successfully canceled, you can run the obd cluster tenant show or obd cluster tenant restore-show command. If the obtest tenant is not displayed in the output of the obd cluster tenant show command, or if an error indicating that the obtest tenant does not exist is returned for the obd cluster tenant restore-show command, the task has been successfully canceled.

References

• For more information about the backup and restore feature of OceanBase Database, see Introduction to physical backup and restore.

• For more information about the parameters in data backup path, see SET DATA_BACKUP_DEST.