Updated on 2023-02-07 GMT+08:00

Does RDS Support Read/Write Splitting?

Table 1 lists the DB engines and versions which support read/write splitting.

Table 1 RDS read/write splitting

Database

Read/Write Splitting

Database Proxy

Remarks

RDS for MySQL

Supported

Supported

Prerequisites: You have obtained the permissions required for read/write splitting. To apply for the permissions, choose Service Tickets > Create Service Ticket in the upper right corner of the management console.

Procedure: See Enabling Read/Write Splitting.

Function:

  • If read/write splitting is enabled and there is no read replica, read and write requests are automatically routed through the read/write splitting address to the primary instance.
  • If read/write splitting is enabled and there are read replicas, RDS automatically routes write requests through the read/write splitting address to the primary instance and read requests to each read replica by user-defined weights.

Constraints: See Suggestions on Using Database Proxy.

RDS for PostgreSQL

Supported with client drivers

Not supported

After read replicas are created, separately configure connection addresses of the primary DB instance and each read replica on your applications so that all read requests can be sent to read replicas and write requests to the primary DB instance.

For details about RDS for PostgreSQL read replicas, see Introducing Read Replicas.

For details about how to implement read/write splitting, see Using Client Drivers to Implement Failover and Read/Write Splitting.

RDS for SQL Server

Supported only for 2017 Enterprise Edition

Not supported

After read replicas are created, separately configure connection addresses of the primary DB instance and each read replica on your applications so that all read requests can be sent to read replicas and write requests to the primary DB instance.

Read Replicas and Read/Write Splitting FAQs

more