Make WordPress Core

Opened 17 years ago

Closed 17 years ago

Last modified 17 years ago

#7081 closed enhancement (worksforme)

Allow Wordpress to use a Slave Database

Reported by: plusnet's profile plusnet Owned by:
Milestone: Priority: normal
Severity: normal Version: 2.5.1
Component: Optimization Keywords: dev-feedback has-patch 2nd-opinion
Focuses: Cc:

Description

We have found that our database server is sometimes running out of connections. We would like to try and offset the vast majority of Wordpress' Select Statements to the slave DBs we have in our replicated system.

We have started work on a patch to wp-db.php to fix this (based off 2.5.1 currently) which I'll attach to this ticket.

Attachments (1)

wp-db.patch (3.7 KB) - added by plusnet 17 years ago.
Initial Implementation of the WPDB changes

Download all attachments as: .zip

Change History (5)

@plusnet
17 years ago

Initial Implementation of the WPDB changes

#1 @plusnet
17 years ago

  • Keywords dev-feedback added

#2 @DD32
17 years ago

  • Keywords has-patch 2nd-opinion added
  • Type changed from defect to enhancement

Just a note if you're wanting to keep your WorPress install Stock & this change doesnt make it in anytime soon;

WordPress allows you to place a file 'db.php' into the wp-content folder:
http://trac.wordpress.org/browser/trunk/wp-includes/functions.php#L1559

I know there are a few classes around which are aimed at allowing multiple Database servers, most aimed at @WordPress MU - however probably still work with WordPress

#3 @matt
17 years ago

  • Resolution set to worksforme
  • Status changed from new to closed

This is addressed (and more) by HyperDB.

http://codex.wordpress.org/HyperDB

#4 @Viper007Bond
17 years ago

  • Milestone 2.7 deleted
Note: See TracTickets for help on using tickets.