Overview

This topic describes the transfer modes of the log transfer service and region-based cascading log transfer.

The log transfer service automatically synchronizes REDO logs from the primary cluster to standby clusters. It provides the following capabilities:

• Allows the primary cluster to send REDO logs to a standby cluster.

• Allows a standby cluster to pull REDO logs from the primary cluster when logs in the standby cluster are out-of-sync with those in the primary cluster.

• Manages the synchronization parameters of all standby clusters, and supports cascading log transfer.

Transfer modes

OceanBase Database supports two log transfer modes. You must configure a transfer mode for each standby cluster.

• Synchronous mode (SYNC)

  In this mode, the REDO logs of the primary cluster are synchronously transferred to the destination standby cluster. The persistence of a REDO log is considered complete after the log is persistently stored in both the primary cluster and the standby cluster in SYNC mode. The transaction submission latency increases the network latency of the primary and standby clusters and the log persistence duration of the standby clusters.

  In MAXIMUM PROTECTION or MAXIMUM AVAILABILITY mode, you can set only one standby cluster to be in SYNC mode for the primary cluster. In MAXIMUM PERFORMANCE mode, this transfer mode does not take effect, and you can set a custom number of standby clusters to be in SYNC mode.

  You can set the primary cluster to be in SYNC mode, but this setting takes effect only when the cluster becomes a standby cluster after switchover. In MAXIMUM PROTECTION or MAXIMUM AVAILABILITY mode, the primary cluster must be set to be in SYNC mode before switchover so that at least one standby cluster is in SYNC mode after the switchover.

• Asynchronous mode (ASYNC)

  In this mode, the REDO logs of the primary cluster are asynchronously transferred to the destination standby cluster. The transaction submission latency is not subject to the destination standby cluster.

The log transfer mode defines whether to synchronously transfer logs from the primary cluster to a standby cluster. OceanBase supports one primary cluster and multiple standby clusters, and different standby clusters may have different log transfer modes. The log transfer mode varies based on the protection mode. The following table describes log synchronization information in different log transfer modes for standby clusters in different protection modes. For more information, see Overview.

Cascading log transfer

OceanBase Database provides multiple log streams. By default, each partition has one log stream. Logs are synchronized from the primary cluster to standby clusters by using log streams. Log streams are independent of each other.

After the leader of the primary cluster generates logs, the leader synchronizes the logs to the majority replicas of the primary cluster, and waits until the persistence of logs in the majority replicas is complete. If no standby cluster is in SYNC mode, the leader of the primary cluster immediately returns a log persistence success response. If a standby cluster in SYNC mode exists, the leader of the primary cluster sends the logs to the leader of the standby cluster. The leader of the standby cluster synchronizes the logs to the majority replicas of the standby cluster, waits until the persistence of the majority replicas is complete, and returns a success response to the leader of the primary cluster. Then, the leader of the primary cluster returns a log persistence success response.

Therefore, in SYNC mode, a standby cluster directly synchronizes logs from the leader of the primary cluster, instead of from other replicas. However, in ASYNC mode, OceanBase Database supports region-based cascading log transfer, allowing a standby cluster to synchronize logs from a nearby upstream replica. Specifically, a standby cluster can synchronize logs from a replica of the primary cluster or a replica of another standby cluster replica in the same region as the primary cluster.

Region-based cascading log transfer ensures that only one copy of logs is transmitted in cross-region deployment scenarios, reducing cross-region network bandwidth consumption.

The following figure shows the cascading of standby clusters to a replica of the primary cluster in the same region. In this scenario:

• The primary cluster is deployed across regions. The majority of replicas and the leader are deployed in Region SH, and the minority replicas are deployed in Region HZ.

• The standby cluster S1 is deployed in Region SH and is set to be in SYNC mode. Logs are synchronously transferred from the leader of the primary cluster to the leader of the standby cluster.

• The standby cluster S2 is deployed in Region HZ and is set to be in ASYNC mode. One replica of the primary cluster is deployed in Region HZ. Therefore, the standby cluster is automatically cascaded to the replica. The replica synchronizes logs from the leader of the primary cluster, and the leader of the standby cluster asynchronously transfers logs from the replica.

The following figure shows the cascading of standby clusters. In this scenario:

• Standby clusters S1 and S2 are both set to be in ASYNC mode. The primary cluster has no replica in Region HZ. Therefore, the standby cluster S1 asynchronously transfers logs from the leader of the primary cluster across regions.

• The standby cluster S2 is deployed in the same region as the standby cluster S1, and therefore automatically treats the standby cluster S1 as an upstream replica and asynchronously transfers logs from the leader of the standby cluster S1.