What is your database sharding strategy?
eries: We're just discussing over in this thread:
http://news.ycombinator.com/item?id=296656I have had really good experience with a very simple centralized lookup facility. It's very easy to prevent that from becoming a CPOF, either using replication or, if you insist, some form of hash-based partitioning of the directory itself.I'm a fan of doing the partitioning at the app-level, and doing it horizontally rather than vertically.The loss of joins is an issue, but in some cases you can vertically partition the parts of the app that need those joins. For the others, I have had good luck using a transactional message-passing system, where one shard can reliably send a message to another shard.