Modify the maximum number of connections for a database proxy address

Overview

The maximum number of connections for a database proxy address is the highest number of client connections that a proxy server can handle at one time. When clients use a proxy server to access a target server or network resource, each connection consumes proxy server resources. This limit is set to prevent the server's performance from degrading or crashing due to resource overload. When the maximum number of connections is reached, the proxy server will deny new connection requests, queue them, or process them according to its configuration and policies.

Prerequisites

Before you modify the maximum number of connections for a database proxy address, ensure that the following requirements are met.

• The target database proxy address is running.

  Note

  Modifying the maximum number of connections for a public network address is a whitelisted feature. To use this feature, contact OceanBase technical support.

• The tenant is running.

Procedure

You can modify the maximum number of connections in two ways:

• Method 1: Log on to the OceanBase Management Console. On the Tenant Workspace page, in the deployment diagram area, hover over the proxy card and click the button.

• Method 2: Log on to the OceanBase Management Console. On the Database Proxy page, in the proxy address list area, click the button to the right of Maximum Connections.

The following example uses Entry Point 2:

1. Log on to the OceanBase Management Console .

2. In the navigation pane on the left, click Instance List.

3. In the instance list, find the target cluster instance and click its name to open the Cluster Instance Workspace page.

4. In the navigation pane on the left, click Database Proxy.

5. In the Agent Address List, click the button to the right of Maximum Connections.

6. Set Target Maximum Connections as required. The step size is 100.

   

   Note

   • The recommended maximum number of connections depends on the tenant's specifications. We recommend 400 connections per 1 GB of memory. For example, for a tenant with a specification of 8 cores and 16 GB of memory, the recommended maximum number of connections is 16 * 400 = 6400.Multiple database proxy addresses for a tenant share this connection limit. Set the limit for each proxy address based on your business needs. To set a value higher than the recommended value, contact OceanBase technical support to be added to the whitelist.

   • If the number of existing connections is greater than the new target limit, some application requests to connect to the database might fail. In this case, if your application does not have an automatic reconnection mechanism, you must manually trigger the application to reconnect to the database.

7. Click OK to submit the change.