Tencent Cloud

Recent Pages

Rebalancing the Load

Last updated: 2024-03-25 16:24:32

After enabling the database proxy, you can check the connection count or monitor the performance of each proxy node to identify any access imbalances. If there are a significant number of long-lived connections in your business, adding additional database proxy nodes may introduce new load imbalances. If there is an uneven distribution of connections among the nodes, you can manually perform a reload balancing operation through the console. This helps evenly distribute the connections and address any potential load imbalances.
Prerequisites
You have enabled the database proxy. For details, see Enabling Database Proxy.
Directions
1. Log in to the TDSQL-C for MySQL console. In the cluster list, select the cluster with the proxy enabled and click its ID to navigate to the Cluster Management page.
2. On the Cluster Management page, click Cluster Details > Details to open the Database Proxy Management page. Alternatively, you can directly enter the Database Proxy Management page by selecting Database Proxy on the Cluster Management page.
3. On the Database Proxy management page, navigate to Overview > Connection Address > Proxy Address and click Rebalance Load in the Operation column.
﻿
4. In the pop-up window, click OK.
Note：
During a reload balancing operation, sessions connected to the address will be disconnected, causing temporary service unavailability. It is recommended to restart the service during off-peak hours and ensure a reliable reconnection mechanism is in place.
﻿