Database Sharding Concept

Problem

The company has grown to 500 million users, and a single database server can no longer hold all the data or handle the traffic, even with the most expensive hardware. You need to partition the data horizontally across multiple machines. Write a query that outputs a column explanation with the value: "Sharding splits a large database across multiple servers based on a shard key."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution