Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Jaime Crespo


Jaime Crespo's picture

Jaime Crespo

Sr Database Administrator, Wikimedia Foundation


Biography:

Jaime works as the senior database administrator for the non-profit organization Wikimedia Foundation, host of Wikipedia and other similar open knowledge projects. His main topics of interest are MySQL query optimization and architectures for high availability. He is a former MySQL A.B./Sun Microsystems/Oracle/Percona instructor and consultant, and has also worked as an independent MySQL consultant at DBAhire.com.


Sessions

3 October 1:30 PM - 4:30 PM at Zürich 1
In this tutorial we will take Mediawiki, one of the most popular open-source wiki applications, and we will use it to discuss schema and scalability design problems we suffered on Wikipedia. We will discuss how they were solved (or how we plan to solve them). Forget about basic normalization theory or performance promises made by vendors in an ideal world.
4 October 7:30 PM - 8:30 PM
As the sole DBA for the Wikimedia Foundation, I faced the task of maintaining hundreds of busy MySQL servers, with only a handful home-made tools on different languages (bash, PHP, perl) and a few 3rd party utilities such as Percona Toolkit and XtraBackup. In order to get out of that administrator's hell, I wrote a basic, easy to use, tiny-scope API to be used as the base of all monitoring,... [read more]