Database Sharding Blog

Tuesday, September 23, 2008

Trend: Single Application Databases

db geek has made a very astute observation about single application databases:

One interesting trend that I've noticed in many of the organizations that I've been into is that increasingly databases are being built to serve single applications. The early visions of databases shared amongst multiple applications is no longer the first choice. To a certain extent this has always been the case for certain operational systems, but now the reach of single application databases has grown. You'll even find data replicated across multiple multi-terabyte data warehouses to support different business intelligence solutions.

db geek attributes this trend to factors such as commodity hardware and the benefits of reducing the complexities created by multi-application databases.

Labels: , , ,


Monday, September 15, 2008

Database Sharding Lessons

Dan Pritchett has written an excellent blog detailing his experience with database sharding while working as an architect at eBay, Inc. and Rearden Commerce:

Lesson 1: Right Size Your Shards

Lesson 2: Use Math on Shard Counts

Lesson 3: Carefully Consider the Spread

Lesson 4: Plan for Exceeding Your Shards

Lesson 5: Shard Early and Often



You can read the details of each lesson in Dan's blog.

Labels: , ,