Timwi wrote:

Tim Starling wrote:

...

Modified Files: Tag: REL1_3 DefaultSettings.php MessageCache.php Setup.php Log Message: allow messages to be drawn from another database, off by default

This still requires the secondary database to be on the same server as the main database, doesn't it?

Yes, but it's a trivial modification if you wish it to be otherwise. Configure the second server with zero load allocation. Then just grab a connection to the desired server using wfGetDB() in MessageCache::loadFromDB(). Say if you give it an index of 10, then the appropriate code would be:

if ( $this->mSecondaryDB ) { # Load from fallback $db =& wfGetDB( 10 ); $sql = "SELECT cur_title,cur_text FROM {$this->mSecondaryDB}.cur WHERE cur_is_redirect=0 AND cur_namespace=" . NS_MEDIAWIKI; $res = $db->query( $sql, $fname ); $this->mCache = array(); for ( $row = $db->fetchObject( $res ); $row; $row = $db->fetchObject( $res ) ) { $this->mCache[$row->cur_title] = $row->cur_text; } }