Replace the arbitration service

If the OBServer node where the arbitration service is deployed fails, you can deploy the arbitration service on another OBServer node instead.

Prerequisites

The OceanBase Database software is installed on the new OBServer node and the arbitration service is enabled.

Procedure

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

   Note that you must specify the corresponding fields in the following sample code based on your actual database configurations.

   obclient -h10.xx.xx.xx -P2883 -uroot@sys -p***** -A
   

   For more information about how to connect to a database, see Database connection overview (MySQL mode) or Database connection overview (Oracle mode).

2. Execute the following statement to replace the arbitration service:

   ALTER SYSTEM REPLACE ARBITRATION SERVICE 'curr_arb_server_ip:curr_arb_server_port' WITH 'new_arb_server_ip:new_arb_server_port';
   

   Parameters:

   • curr_arb_server_ip:curr_arb_server_port: the IP address and remote procedure call (RPC) port of the faulty OBServer node on which the arbitration service is deployed. By default, Port 2882 is used.

   • new_arb_server_ip:new_arb_server_port: the IP address and RPC port of the new OBServer node on which the arbitration service is deployed. By default, Port 2882 is used.

   Sample statement:

   obclient [(none)]> ALTER SYSTEM REPLACE ARBITRATION SERVICE '100.xx.xx.x2:2882' WITH '100.xx.xx.x3:2882';
   Query OK, 0 rows affected
   

3. (Optional) If the execution of the replacement command times out, execute the following statement to query the DBA_OB_ARBITRATION_SERVICE view for the replacement status:

   SELECT * FROM DBA_OB_ARBITRATION_SERVICE;
   

   If the value of the PREVIOUS_ARBITRATION_SERVICE field in the query result is not empty, the replacement is in progress in the background. Wait for the replacement process to complete. If the value in the PREVIOUS_ARBITRATION_SERVICE column is empty, the arbitration service is replaced.

   For more information about the DBA_OB_ARBITRATION_SERVICE view, see DBA_OB_ARBITRATION_SERVICE.

More information

For more information about the arbitration service, see the following topics:

• Overview

• Enable the arbitration service

• Disable the arbitration service

• Modify the downgrade timeout period

• Remove the arbitration service