How YouTube scales MySQL for its large databases

December 31st, 2007

If you’re into MySQL and database scalability you’ll love this cool presentation made by Paul Tuckfield, *the* DBA of YouTube. Yep, there are only 3 DBA guys at YouTube, counting with Paul:

“In mid 2006, YouTube served approximately 100 million videos in a single day. To maintain a website of that scale, one would imagine YouTube has hundreds of DBAs. But in fact, there are just three people that make it all work. Paul Tuckfield, the MySQL DBA at YouTube shares horror stories about scalability at YouTube and how he coped with them to keep the show going everyday, while learning important lessons along the way. … According to him, the three important reasons for YouTube’s scalability are Python, Memcache and MySQL replication, the last having the most impact. Most people think that the answer to scalability is in upgrading hardware and CPU power. Adding CPUs doesn’t work on its own; wisdom is in getting the maximum amount of RAM for the CPU and then fine tuning.”

Ok, he’s also a vi user. Kind of cool.

Leave a Reply