[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Adding Split MySQL database read/write capibilities to Drupal 5

Published on
15,780 Points
Last Modified:
Michael Worsham
Well-rounded and highly experienced with a professional background in cloud/infrastructure solutions and project management.
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

Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Join & Write a Comment

Watch this simple and effective video tutorial to extract attachments from Outlook 2007 and try this easy method by yourself. No need to go anywhere, just watch the video and export attachments from Outlook in few simple steps. To know more, click h…
I've published three five-minute Experts Exchange video Micro Tutorials that describe terrific features in an excellent, free PDF product called PDF-XChange Editor: How to rotate pages in a PDF with free software (https://www.experts-exchange.com…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month