Help Center> Relational Database Service> User Guide> Working with RDS for MySQL> Database Proxy (Read/Write Splitting)> Changing the Read/Write Splitting Address
Updated on 2024-04-03 GMT+08:00
View PDF

Changing the Read/Write Splitting Address

Scenarios

After read/write splitting is enabled, you can change the read/write splitting address.

Precautions

Changing the read/write splitting address will interrupt database connections and services. Therefore, change the read/write splitting address during off-peak hours or when services are stopped.

Constraints

The new IP address is not in use and must be in the same subnet as the RDS for MySQL instance.

Procedure

You can change the read/write splitting address for DB instances with read/write splitting enabled.

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance.
  5. Click Database Proxy in the navigation pane on the left. On the displayed page, click Change next to the Read/Write Splitting Address field.

    Figure 1 Read/write splitting area (single-proxy)
    Figure 2 Read/write splitting area (multi-proxy)

  6. In the displayed dialog box, enter a new address. Click OK.

    In-use IP addresses cannot be used as read/write splitting addresses.

    Figure 3 Changing the read/write splitting address