DrupalCon Portland 2013: HIGH PERFORMANCE DRUPAL WITH MARIADB (A MYSQL BRANCH)

This talk explores the critical role of database performance tuning for successful Drupal websites, focusing on MySQL and its drop-in replacement, MariaDB. The speaker discusses the advantages of using MariaDB, including its improved query optimizer, enhanced key caches, and features like the open-source thread pool and binary log group commit, which support scaling when transitioning from a single database instance to a replicated environment. The session also covers practical applications of GIS with Drupal and MariaDB, alongside new developments in MariaDB Galera Cluster for read/write scaling. A case study of a popular site with over 50,000 entries demonstrates how MariaDB enhances overall performance and scalability for Drupal projects.