Drupal Just Wants to Hug Your Database
Drupal is one of the more widely adopted CMSs. It is open source and has a huge developer base. However, I rarely hear a DBA mention having to administer Drupal with anything but frustration and pessimism. At Acquia, we have thousands of Amazon instances running Drupal databases. Most sites are quite different from each other, but some basic principles apply to all. Being the DBA for Drupal does not have to be a negative experience! In addition to covering the generic Drupal MySQL configuration tips, I will cover optimization methods for specific features like semaphores, sessions, Views, and the various Drupal caching layers. I will discuss how to help developers find bad queries and improve query performance. I’ll also cover the use of query cache in the Drupal context, which while normally frowned upon in the MySQL community, is often beneficial in maintaining a healthy Drupal site. Slides with notes are located at: http://eslocombe.github.io/drupalpres/DrupalHugs.html in remark.js
Senior Database Administrator, SurveyMonkey
Emily has recently joined SurveyMonkey as a MySQL DBA, after 4 years of being a Platform DBA at Acquia. Emily has been in tech since 1998 - mostly working in the LAMP stack. She's been at various companies in that time, but only really got interested in MySQL while at Nokia in 2010 supporting their service that ran on Drupal. Emily is located in Portland, Oregon.
Platform DBA, Acquia
Pim is a platform DBA at Acquia specializing in MySQL. He is part of the Operations team that keeps Drupal web sites running smoothly. In that capacity he's responsible for database performance tuning which includes query optimization, server tuning and performance audits. When nobody is looking he also works with the Engineering team to improve the platform. Pim's background is as a developer with an affinity for databases who went from MS SQL server, through Sybase and Oracle to end up with MySQL in 2006 which is when he turned full-time DBA. He has been with Acquia for 3 years and works remotely from New Jersey.