Does RDS Support Read/Write Splitting?
Table 1 lists the DB engines and versions which support 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:
Constraints: See Suggestions on Using Database Proxy. |
RDS for MariaDB |
Not supported |
Not supported |
N/A |
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot