Obtain and modify configurations

This topic describes how to obtain and modify the configurations of OceanBase Database Proxy (ODP).

Obtain configurations

Log on to ODP with the root@proxysys account and run the following command to obtain the ODP configurations:

SHOW proxyconfig [LIKE '%var_name%'];

Modify configurations

You have two options to modify the ODP configurations:

• Modify configurations when starting ODP

  Include the following option in your startup command:

  -o <var_name> = <var_value>
  

• Modify configurations when ODP is running

  Log on to ODP with the root@proxysys account and run the following command:

  ALTER proxyconfig SET <var_name> = <var_value>