3 * Advanced generator of database load balancing objects for wiki farms
11 * A multi-wiki, multi-master factory for Wikimedia and similar installations.
12 * Ignores the old configuration globals
15 * sectionsByDB A map of database names to section names
17 * sectionLoads A 2-d map. For each section, gives a map of server names to load ratios.
18 * For example: array( 'section1' => array( 'db1' => 100, 'db2' => 100 ) )
20 * serverTemplate A server info associative array as documented for $wgDBservers. The host,
21 * hostName and load entries will be overridden.
23 * groupLoadsBySection A 3-d map giving server load ratios for each section and group. For example:
24 * array( 'section1' => array( 'group1' => array( 'db1' => 100, 'db2' => 100 ) ) )
26 * groupLoadsByDB A 3-d map giving server load ratios by DB name.
28 * hostsByName A map of hostname to IP address.
30 * externalLoads A map of external storage cluster name to server load map
32 * externalTemplateOverrides A set of server info keys overriding serverTemplate for external storage
34 * templateOverridesByServer A 2-d map overriding serverTemplate and externalTemplateOverrides on a
35 * server-by-server basis. Applies to both core and external storage.
37 * templateOverridesByCluster A 2-d map overriding the server info by external storage cluster
39 * masterTemplateOverrides An override array for all master servers.
41 * readOnlyBySection A map of section name to read-only message. Missing or false for read/write.
45 class LBFactory_Multi
extends LBFactory
{
47 var $sectionsByDB, $sectionLoads, $serverTemplate;
49 var $groupLoadsBySection = array(), $groupLoadsByDB = array(), $hostsByName = array();
50 var $externalLoads = array(), $externalTemplateOverrides, $templateOverridesByServer;
51 var $templateOverridesByCluster, $masterTemplateOverrides, $readOnlyBySection = array();
53 var $conf, $mainLBs = array(), $extLBs = array();
54 var $lastWiki, $lastSection;
56 function __construct( $conf ) {
57 $this->chronProt
= new ChronologyProtector
;
59 $required = array( 'sectionsByDB', 'sectionLoads', 'serverTemplate' );
60 $optional = array( 'groupLoadsBySection', 'groupLoadsByDB', 'hostsByName',
61 'externalLoads', 'externalTemplateOverrides', 'templateOverridesByServer',
62 'templateOverridesByCluster', 'masterTemplateOverrides',
63 'readOnlyBySection' );
65 foreach ( $required as $key ) {
66 if ( !isset( $conf[$key] ) ) {
67 throw new MWException( __CLASS__
.": $key is required in configuration" );
69 $this->$key = $conf[$key];
72 foreach ( $optional as $key ) {
73 if ( isset( $conf[$key] ) ) {
74 $this->$key = $conf[$key];
78 // Check for read-only mode
79 $section = $this->getSectionForWiki();
80 if ( !empty( $this->readOnlyBySection
[$section] ) ) {
82 $wgReadOnly = $this->readOnlyBySection
[$section];
87 * @param $wiki bool|string
90 function getSectionForWiki( $wiki = false ) {
91 if ( $this->lastWiki
=== $wiki ) {
92 return $this->lastSection
;
94 list( $dbName, ) = $this->getDBNameAndPrefix( $wiki );
95 if ( isset( $this->sectionsByDB
[$dbName] ) ) {
96 $section = $this->sectionsByDB
[$dbName];
100 $this->lastSection
= $section;
101 $this->lastWiki
= $wiki;
106 * @param $wiki bool|string
107 * @return LoadBalancer
109 function newMainLB( $wiki = false ) {
110 list( $dbName, ) = $this->getDBNameAndPrefix( $wiki );
111 $section = $this->getSectionForWiki( $wiki );
112 $groupLoads = array();
113 if ( isset( $this->groupLoadsByDB
[$dbName] ) ) {
114 $groupLoads = $this->groupLoadsByDB
[$dbName];
116 if ( isset( $this->groupLoadsBySection
[$section] ) ) {
117 $groupLoads = array_merge_recursive( $groupLoads, $this->groupLoadsBySection
[$section] );
119 return $this->newLoadBalancer( $this->serverTemplate
, $this->sectionLoads
[$section], $groupLoads );
123 * @param $wiki bool|string
124 * @return LoadBalancer
126 function getMainLB( $wiki = false ) {
127 $section = $this->getSectionForWiki( $wiki );
128 if ( !isset( $this->mainLBs
[$section] ) ) {
129 $lb = $this->newMainLB( $wiki, $section );
130 $this->chronProt
->initLB( $lb );
131 $lb->parentInfo( array( 'id' => "main-$section" ) );
132 $this->mainLBs
[$section] = $lb;
134 return $this->mainLBs
[$section];
140 * @return LoadBalancer
142 function newExternalLB( $cluster, $wiki = false ) {
143 if ( !isset( $this->externalLoads
[$cluster] ) ) {
144 throw new MWException( __METHOD__
.": Unknown cluster \"$cluster\"" );
146 $template = $this->serverTemplate
;
147 if ( isset( $this->externalTemplateOverrides
) ) {
148 $template = $this->externalTemplateOverrides +
$template;
150 if ( isset( $this->templateOverridesByCluster
[$cluster] ) ) {
151 $template = $this->templateOverridesByCluster
[$cluster] +
$template;
153 return $this->newLoadBalancer( $template, $this->externalLoads
[$cluster], array() );
159 * @return LoadBalancer
161 function &getExternalLB( $cluster, $wiki = false ) {
162 if ( !isset( $this->extLBs
[$cluster] ) ) {
163 $this->extLBs
[$cluster] = $this->newExternalLB( $cluster, $wiki );
164 $this->extLBs
[$cluster]->parentInfo( array( 'id' => "ext-$cluster" ) );
166 return $this->extLBs
[$cluster];
170 * Make a new load balancer object based on template and load array
172 * @return LoadBalancer
174 function newLoadBalancer( $template, $loads, $groupLoads ) {
175 global $wgMasterWaitTimeout;
176 $servers = $this->makeServerArray( $template, $loads, $groupLoads );
177 $lb = new LoadBalancer( array(
178 'servers' => $servers,
179 'masterWaitTimeout' => $wgMasterWaitTimeout
185 * Make a server array as expected by LoadBalancer::__construct, using a template and load array
192 function makeServerArray( $template, $loads, $groupLoads ) {
195 $groupLoadsByServer = $this->reindexGroupLoads( $groupLoads );
196 foreach ( $groupLoadsByServer as $server => $stuff ) {
197 if ( !isset( $loads[$server] ) ) {
201 foreach ( $loads as $serverName => $load ) {
202 $serverInfo = $template;
204 $serverInfo['master'] = true;
205 if ( isset( $this->masterTemplateOverrides
) ) {
206 $serverInfo = $this->masterTemplateOverrides +
$serverInfo;
210 if ( isset( $this->templateOverridesByServer
[$serverName] ) ) {
211 $serverInfo = $this->templateOverridesByServer
[$serverName] +
$serverInfo;
213 if ( isset( $groupLoadsByServer[$serverName] ) ) {
214 $serverInfo['groupLoads'] = $groupLoadsByServer[$serverName];
216 if ( isset( $this->hostsByName
[$serverName] ) ) {
217 $serverInfo['host'] = $this->hostsByName
[$serverName];
219 $serverInfo['host'] = $serverName;
221 $serverInfo['hostName'] = $serverName;
222 $serverInfo['load'] = $load;
223 $servers[] = $serverInfo;
229 * Take a group load array indexed by group then server, and reindex it by server then group
233 function reindexGroupLoads( $groupLoads ) {
234 $reindexed = array();
235 foreach ( $groupLoads as $group => $loads ) {
236 foreach ( $loads as $server => $load ) {
237 $reindexed[$server][$group] = $load;
244 * Get the database name and prefix based on the wiki ID
248 function getDBNameAndPrefix( $wiki = false ) {
249 if ( $wiki === false ) {
250 global $wgDBname, $wgDBprefix;
251 return array( $wgDBname, $wgDBprefix );
253 return wfSplitWikiID( $wiki );
258 * Execute a function for each tracked load balancer
259 * The callback is called with the load balancer as the first parameter,
260 * and $params passed as the subsequent parameters.
262 * @param $params array
264 function forEachLB( $callback, $params = array() ) {
265 foreach ( $this->mainLBs
as $lb ) {
266 call_user_func_array( $callback, array_merge( array( $lb ), $params ) );
268 foreach ( $this->extLBs
as $lb ) {
269 call_user_func_array( $callback, array_merge( array( $lb ), $params ) );
273 function shutdown() {
274 foreach ( $this->mainLBs
as $lb ) {
275 $this->chronProt
->shutdownLB( $lb );
277 $this->chronProt
->shutdown();
278 $this->commitMasterChanges();