Note
This view is available starting with V4.1.0.
Purpose
Accessible only to the sys tenant, this view displays the arbitration service configurations of the current cluster.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CREATE_TIME | datetime | YES | The time when the record was created. |
| MODIFY_TIME | datetime | YES | The time when the record was last modified. |
| ARBITRATION_SERVICE_KEY | varchar(256) | NO | The name of the arbitration service. The default value is DEFAULT. |
| ARBITRATION_SERVICE | varchar(512) | NO | The address of the arbitration service. |
| PREVIOUS_ARBITRATION_SERVICE | varchar(512) | YES | If this column has a value, it indicates that the arbitration service address is being replaced. In this case, the value of ARBITRATION_SERVICE is the new address, and the value of PREVIOUS_ARBITRATION_SERVICE is the old address. |
| TYPE | varchar(64) | NO | The type of the arbitration service. The only supported value is ADDR. |
Sample query
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_ARBITRATION_SERVICE;
The query result is as follows:
+---------------------+---------------------+-------------------------+---------------------+------------------------------+------+
| CREATE_TIME | MODIFY_TIME | ARBITRATION_SERVICE_KEY | ARBITRATION_SERVICE | PREVIOUS_ARBITRATION_SERVICE | TYPE |
+---------------------+---------------------+-------------------------+---------------------+------------------------------+------+
| 2023-06-26 19:30:19 | 2023-06-30 09:42:40 | default | xx.xx.xx.192:2882 | | ADDR |
+---------------------+---------------------+-------------------------+---------------------+------------------------------+------+
1 row in set