Set the log transfer parameter for a standby cluster

OceanBase Database allows you to set the log transfer parameter to control log transfer.

Procedure

1. Log on to the sys tenant as the root user.

2. In the primary cluster, execute the following statement to set REDO_TRANSPORT_OPTIONS for a standby cluster.

   Example:

   obclient> ALTER SYSTEM MODIFY CLUSTER 'obcluster' CLUSTER_ID 3 SET REDO_TRANSPORT_OPTIONS = 'SYNC NET_TIMEOUT=30000000';
   

   In this example:

   • The cluster name is obcluster.

   • The cluster ID is 3.

   • The transfer mode is SYNC, and NET_TIMEOUT is set to 30 in seconds.

     • SYNC/ASYNC: specifies the log transfer mode. SYNC indicates the synchronous mode, and ASYNC indicates the asynchronous mode. The default value is ASYNC.

     • NET_TIMEOUT: specifies the timeout duration for the primary cluster to wait for a response from a standby cluster in SYNC mode when the MAXIMUM AVAILABILITY protection mode is adopted. If no response is received after the timeout duration elapses, the primary cluster is automatically downgraded to the ASYNC mode. NET_TIMEOUT is meaningless in other modes.

View the log transfer settings of a standby cluster

You can view the log transfer settings of a cluster in the following ways:

Log on to the sys tenant as the root user.

• Execute the following statement to query the V$OB_STANDBY_STATUS view of the primary cluster to view the log transfer settings of each standby cluster:

  obclient> SELECT CLUSTER_ID, REDO_TRANSPORT_OPTIONS FROM V$OB_STANDBY_STATUS;
  

  For more information about the fields in the V$OB_STANDBY_STATUS view, see v$ob_standby_status.

• Execute the following statement to query the V$OB_CLUSTER view of a cluster to view its log transfer settings:

  obclient> SELECT CLUSTER_ID, REDO_TRANSPORT_OPTIONS FROM V$OB_CLUSTER;
  

  For more information about the fields in the V$OB_CLUSTER view, see v$ob_cluster.