Adding Split MySQL database read/write capibilities to Drupal 5

AID: 186
  • Status: Published

5500 points

  • By
  • TypeGeneral
  • Posted on2008-11-20 at 16:31:46
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.

    Asked On
    2008-11-20 at 16:31:46ID186
    Tags

    drupal

    ,

    mysql

    ,

    replication

    Topic

    Web-Based CMS

    Views
    7885

    Comments

    Add your Comment

    Please Sign up or Log in to comment on this article.

    Join Experts Exchange Today

    Gain Access to all our Tech Resources

    Get personalized answers

    Ask unlimited questions

    Access Proven Solutions

    Search 3.2 million solutions

    Read In-Depth How-To Guides

    1000+ articles, demos, & tips

    Watch Step by Step Tutorials

    Learn direct from top tech pros

    And Much More!

    Your complete tech resource

    See Plans and Pricing

    30-day free trial. Register in 60 seconds.

    Loading Advertisement...

    Top Web-Based CMS Experts

    1. jason1178

      4,800

      0 points yesterday

      Profile
      Rank: Genius
    2. webmatrixpune

      2,000

      0 points yesterday

      Profile
      Rank: Guru
    3. gyoreg

      1,500

      0 points yesterday

      Profile
      Rank: Master
    4. miked2004

      1,350

      0 points yesterday

      Profile
      Rank: Wizard
    5. shahzoor

      1,000

      0 points yesterday

      Profile
      Rank: Guru
    6. pwust

      1,000

      0 points yesterday

      Profile
      Rank: Master
    7. hongjun

      350

      10 points yesterday

      Profile
      Rank: Genius
    8. austega

      300

      0 points yesterday

      Profile
      Rank: Master

    Hall Of Fame