This topic describes how to configure a primary-standby synchronization strategy. The strategy uses tenant parameter templates to synchronize tenants in different compatibility modes.
Overview
The primary-standby synchronization strategy dynamically matches tenants based on the selected tenant parameter templates. Select the templates required by your workloads. The system then synchronizes matching tenants to the standby instance.
Tenant parameter template: The system provides the following parameter templates, each corresponding to different business scenarios and compatibility modes:
Parameter TemplateDescriptionOLTP Simple Transactions Suitable for simple transaction processing scenarios. Supports MySQL and Oracle compatibility modes. OLTP Complex Transactions Suitable for complex transaction processing scenarios. Supports MySQL and Oracle compatibility modes. HTAP Mixed Workloads Suitable for hybrid transaction and analytical processing scenarios. Supports MySQL and Oracle compatibility modes. OLAP Online Analytics Suitable for online analytical processing scenarios. Supports MySQL and Oracle compatibility modes. NoSQL Suitable for NoSQL scenarios. Supports HBase API and Table API compatibility modes. Note
- This is an allowlist feature. To enable it, contact OceanBase Technical Support.
- The system dynamically matches tenants based on the selected parameter template. Only tenants that match the template are included in primary-standby synchronization.
Compatibility mode: The tenant's compatibility mode determines the data storage format and access method. Currently, MySQL compatibility mode, Oracle compatibility mode, and Table API compatibility mode are supported. Different parameter templates correspond to different compatibility modes. When setting the synchronization strategy, ensure the tenant compatibility modes of the primary-standby instances are consistent.
Prerequisites
A primary instance and a standby instance have been created, and both are in the Running state. For more information, see Create a standby instance.
Tenants have been created for the primary-standby instances.
You have Project Administrator and Instance Administrator permissions.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target cluster and click the arrow to the left of the instance to expand the tenant information. Then, click the target tenant name to go to the Tenant Workspace.
Click Topology Diagram > Configure Primary-Standby Sync Strategy.
In the dialog box that appears, view the current tenant parameter template and the matching tenant information.
Tenant Parameter Template: Select the parameter template whose tenants you want to synchronize. The system automatically matches tenants based on the selected template.
Tenant List: View the tenants that match the current parameter template, including the tenant name and ID, parameter template, and compatibility mode.
Confirm the configuration and click OK.
In the confirmation dialog box, review the considerations, enter
confirm, and click OK to complete the primary-standby synchronization strategy configuration.Warning
- If you cancel a parameter template, the standby tenants and their backup data that have been synchronized under this template will be deleted. Features that depend on standby tenants, such as global addresses and read-write splitting, will also become invalid.
- If you cancel a parameter template, tenants using this template will synchronize and create corresponding standby tenants in the standby instance.
- Canceling a parameter template is irreversible. Proceed with caution.
Related operations
Configure a global endpoint for primary-standby instances. For details, see Configure global endpoint.
View the primary-standby instance workspace. For details, see Primary-standby instance workspace.
Initiate a failover for primary-standby instances. For details, see Initiate failover.