Database
Get flash to fully experience Pearltrees
Sharding
Since 2004, Tagged has grown from a tiny social experiment to one of the largest social networks, delivering five billion pages per month to many millions of members who visit to meet and socialize with new people.
High Scalability - High Scalability - Tagged Architecture - Scaling to 100 Million Users, 1000 Servers, and 5 Billion Page Views
Five Predictions for your Database in 2011 - NoSQL Hype Will Decline | Cloud Zone
The recent hype around NoSQL will continue to decline , as DBAs and enterprises return to the proven SQL solutions. As it turns out, the promise for great scalability and distribution that drove the NoSQL adoption early on could not compensate for the lack of the very basic transactional and relational functions, which are core requirements for any commercial application.
Search
Update 4: Why you don’t want to shard. by Morgon on the MySQL Performance Blog. Optimize everything else first, and then if performance still isn’t good enough, it’s time to take a very bitter medicine. Update 3: Building Scalable Databases: Pros and Cons of Various Database Sharding Schemes by Dare Obasanjo. Excellent discussion of why and when you would choose a sharding architecture, how to shard, and problems with sharding. Update 2: Mr. Moore gets to punt on sharding by Alan Rimm-Kaufman of 37signals.
An Unorthodox Approach to Database Design : The Coming of the Sh
Transaction strategies: Understanding transaction pitfalls
The most common reason for using transactions in an application is to maintain a high degree of data integrity and consistency.PostgreSQL
MySQL