Home icon

Scale your relational database for SaaS, Part 2: Sharding and routing

Database Blog



This article provides an overview of database sharding and routing as a strategy for scaling relational databases in SaaS applications beyond the limits of a single instance.

Specifically, the article covers:

  • Benefits and challenges of database sharding
  • Using tenant_id as a common shard key
  • Architectural patterns like shuffle sharding and cellular architecture
  • When to consider sharding
  • Routing requests to the correct database shard using a data access manager
  • Amazon Aurora Limitless Database as a managed sharding solution


Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Apr 30
2024
Scale your relational database for SaaS, Part 1: Common scaling patterns
Jun 25
2024
Tenant routing strategies for SaaS applications on AWS
Jan 16
2024
How to Scale for Global SaaS Growth with a Skyflow Data Privacy Vault on AWS
Mar 24
2026
Automatically scale storage for Amazon RDS Multi-AZ DB clusters using AWS Lambda

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.