Read/write splitting enables read and write requests to be automatically routed through a read/write splitting address.

You can enable the single-proxy or multi-proxy function for your RDS for MySQL instance. The multi-proxy function supports multiple database proxies and is useful for workload isolation. There is a menu item on the OTC Console on the left panel as follow:

After you enable read/write splitting, if there is no read replica, read and write requests will be automatically routed to the primary instance through the read/write splitting address.

After you enable read/write splitting, if there are read replicas, write requests will be automatically routed to the primary instance and read requests to each read replica by user-defined weights through the read/write splitting address.

Proxy load balancing balances requests among multiple read replicas using a load-based scheduling policy. The usage of RDS Proxy load balancing will cause costs, please check the service description for more information about costs.

Further information can be found in the Relational Database Service (RDS) area of the Help Center.