Arguably one of the most interesting keynotes (and technical to boot!), Paul Tuckfield not only entertained us in his 40 minute keynote, he also did so outside when the keynotes ended.
Just the DBA at PayPal, just the DBA at YouTube. Only 3 DBAs at YouTube that make it all happen. Only a MySQLer for ~8 months (Oracle for ~15 years). So guess PayPal is a Oracle shop.
MySQL is one (important) piece of the scalability picture.
Technologies: Python, Memcache, MySQL replication. Praises Python, a lot (its much quicker, than C++, to implement goodness).
Click tracking on a separate MyISAM site. But Read/write on InnoDB, using replication. Far more reads than writes at YouTube
4×2ghz Opteron core, 16GB ram, 12×10krpm scsi - constantly crashing, replication saved them
5.0 “mystery cache hits” - when you export and import (mysqldump and load back into 5.0), you boost your performance, rather than …
[Read more]