All Products
Search
Document Center

Backup and restoration overview

Last Updated: Aug 30, 2021

On the Backup and Recovery page, you can initiate cluster restoration and backup, modify backup configurations, and view information about backup policies and data backup and restoration tasks.

Backup principle

OceanBase Database is a read/write splitting system. Internal data of OceanBase Database is divided into baseline data in the SSTable format and incremental data in the memtable format based on the storage method. In physical backup of OceanBase Database, the baseline data of a major compaction and the commit logs of incremental data generated after the major compaction are copied to the storage system in a remote IDC.

  • The baseline data is the total data compacted and stored on disks. It is split into multiple shards, copied into multiple replicas, and evenly distributed in data files in OBServers.

  • The incremental data is all the new data generated after the point of time of the current major compaction. It is usually stored in the memtable and also instantiated into a commit log file.

Backup content

The backup and restoration feature is applicable 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, as well as other data.

The smallest backup granularity supported by OceanBase Database is a cluster. That is, you can back up data only for an entire cluster.

Backup content

The backup and restoration feature is applicable 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, as well as other data.

The smallest backup granularity supported by OceanBase Database is a cluster. That is, you can back up data only for an entire cluster.

Page overview

Go to the cluster details page. In the left-side navigation pane, click Backup and Recovery. On the Backup and Recovery page, you can view the backup status, files, latest extreme backup time, and log backup status and latency of the current cluster. You can also perform daily backup and restoration operations. For more information, see Initiate restoration, Back up now, Data backup.1