Does MySQL Support Sharding and Read/Write Splitting?
Yes. RDS supports sharding and read/write splitting.
- Distributed Database Middleware (DDM) provides the sharding function to remove the capacity and performance bottlenecks of databases.
- A maximum of five read replicas can be created for a MySQL primary DB instance. Read replicas and DB instances are connected through separated IP addresses.
After enabling the read/write splitting function, you can use a unified read/write splitting address, which can be obtained on the Read/Write Splitting page.
For detailed operations, see Configuring Read/Write Splitting.