Note
This parameter is introduced in ODP V4.3.4.
Description
server_protocol specifies the type of the protocol used between OceanBase Database Proxy (ODP) and OceanBase Database.
Attributes
| Attribute |
Description |
| Parameter type |
String |
| Default value |
Auto |
| Value range |
Valid values: Auto, MySQL, Compressed MySQL, and OceanBase 2.0, which are case-insensitive.
Auto: When enable_single_leader_node_routing is set to True, the MySQL protocol is used for tenants deployed in leader concentration mode, and OceanBase Protocol 2.0 is used in other scenarios. When enable_single_leader_node_routing is set to False, OceanBase Protocol 2.0 is used for all tenants.MySQL: The MySQL protocol is forcibly used.Compressed MySQL: The compression protocol is forcibly used. This value is not recommended. OceanBase Protocol 2.0 is also capable of data compression and is recommended when you require this feature.OceanBase 2.0: OceanBase Protocol 2.0 is forcibly used. |
| Effective only after ODP restart |
No, effective upon reconnection |
Examples
Configure to forcibly use the MySQL protocol between ODP and OceanBase Database.
obclient> alter proxyconfig set server_protocol='MySQL';
References
enable_single_leader_node_routing
