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 upper limit of the number of client connections that a proxy server can handle simultaneously. When a client accesses the target server or network resources through a proxy server, each connection will occupy the resources of the proxy server. The maximum number of connections is a preset limit value used to prevent the server from degrading performance or crashing due to resource overload. When the maximum number of connections is reached, new connection requests will be rejected by the proxy server, queued to wait, or handled according to the proxy server's configuration and policies.

Prerequisites

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

• The target proxy address is in operation.

  Note

  Modifying the maximum number of connections to a public address is a feature available only for users on the allowlist. If you need 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 in to the ApsaraDB for OceanBase console. In the Deployment Diagram section of the Tenant Instance Workspace page, click next to Maximum Connections on the Proxy card.

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

The following steps take Method 2 as an example.

1. Log in 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 List, click next to Maximum Connections.

6. In the Edit Maximum Connections dialog box, set Target Maximum Connections based on actual needs, adjusting in increments of 100.

   

   Note

   • By default, the value range is 1,000 to 5,000. If you need to change the value to more than 5,000, contact OceanBase Technical Support to open an allowlist. If you need to change the value to more than 50,000, contact OceanBase Technical Support to submit a ticket.

   • The recommended maximum number of connections for the current tenant specification is the cluster/tenant's maximum connections, with a suggested value of 400 connections per 1 GB of memory. For example, for a tenant with an 8C 16GB specification, the recommended maximum number of connections is 16 * 400 = 6400. Multiple database proxy addresses for a tenant will share this maximum connection count. Set the maximum number of connections for each proxy address reasonably based on business requirements.

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

7. Click OK.