This topic describes how to add a read-only replica to an instance.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance and click ··· > Manage Read-only Replicas in the Actions column.
In the Manage Read-Only Replicas dialog box, select the type of replica to add.
Add a read-only replica: A read-only replica is suitable for scenarios where read requests are isolated and the read/write service of the instance is not affected. When adding a new read-only replica, it is created only in a specific zone. It is recommended that the specification be consistent with the original one. Data synchronization can be completed through tenant settings for normal use later.
Add a read-only columnstore replica: Data tables on a read-only columnstore replica are stored in column format. The OceanBase kernel automatically converts the data storage format, which can effectively improve query and analysis performance in HTAP and OLAP data analysis scenarios. After creating a read-only columnstore replica for an instance, you need to create a read-only columnstore replica for the tenant on the tenant management page, then create a read-only endpoint to query the read-only columnstore replica, and execute the SQL for data analysis.
Note
If you use the read-only columnstore replica feature, contact OceanBase Technical Support to upgrade the database proxy to ODP V4.3.2 or later.
Click OK. The system jumps to the payment page. Select the following parameters as needed. After completion, select Service agreements and click Buy Now.
ParameterDescriptionZone Select the zone where the read-only replica will be located. Read-only Replica Specification The read-only replica supports custom specifications. The unit price is the same as that of the instance. Number of Nodes for Read-only Replica The number of nodes used by the read-only replica. Before setting the number and specification of nodes, note the following: - In a single zone, all nodes of each read-only replica must have the same specification. Specifications of read-only nodes across different read-only replicas can differ. For ease of management, it is recommended that the node specifications and instance specifications for read-only replicas in all zones remain consistent.
- For the node specification of a read-only replica, if its parent instance is V4.x, the minimum node specification supported is 4 cores. If its parent instance is V3.x, the minimum node specification supported is 8 cores.
Storage Specification The storage size for the read-only replica, in GiB. Note
The storage specification constraints for a read-only replica are the same as those for an instance.