patternsqlMinor
Does anyone have a good recommendation for a book which teaches sharding?
Viewed 0 times
anyonebookteachesrecommendationfordoesgoodwhichshardinghave
Problem
Does anyone have a good recommendation for a book which teaches db sharding (from scratch at best)
I have read like 40 different websites talking about sharding.
I'm not saying online sites/blogs are lousy, they are good titbits. However, I need the main meal not just a it of useful info here and there. Basically, I have an idea (I guess) of how to implement sharding but, since it's a terribly complicated concept, I believe there is much, much, much more to it that can be studied on.
I have read like 40 different websites talking about sharding.
I'm not saying online sites/blogs are lousy, they are good titbits. However, I need the main meal not just a it of useful info here and there. Basically, I have an idea (I guess) of how to implement sharding but, since it's a terribly complicated concept, I believe there is much, much, much more to it that can be studied on.
Solution
A great place to start is the book High Performance MySQL : Optimizations, Backups, Replication and More. Chapter 9 (pages 409 - 456) of the book is entitled "Scaling and High Availability"
There are the subheadings
and two dozen other subheadings
There are the subheadings
- Scaling MySQL
- Planning for Scability
- Buying Time Before Scaling
- Scaling Up
- Scaling Out
- Functional partitioning
- Data Sharding
- Choosing a partitioning key
- Multiple partitioning keys
- Querying across shards
- Allocating data, shards and node
- Arranging shards on node
- Fixed allocation
- Mixing Dynamic and Fixed Allocation
- Explicit Allocation
- Rebalancing Shards
- Generating globally unique IDS
- Tools for sharding
- Scaling Back
- Scaling by Cluster
- Load Balancing
- Connecting Directly
and two dozen other subheadings
Context
StackExchange Database Administrators Q#4013, answer score: 5
Revisions (0)
No revisions yet.