Chapter 24: MySQL Replication

This chapter will define MySQL replication, explaining how it works and how it can be used to improve a Drupal website's performance and scalability. It will explore patches that have been deployed on Drupal.org to send some database queries to a slave server, and the rest to the master server. It will examine the idea of using Master-Master replication, arguing against this as a means for scaling Drupal websites. It will also briefly look at the concept of sharding, and look at plans in Drupal 7 for potentially supporting these advanced scalability features, reviewing the limitations imposed by Drupal's design in Drupal 5 and Drupal 6.

  1. Concepts
    1. Configuration
    2. Monitoring
    3. Backups
    4. Errors
  2. Drupal and Replication
    1. Mixing Storage Engines
    2. Redirecting Search Queries
    3. High Availability
  3. Federated Databases
    1. Sharding
    2. MySQL Proxy
    3. Drupal 7 Preview