Updated on 2024-10-14 GMT+08:00

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.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target instance name to go to the Overview page.
  5. Click Database Proxy in the navigation pane on the left. On the displayed page, click Modify 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