tencent cloud

This document describes how to set the database proxy connection address in the TencentDB for MySQL console.

The database proxy connection address is independent of the original database connection address. Requests proxied at the proxy address are all relayed through the proxy cluster to the source and replica nodes of the database, so that read and write requests are separated, with reads being forwarded to read-only instances. In this way, the load of the source database is lowered.
After database proxy is enabled for TencentDB for MySQL, a database proxy connection address will be added by default, and you can also add, modify, or delete the connection address for database proxy.

Prerequisites

You have enabled the database proxy. For more information, see Enabling Database Proxy..

Modifying Database Proxy Connection Address

1. Log in to the TencentDB for MySQL console. In the instance list, click an instance ID or Manage in the Operation column of the instance with the proxy enabled to enter the instance management page.
2. On the instance management page, select the Database Proxy tab and click the icon next to Private Network Access Address on the Connection Address tab.
   
3. In the pop-up dialog box, modify the proxy address and click OK.

   Note：

   Modifying the proxy address affects the database business being accessed. We recommend you modify the address during off-peak hours. Make sure that your business has a reconnection mechanism.

   

Adding Database Proxy Connection Address

Note：

• The number of connection addresses is the same as that of database proxy nodes.
• An connection address will be created by default when the database proxy is enabled.

1. Log in to the TencentDB for MySQL console. In the instance list, click an instance ID or Manage in the Operation column of the instance with the proxy enabled to enter the instance management page.
2. On the instance management page, select the Database Proxy tab, and click Add Access Address next to Connection Address.
   
3. In the Create Connection window, set the following configuration items and click OK.

Step 1. Configure a network

Deleting Database Proxy Connection Address

Note：

If your database proxy has multiple connection addresses, you can delete unnecessary ones while keeping the last one.

1. Log in to the TencentDB for MySQL console. In the instance list, click an instance ID or Manage in the Operation column of the instance with the proxy enabled to enter the instance management page.
2. On the instance management page, find the target address in Database Proxy > Connection Address, and click Disable.
   
3. In the pop-up window, click OK.