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.
Figure 1 Read/write splitting

Parent topic: Read Replicas and Read/Write Splitting

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center