Help Center/ Relational Database Service/ User Guide/ Working with RDS for MySQL/ Database Proxy (Read/Write Splitting)/ Introducing Read/Write Splitting
Updated on 2024-07-18 GMT+08:00
View PDF

Introducing Read/Write Splitting

Read/write splitting enables read and write requests to be automatically routed through a read/write splitting address. You can enable read/write splitting after read replicas are created. Write requests are automatically routed to the primary DB instance and read requests are routed to read replicas by user-defined weights.

Proxy load balancing balances requests among multiple read replicas using a load-based scheduling policy. To enable proxy load balancing, contact customer service to apply for the required permissions.

Scenario

  • Read/write splitting enables read and write requests to be automatically routed. If your application requires more proxies, you can request additional proxy nodes with just a few clicks.
  • Read requests are distributed to your read replicas based on weights to balance your database traffic and improve resource utilization.
  • A proxy routes read requests of your application only to the read replicas you specify for the proxy.