Does RDS Support Read/Write Splitting?
| 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 read replicas by user-defined weights.
|
| 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 this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.