Jaime Crespo

Sr Database Administrator, Wikimedia Foundation

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

Monday, September 21, 2015 - 9:00am @
This tutorial is divided into 2 parts: The first part will be about query optimization basics, and is aimed to Developers and DBAs without requiring a deep understanding of MySQL Internals (applying to most MySQL versions from 5.5 to 5.6 and MariaDB 10): * Example database - Environment setup * Access types and basic indexing - How indexes work to speed-up queries - BTREE... [read more]
Monday, September 21, 2015 - 1:30pm @
This tutorial is divided into 2 parts: The first part will be about query optimization basics, and is aimed to Developers and DBAs without requiring a deep understanding of MySQL Internals (applying to most MySQL versions from 5.5 to 5.6 and MariaDB 10): * Example database - Environment setup * Access types and basic indexing - How indexes work to speed-up queries - BTREE... [read more]
Wednesday, September 23, 2015 - 5:20pm @
Wikipedia is one of the top 10 websites in the world by number of visitors according to several sources {{citation needed}}. At the core of its data infrastructure lay over 150 instances of MySQL and MariaDB in order to store not only the monthly 10 million edits of Wikipedias in dozens of languages, but also several other multilingual wiki projects, community-driven tools and internal services.