tags:

views:

168

answers:

1
Q: 

Database Shard-ing

I have a database that is currently shard-ed. This is the first time that I have come across a shard-ed database and would like to know a bit more about them.

Things like:

When is it a good idea to shard a database?

At what database size is it a good idea to shard a database?

How easy it is to remove sharding?

+2  A: 

I found this article

Ardman  2010-03-11 08:50:55

related questions

Assign 10-digit char user ids to 1 of 1000 servers.
What does Sharding means from Database Design Perspective ?
Java Database Connection Pool for multiple databases (Shards)
Where should one place the code to autoincrement a sharded counter on Google App Engine/Django when one creates a new model?
How do I speed up deletes from a large database table?
Distributed Key-Value Data Store with Offline Access (Static Partitioning)
Data Sharding
can someone show how to setup pgpool 2 in parallel *query* mode ie horizontal partitioning
How do we do horizontal sharding/partitioning in Postgresql using pgpool-II?
Have any good links/articles on job queuing & db sharding?
what is a good way to horizontal shard in postgresql
How to I determine if an object exists for a given key in the Google AppEngine datastore using Java?
MySQL Proxy Alternatives for Database Sharding
How to create unique row ID in sharded databases?
Database Sharding Support in Propel
MySQL Simple Table Synchronization?
Sharding with ASP.NET's SqlMembershipProvider?
Web scripting language with parallel non blocking database access?
Best way to move a data row to another shard?
Resources for Database Sharding and Partitioning
Searching across shards?
Extreme Sharding: One SQLite Database Per User
When people talk about scaling a website with 'shards', what do they mean?
MySQL Partitioning / Sharding / Splitting - which way to go?
Database sharding and Rails