Alternate strategy for database sharding

An alternate strategy for database sharding which avoids queries across different shards and merging results. A central repository of data is maintained for some tables along with other shards. Can be used in calculating top users, recent users, most read etc.

Comments

[Moshe Kaplan]

Hi,

I think that usually we name this method vertical sharding

Best,
Moshe Kaplan. RockeTier. The Performance experts.
moshe.kaplan at rocketier.com

[Jorrit Schippers]

AFAIK is vertical sharding storing different columns on different nodes.