ApsaraDB for OceanBase:Modify the maximum number of connections to a proxy address

Overview

The maximum number of connections to a proxy address refers to the maximum number of client connections that can be concurrently processed by a proxy server. When clients access the target server or network resources through a proxy server, each connection will occupy resources on the proxy server. The maximum number of connections is a limit that is preset to prevent the server from performance downgrade or crash due to resource overload. After the number of connections reaches the specified threshold, new connection requests will be rejected by the proxy server and wait in a queue, or be processed based on the configuration and strategy of the proxy server.

Prerequisites

Before you modify the maximum number of connections to a proxy address, make sure that the following conditions are met:

• The proxy address is in the running state.

  Note

  Modifying the maximum number of connections to a public address is a feature available for users on the allowlist. If you want to use this feature, contact OceanBase Technical Support.

• The current tenant is in the running state.

Procedure

You can modify the maximum number of connections to a proxy address by using either of the following methods:

• Method 1: Log on to the ApsaraDB for OceanBase console. In the deployment diagram section of the Tenant Workspace page, hover over the proxy card and click .

• Method 2: Log on to the ApsaraDB for OceanBase console. In the proxy address list of the Database Proxy page, click next to Maximum Connections.

The following procedure takes Method 2 as an example.

1. Log on to the ApsaraDB for OceanBase console.

2. In the left-side navigation pane, click Instances.

3. In the instance list, click the name of the target cluster instance to go to the Cluster Instance Workspace page.

4. In the left-side navigation pane, click Database Proxy.

5. In the proxy address list, click next to Maximum Connections.

6. Adjust Target Maximum Connections as needed. The step size for adjustment is 1000.

   

   Note

   • By default, the value range is 1000 to 5000. To modify the maximum number of connections to a value greater than 5000, contact OceanBase Technical Support to enable the allowlist feature. To modify the maximum number of connections to a value greater than 50000, contact OceanBase Technical Support to submit a ticket.

   • If the number of existing connections exceeds the new value, some business may fail to connect to the database. In this case, manually trigger reconnection if automatic reconnection is not supported.

7. Click OK.