enable_ob_protocol_v2 specifies whether to enable the OceanBase 2.0 protocol between OceanBase Database Proxy (ODP) and OceanBase Database. OceanBase 2.0 is a proprietary transmission protocol developed based on the MySQL compression protocol.
Note
The default value is changed from
FalsetoTruesince ODP V4.0.0.This parameter is deprecated in OceanBase Database V4.3.4. You can query and modify this parameter, but the setting does not take effect.
Attribute |
Description |
|---|---|
| Parameter type | Boolean |
| Default value | True |
| Value range |
|
| Effective only after ODP restart | No |
Notice
You must not set the value to False in ODP V4.x. Otherwise, some features may not take effect.
Examples
Log on to OceanBase Database in proxy mode through OceanBase Database Proxy (ODP) as the root@sys user or log on to ODP as the root@proxysys user.
Here is an example of logging on to OceanBase Database in proxy mode through ODP as the root@sys user. For more information about the parameters, see Connect to an OceanBase Database tenant by using OBClient.
[admin@obtest ~]$ obclient -uroot@sys#obcluster -h10.10.10.1 -P2883 -pNotice
To use ODP commands in OceanBase Database, the IP address (
-h) and the connection port (-P) must be the address and listening port (listen_port) of ODP.Here is an example of logging on to ODP as the root@proxysys user. The IP address (
-h) is the IP address of ODP, and the connection port (-P) is the listening port (listen_port) of ODP.[admin@obtest ~]$ obclient -uroot@proxysys -h10.10.10.1 -P2883 -pRun the following command to enable the OceanBase 2.0 protocol:
obclient [(none)]> alter proxyconfig set enable_ob_protocol_v2=True;