Have any good links/articles on job queuing & db sharding?

Question

Does anyone have good links on how/when/why to use job queuing to scale web apps? Also, articles on db sharding would be useful too :)

Answer 1

This fantastic presentation covers lots of scalability issues, including job queueing and db sharing. There are also quite a few stack overflow questions about this:

• http://stackoverflow.com/questions/1054479/data-sharding
• http://stackoverflow.com/questions/91710/when-people-talk-about-scaling-a-website-with-shards-what-do-they-mean
• http://stackoverflow.com/questions/292039/resources-for-database-sharding-and-partitioning