Modifying Read/Write Splitting Parameters

Scenarios

After read/write splitting is enabled, you can modify proxy parameters, for example, multiStatementType.

Constraints

• To change the value of multiStatementType, the proxy version must be 2.22.11.000 or later. To find the proxy kernel version, go to the proxy instance details page.
• All proxies of your DB instance must be in the Available state.

Procedure

1. Click in the upper left corner and select a region.
2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
3. On the Instances page, click the primary instance name.
4. In the navigation pane on the left, choose Database Proxy.
5. On the displayed page, click Modify Parameters in the proxy information area.
6. Change the value of multiStatementType and click OK.

   multiStatementType is not available for read-only proxies.

   • Strict (default): After a multi-statement request is sent to the primary instance, the read/write splitting of the current connection becomes unavailable and all subsequent requests are routed to the primary instance.
   • Loose: After a multi-statement request is sent to the primary instance, the read/write splitting of the current connection still works.
   • Parse: After a multi-statement request is sent to the primary instance, the request is parsed to determine whether to split subsequent read and write requests.