How to enable Scalability & High Availability on MySQL for Drupal

MySQL is the the world's most popular open source database. MySQL, is also the most common choice as database engine for Drupal.

Traffic intensive sites, using Drupal & MySQL, must be able to scale out efficiently, in this context there are some alternatives for enabling Scalability & High Availability on MySQL server.

MySQL Replication is one of the most common solutions, to enable Scalability & Fault Tolerance, but we should keep in mind that there are some tips & recommendations to provide a replication environment consistently with a data integrity.

When reviewing the best practices around MySQL Replication, we should also take a look at MySQL Fabric, as a new & extensible framework for managing farms of MySQL Servers. There are two features implemented on MySQL Fabric: High Availability & scaling out using data sharding. These features can be used in isolation or in combination.

In this session, we are going to review the best practices for configuring MySQL Replication, using MySQL Fabric, MySQL Global Transaction IDs, Multi-thread Slave processes, & optimized row based replication, in order to take advantage on the new MySQL features to provide HA & Scalability on Drupal deployments.