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.
- Concepts
- Configuration
- Monitoring
- Backups
- Errors
- Drupal and Replication
- Mixing Storage Engines
- Redirecting Search Queries
- High Availability
- Federated Databases
- Sharding
- MySQL Proxy
- Drupal 7 Preview
