Thursday, August 10, 2017

Principles of Sharding for Relational Databases

DZone Database Zone
Principles of Sharding for Relational Databases

When your database is small (i.e. tens of GB), it’s easy to throw more hardware at the problem and scale up. As these tables grow, however, you need to think about other ways to scale your database.

In one way, sharding is the best way to scale. Sharding enables you to linearly scale your database’s CPU, memory, and disk resources by separating your database into smaller parts. In other ways, sharding is a controversial topic. The internet is full of advice on sharding, from scaling your database infrastructure to why you never want to shard. So the question is, whose advice should you take?

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...