55: Database Partitioning (Sharding)

Database partitioning is used to divide data into different partitions to access it faster and eliminate a single point of failure. Partitioning is usually used for performance, availability, manageability, or load balancing (scalability).

There are different methods for partitioning a database.

• Related Note(s):
  • 42b: Systems and Design Thinking;
  • 48: System Design Index;
  • 51: Consistency Models in Distributed Systems Index;
  • Understanding How Database Transactions Work;
  • How to Partition a Database;