On Fri, May 27, 2005 at 11:38:27PM +0100, Tomer Chachamu wrote:
On 27/05/05, Brion Vibber brion@pobox.com wrote:
This would also be more flexible because if data needs to be transferred to another server there is no need to update all rows in the revision table.
You've got to update it *somewhere*.
Updating $serverurl or similar in a PHP file is easier than using str_replace or similar for every entry of your revision table to change the URL from the old to the new one.
The current implementation uses logical names within the database and a logical name -> physical server mapping in LocalSettings.php.
The URL for an external revision is DB://cluster1/765765
In LocalSettings.php, the name cluster1 is mapped to a farm of three mysql servers:
$wgExternalServers = array( 'cluster1' => array( array( 'host'=> 'srv30', 'load' =>1)+$templateServer , array( 'host'=> 'srv28', 'load' =>1)+$templateServer , array( 'host'=> 'srv29', 'load' =>1)+$templateServer , ) );
This provides both redundancy and flexibility.
Regards, JeLuF