On the backup page, you can perform operations such as performing immediate backup, modifying the backup strategy, initiating restore, and also viewing the task information related to data backups, backup strategies, and data restores.
Backup principles
OceanBase Database is a read/write separation system. The internal data is divided into baseline data stored in the SSTable format and incremental data stored in the MemTable format. OceanBase Database performs physical backups by copying the baseline data from a major compaction and the incremental data's commit logs to the storage system in the IDC.
Baseline data is the sum of all data that has been compacted and written to disk. It is divided into multiple shards and replicated across multiple replicas, evenly distributed across the data files of each OBServer node.
Incremental data consists of all updates made after the last major compaction. It is typically stored in the MemTable's in-memory tables and also instantiated as Commit Log files.
OceanBase Database provides two flexible and efficient backup mechanisms: physical backup and logical backup. You can choose the appropriate one based on your specific application scenarios and resource requirements.
Physical backup: OceanBase Database captures the baseline data at a specific major compaction and combines it with the subsequent incremental Commit Logs. These data are then precisely replicated to storage facilities within the same region or across regions to achieve a physical-level restore of the entire database.
Logical backup: OceanBase Database's logical backup is a more abstract method of backup, focusing on backing up data based on logical structures such as tables, indexes, triggers, and stored procedures. Logical backups are highly selective, allowing users to target specific data for backup, such as a particular table within a database or a specific database under a tenant. This method not only backs up the data itself but also includes the logical definitions and specific content of database objects.
Backup content
The backup feature applies to all operations in OceanBase Database. You can back up and restore logical data such as user privileges, table definitions, system variables, user information, and view information, and data of other types.
Page overview
After entering the instance details page, click Backup in the left-side navigation pane to go to the backup page. Here, you can view the current instance's backup status and recent data backup information. You can also view information about local full backups and local archive backups, including data and log backups.
Note
Archive backup is currently only supported by Alibaba Cloud and is an allowlist feature. To enable it, please contact OceanBase Technical Support.
On the backup page, you can view the basic backup information about the current instance, including the current backup status and the resource usage and billing for local backup.
Free quota: Displays the free data backup and log backup quotas. Backup data exceeding the free quota will be billed automatically.
Paid capacity: You can view the resource capacity that exceeds the free quota and requires payment.
Different cloud vendors have different billing strategies and free durations for their object storage services. For more information, see Backup billing.
You can also perform routine backup and restore operations, including performing immediate backup, modifying the backup strategy, initiating restore, and also viewing the task information related to data backups, backup strategies, and data restores.