Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Drupal Just Wants to Hug Your Database

Drupal Just Wants to Hug Your Database

 20 April 11:10 AM - 12:00 PM @ Ballroom G
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Case Stories
Operations and Management
Topics:
MySQL
Tools and Techniques
Web Services

Description

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

Speakers

Emily Slocombe's picture

Emily Slocombe

Senior Database Administrator, SurveyMonkey

Biography:

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.

Pim van der Wal's picture

Pim van der Wal

Platform DBA, Acquia

Biography:

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.

Share this talk