Help Center> Relational Database Service> User Guide (Ankara Region)> Working with RDS for MySQL> Database Proxy (Read/Write Splitting)> Changing the Read/Write Splitting Address
Updated on 2024-04-11 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 DB 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 Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. In the Connection Information area on the Basic Information page, click Change next to the Read/Write Splitting Address field.

    Alternatively, click Database Proxy in the navigation pane on the left. In the Read/Write Splitting area on the displayed page, click Change next to the Read/Write Splitting Address field.

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

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