HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Does anyone have a good recommendation for a book which teaches sharding?

Submitted by: @import:stackexchange-dba··
0
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.

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

  • 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.