Introducing Read/Write Splitting

Updated on 2024-07-18 GMT+08:00

View PDF

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.

Parent topic: Database Proxy (Read/Write Splitting)

Previous topic: Database Proxy (Read/Write Splitting)

Next topic: Suggestions on Using Database Proxy