You can view basic agent configuration information, real-time performance monitoring data, and information about the agent address list, as well as change the database agent configuration on the Database Proxy page.
Prerequisites
You have created a cluster instance. For more information, see Purchase an instance.
You have created a tenant in the cluster. For more information, see Create a tenant.
NoteAfter a tenant is successfully created, ApsaraDB for OceanBase automatically provides proxy services for that tenant.
View basic proxy information
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, click Instances.
In the instance list, click the name of the target cluster instance to go to the Cluster Instance Workspace page.
In the left-side navigation pane, click Database Proxy.
In the Performance Monitoring section, you can view the number of transactions processed per second, and the average time consumed in processing an SQL statement of the current cluster instance in the last hour. You can also click More in the upper-right corner to view more performance metrics.
Metric
Name
Description
Transactions per second
tps
The number of transactions processed per second in the database of the tenant. Unit: times/s.
Average SQL Statement Processing Time
qps_rt
The average amount of time consumed by the server in processing each SQL statement. Unit: ms.
In the Proxy List, you can view the basic information about the proxy service. It supports querying the proxy address information of a specific tenant based on the tenant name or ID.
Parameter
Description
Proxy Cluster
The basic information about the proxy cluster, including ID, status, proxy version, zone, specification, and proxy specifications. You can also adjust the type and specifications of the proxy cluster by referring to Change Configuration.
Tenant Name/ID
The tenant name/ID that corresponds to the proxy address. You can click on the tenant name to jump to the tenant details page.
Proxy Endpoint
The type and name of the proxy address. The types of proxy addresses include Primary, Read/Write, and Read-only addresses.
Endpoint Details
The proxy's Private and Public addresses and their Status, Maximum Connections, and Bypass Import Port.
You can click Apply to open a Public address for the Primary Endpoint, see Add Access Address.
Click the corresponding
button to modify the private and public addresses and their Maximum Connections, for details，see Modify the maximum number of connections to a proxy address.Click the corresponding
button to copy the private and public addresses.Click Enable to enable Bypass Import Port for the Private address of the Primary Endpoint, see Direct load for details.
Read Write Mode
Read and write modes for proxy addresses.
The read write mode for Primary Endpoint is
readable and writable, the read write mode for Read/Write Endpoint is read/write splitting, and the read write mode for Read-only Endpoint is read-only.
Zone
The available zones in which the proxy address is deployed.
Other Information
Network information and characteristic information of the proxy address.
Actions
You can click Configure to modify the configuration information for the current proxy address.
Change Configuration
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, click Instances.
In the instance list, click the name of the target cluster instance to go to the Cluster Instance Workspace page.
In the left-side navigation pane, click Database Proxy.
In the Proxy Cluster section, click Change Configuration.
You can choose to modify the Agent Specifications or the Number of Proxy Nodes.
To modify the Agent Specifications
You can change the size of the current specification type or switch between General and Exclusive specification types.
NoteThe minimum unit of specification adjustment is 2C4G.
To modify the Number of Proxy Nodes
NoteModifying the number of proxy nodes is only available to allowlist users. If you need to activate it, please consult technical support.
The supported number of proxy nodes for general specifications is 1-4.
The supported number of proxy nodes for exclusive specifications is 1-15.
NoteThe default upper limit for the number of nodes in exclusive specifications is 15. If you need to support larger usage scenarios, please consult technical support.
After setting the Target Specification Type, click OK to submit the changes.