Top "Sharding" questions

Sharding is a technique of partitioning database tables by row ("horizontally"); typically this technique requires a key to be selected that determines how the rows are to be partitioned.

Querying sharded data in MySQL

I'm dealing with a lot of data in a MySQL database and I'd like to use sharding to scale out. …

mysql scaling sharding
How does MongoDB do both sharding and replication at the same time?

For scaling/failover mongodb uses a “replica set” where there is a primary and one or more secondary servers. Primary …

mongodb replication sharding
How to Programmatically Pre-Split a GUID Based Shard Key with MongoDB

Let's say I am using a fairly standard 32 character hex GUID, and I have determined that, because it is randomly …

mongodb sharding
What would be the right steps for horizontal partitioning in Postgresql?

We have an E-commerce portal with a Postgresql 9.1 database. One very important table has at the moment 32 million records. If …

sql postgresql sharding