server_protocol

Last Updated:2026-09-04 08:23:04

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.

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

Configure to forcibly use the MySQL protocol between ODP and OceanBase Database.

obclient> alter proxyconfig set server_protocol='MySQL';

Previous topic

Next topic