Facebook has thousands of MySQL database servers, which gives them unique insights and challenges. In this talk from the O'Reilly 2010 MySQL Conference, Mark Callaghan of Facebook goes into detail about their deployment, practices, and goals. The pressures on their production system have required them to make many fixes to MySQL. They process 10 million queries per second and 370 million rows per second. Despite the great things they have accomplished, they have a long wish-list for more features in MySQL.
Mark Callaghan leads the MySQL engineering team at Facebook. The team makes MySQL better for large and critical deployment. The team writes about their work at MySQL at Facebook and publishes patches for MySQL at launchpad.
He previously lead the MySQL engineering team at Google. The team published a popular patch for MySQL that included semi-sync replication, user and table monitoring via SHOW TABLE_STATISTICS and USER_STATISTICS, SMP and IO performance patches for InnoDB, global transaction IDs for replication, row-change logging, transactional replication and many bug fixes.
Prior to Google, Mark worked at Identity Engines, Oracle and Informix on database internals. mark holds an M.S. degree in Computer Science from the University of Wisconsin-Madison. He occasionally writes about MySQL on his blog.
Resources
This free podcast is from our MySQL Conference series.
For The Conversations Network: