This talk from the last MySQL conference describes what LiveJournal (a blogging portal) has had to do over the past few years to meet its users' growing demands. It's an insightful look at what you have to do in practice to make a workable web.