Adding Split MySQL database read/write capibilities to Drupal 5

Published on
15,695 Points
Last Modified:
Michael Worsham
Creative problem solver with ability to work either individually or through multiple teams partners for accomplishing goals.
Drupal 5.x currently does not have a production-ready patch bundle to allow for split read & writes for a MySQL master/slave replication setup. After reading a open discussion/thread on the Drupal site (http://drupal.org/node/147160) and a doing a bunch of trial and error, I was successful at designing a base patch/bundle release made specifically for the Drupal 5.x environment that can do what it says along with a performance boost as well!

All of the files that are part of this release bundle are not patches, but complete code files. Follow these instructions to create your own patch bundle using the 'old' Drupal 5.x code and replacing it with the enhanced code fixes that will allow a MySQL database master/slave replication environment handle split read/write capabilities under Drupal 5.x.

Required Environment:
      - Drupal 5.x (Version 5.10 and above have better performance results)
      - Existing MySQL 5.x master/slave replication environment

Sorry... this patch bundle only works under UNIX/Linux platforms.


Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Join & Write a Comment

Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…
Overview of OneDrive and collaboration.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month