Sharding
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is the key architectural difference between Sharding and Partitioning?
2. How does key-based sharding decide which shard should hold newly written data?
3. Which sharding architecture divides data according to ranges of a given value?
4. What must be created and maintained for directory-based sharding?
5. What is described as the main appeal of sharding a database?
6. What is horizontal scaling?
7. How does sharding help make an application more reliable?
8. Which statement is NOT a drawback of sharding?
9. What is the problem with database backups made before the database was sharded?
10. In the yearly Salary example, why is a query for years 2 and 3 faster on a sharded database than on a standard partitioned one?