OceanBase Database allows you to configure one primary cluster and up to 31 standby clusters. You can use the SQL command-line interface (CLI) or the OCP platform to manage primary and standby clusters.
Primary cluster
The primary cluster is the production cluster and the only cluster that accepts business writes and strongly consistent reads. Its role is PRIMARY.
Standby cluster
The standby cluster is the data backup of the primary cluster that ensures transaction consistency. The primary cluster automatically transmits REDO logs to the standby cluster, and then the standby cluster automatically applies REDO logs. The data and schema are physically consistent in the primary cluster and the standby cluster. The underlying layer automatically performs checksum verification to ensure the correctness and consistency of the data.
The standby cluster is essentially a physical standby database. Its role is PHYSICAL STANDBY.
Configuration example
The following figure shows a typical primary/standby database configuration, including one primary cluster and one standby cluster. They synchronize the data by transmitting REDO logs. You can deploy the primary and standby clusters in different locations to meet different disaster recovery requirements.
Typical primary/standby database configuration
