• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. FAQs
  5. General FAQs
  6. Does MySQL Support Sharding and Read/Write Splitting?

Does MySQL Support Sharding and Read/Write Splitting?

Yes. MySQL works with the Distributed Database Middleware (DDM) service to support sharding and read/write splitting.

  • The DDM service supports sharding. MySQL uses the DDM service to expand storage space or performance.
  • A maximum of five read replicas can be created for a MySQL single or primary/standby DB instance. Read replicas and single or primary/standby DB instances use independent IP addresses. If you want to use a unified address for read/write splitting, you need to use the DDM service or build the SQL-proxy middleware.