Software Engineering Stack Exchange is a question and answer site for professionals, academics, and students working within the systems development life cycle. It only takes a minute to sign up.
Sign up to join this community
When designing data structures for an application, what are some best practices to make sure it can be sharded?
In particular, which of the following is better:
You would typically shard a group of tables based on a key such as customer_id. One simple approach is to use the modulus. For example if you have 4 shards then divide the customer_id by 4 and use the remainder to determine which shard to use.
However, this approach isn't very flexible when you want to change the number of shards later on.
You may want to read this database sharding whitepaper that explains the theory in much more detail.
Regards,
Andy Grove
Chief Architect
http://www.dbshards.com
