https://algo.monster/problems/system-design-partitioning-sharding
In the section “Sharding a SQL database - MySQL(MariaDB)”, the text near the end of the section stops abruptly with an incomplete sentence: “In the real world, you would probably be”. I assume there’s some missing content?
Thank you. This was added by mistake and we will remove this sentence.
Gently reminder to remove the sentence
I don’t quite get this? Just because we split some data does not mean we created additional space so how come we suddenly get more storage to store our data in?
Its like splitting a pizza into triangles or squares. What difference does it make? It still takes up the same amount of area, does it not?
disks get more expensive as storage capacity goes up. instead of getting one very large and expensive disk, we can get many small and inexpensive ones with equivalent storage.
Its like splitting a pizza into triangles or squares. What difference does it make? It still takes up the same amount of area, does it not?
In this example horizontal scaling means buying more pizza boxes (for example 7 more), slicing the pizza in 8 triangles and then moving each triangle to a pizza box. Now each pizza box contains 1 slice and 7 more slices per box can be added.