Help Center > > FAQs> Management FAQs> Does RDS Support Read/Write Splitting?

Does RDS Support Read/Write Splitting?

Updated at: Mar 17, 2020 GMT+08:00

Database

Read/Write Splitting

Database Proxy

Description

RDS for MySQL

Supported

Supported

You can configure read/write splitting after read replicas are created. Through a read/write splitting address, write requests are automatically routed to the primary DB instance and read requests are routed to each read replica by user-defined weights.

For details about the MySQL read replicas, see Introduction to Read Replicas.

RDS for PostgreSQL

Supported

Not supported

After read replicas are created, you need to 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 PostgreSQL read replicas, see Introduction to Read Replicas.

RDS for SQL Server

Supported only by 2017 Enterprise Edition

Not supported

After read replicas are created, you need to 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 SQL Server read replicas, see Introduction to Read Replicas.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel