Remember Vitess? It sits in front of all of YouTube's databases. Every time you load a page on YouTube, the database queries go through Vitess.

http://code.google.com/p/vitess/

It's a sweet program, and if it stops working, then YouTube gets smashed by a fail whale. Would that be the kind of thing you're looking for?