When the parameter version of an OceanBase Database Proxy (ODP) is different from that of the ODP cluster, you can refresh the configurations of the ODP based on your business requirements.
Refresh ODP configurations by using an SQL statement
You can refresh the configurations of a single ODP by executing the ALTER PROXYCONFIG statement.
Use the
root@proxysysaccount to connect to the ODP.Execute the following statement to view the value of the parameter to be refreshed.
Sample statement:
obclient> SHOW PROXYCONFIG LIKE 'fetch_proxy_bin_random_time';You can also execute the
SHOW PROXYCONFIGstatement to view all parameters of the ODP.Execute the following statement to modify the parameter value:
obclient> ALTER PROXYCONFIG SET fetch_proxy_bin_random_time='300s';
Refresh ODP configurations in OCP
Prerequisites
You have logged on to the OceanBase Cloud Platform (OCP) console and are assigned the OBPROXY_MANAGER role.
In the ODPs list on the Overview page of the ODP cluster, if the Status value of an ODP is Running and an exclamation point (!) is displayed in the Parameter Version column, the parameter version of the ODP is different from that of the ODP cluster. In this case, you need to refresh the configurations of the ODP.
Refresh the configurations
Log on to the OCP console.
In the left-side navigation pane, click OBProxy.
In the ODP cluster list, click the target ODP cluster. Then, the Overview page of the ODP cluster appears.
Perform the following operations:
Notice
Refreshing ODP configurations interrupts the connection. Proceed with caution.
To refresh a single ODP, find it in the OBProxies list, click the More icon in the Actions column, and then select Refresh Configurations.
To refresh ODPs in batch, find the target ODPs in the OBProxies list and click Batch Refresh in the upper-right corner of the list.
In the dialog box that appears, click OK.
In the dialog box that appears, click View Task to check the progress. If the value of the Task Status field is Completed, the refresh is successful.