'10.192.0.104', # pc2007, A1 4.4TB 256GB # pc1 'pc2' => '10.192.16.35', # pc2008, B3 4.4TB 256GB # pc2 'pc3' => '10.192.32.10', # pc2009, C1 4.4TB 256GB # pc3 # 'spare' => '10.192.48.14', # pc2010, D3 4.4TB 256GB # spare host. Use it to replace any of the above if needed ]; # LOOKING FOR $wmgOldExtTemplate ? It no longer lives in the PHP configs. # Instead try https://noc.wikimedia.org/dbconfig/codfw.json (see 'es1') # For more info see also https://wikitech.wikimedia.org/wiki/dbctl $wgLBFactoryConf = [ 'class' => 'LBFactoryMulti', 'secret' => $wgSecretKey, 'sectionsByDB' => [ # s1: enwiki 'enwiki' => 's1', # s2: large wikis 'bgwiki' => 's2', 'bgwiktionary' => 's2', 'cswiki' => 's2', 'enwikiquote' => 's2', 'enwiktionary' => 's2', 'eowiki' => 's2', 'fiwiki' => 's2', 'idwiki' => 's2', 'itwiki' => 's2', 'nlwiki' => 's2', 'nowiki' => 's2', 'plwiki' => 's2', 'ptwiki' => 's2', 'svwiki' => 's2', 'thwiki' => 's2', 'trwiki' => 's2', 'zhwiki' => 's2', # s3 (default) # s4: commons 'commonswiki' => 's4', 'testcommonswiki' => 's4', # s5: dewiki and some other wikis 'altwiki' => 's5', 'apiportalwiki' => 's5', 'arbcom_ruwiki' => 's5', 'avkwiki' => 's5', 'banwikisource' => 's5', 'bclwiktionary' => 's5', 'cebwiki' => 's5', 'dagwiki' => 's5', 'dewiki' => 's5', 'diqwiktionary' => 's5', 'enwikivoyage' => 's5', 'eowikivoyage' => 's5', 'jawikivoyage' => 's5', 'lldwiki' => 's5', 'mniwiki' => 's5', 'mniwiktionary' => 's5', 'mnwwiktionary' => 's5', 'niawiki' => 's5', 'niawiktionary' => 's5', 'madwiki' => 's5', 'mgwiktionary' => 's5', 'mhwiktionary' => 's5', 'muswiki' => 's5', 'skrwiki' => 's5', 'skrwiktionary' => 's5', 'shwiki' => 's5', 'shiwiki' => 's5', 'smnwiki' => 's5', 'srwiki' => 's5', 'taywiki' => 's5', 'thankyouwiki' => 's5', 'trwikivoyage' => 's5', 'trvwiki' => 's5', 'wawikisource' => 's5', # s6: large wikis 'frwiki' => 's6', 'jawiki' => 's6', 'ruwiki' => 's6', # s7: large wikis, centralauth 'eswiki' => 's7', 'huwiki' => 's7', 'hewiki' => 's7', 'ukwiki' => 's7', 'frwiktionary' => 's7', 'metawiki' => 's7', 'arwiki' => 's7', 'centralauth' => 's7', 'cawiki' => 's7', 'viwiki' => 's7', 'fawiki' => 's7', 'rowiki' => 's7', 'kowiki' => 's7', # s8: wikidata 'wikidatawiki' => 's8', # Wikitech and its test wiki 'labswiki' => 's10', 'labtestwiki' => 's11', ], # Load lists # # Masters should be in slot [0]. # # All servers for which replication lag matters should be in the load # list, not commented out, because otherwise maintenance scripts such # as compressOld.php won't wait for those servers when they lag. # # Conversely, all servers which are down or do not replicate should be # removed, not set to load zero, because there are certain situations # when load zero servers will be used, such as if the others are lagged. # Servers which are down should be removed to avoid a timeout overhead # per invocation. # # Additionally, if a server should not to be lagged (for example, # an api node, or a recentchanges node, set the load to at least 1. # This will make the node be taken into account on the wait for lag # function (the master is not included, as by definition has lag 0). # # LOOKING FOR THE LOAD LISTS? They no longer live in the PHP configs. # Instead try https://noc.wikimedia.org/db.php?dc=codfw and # https://noc.wikimedia.org/dbconfig/codfw.json # For more info see also https://wikitech.wikimedia.org/wiki/dbctl 'serverTemplate' => [ 'dbname' => $wgDBname, 'user' => $wgDBuser, 'password' => $wgDBpassword, 'type' => 'mysql', 'flags' => DBO_DEFAULT | ( $wgDebugDumpSql ? DBO_DEBUG : 0 ), 'max lag' => 6, // should be safely less than $wgCdnReboundPurgeDelay 'useGTIDs' => true, 'lagDetectionMethod' => 'pt-heartbeat', 'variables' => [ 'innodb_lock_wait_timeout' => 15 ] ], 'templateOverridesBySection' => [ 's1' => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's1', 'datacenter' => $wmfMasterDatacenter ] ], ], 's2' => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's2', 'datacenter' => $wmfMasterDatacenter ] ], ], 'DEFAULT' /* s3 */ => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's3', 'datacenter' => $wmfMasterDatacenter ] ], ], 's4' => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's4', 'datacenter' => $wmfMasterDatacenter ] ], ], 's5' => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's5', 'datacenter' => $wmfMasterDatacenter ] ], ], 's6' => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's6', 'datacenter' => $wmfMasterDatacenter ] ], ], 's7' => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's7', 'datacenter' => $wmfMasterDatacenter ] ], ], 's8' => [ 'lagDetectionOptions' => [ 'conds' => [ 'shard' => 's8', 'datacenter' => $wmfMasterDatacenter ] ], ], ], # LOOKING FOR GROUP LOADS? They no longer live in the PHP configs. # Instead try https://noc.wikimedia.org/dbconfig/codfw.json # For more info see also https://wikitech.wikimedia.org/wiki/dbctl 'groupLoadsByDB' => [], # LOOKING FOR HOSTS BY NAME? They no longer live in the PHP configs. # Instead try https://noc.wikimedia.org/dbconfig/codfw.json # For more info see also https://wikitech.wikimedia.org/wiki/dbctl 'hostsByName' => [], # LOOKING FOR EXTERNAL LOADS? They no longer live in the PHP configs. # Instead try https://noc.wikimedia.org/dbconfig/codfw.json (see es1/es2/es3/x1) # For more info see also https://wikitech.wikimedia.org/wiki/dbctl 'externalLoads' => [], 'masterTemplateOverrides' => [], 'externalTemplateOverrides' => [ 'flags' => $wgDebugDumpSql ? DBO_DEBUG : 0, // No transactions 'lagDetectionMethod' => 'Seconds_Behind_Master', // no pt-heartbeat ], 'templateOverridesByCluster' => [ 'rc1' => [ 'is static' => true ], 'cluster1' => [ 'blobs table' => 'blobs_cluster1', 'is static' => true ], 'cluster2' => [ 'blobs table' => 'blobs_cluster2', 'is static' => true ], 'cluster3' => [ 'blobs table' => 'blobs_cluster3', 'is static' => true ], 'cluster4' => [ 'blobs table' => 'blobs_cluster4', 'is static' => true ], 'cluster5' => [ 'blobs table' => 'blobs_cluster5', 'is static' => true ], 'cluster6' => [ 'blobs table' => 'blobs_cluster6', 'is static' => true ], 'cluster7' => [ 'blobs table' => 'blobs_cluster7', 'is static' => true ], 'cluster8' => [ 'blobs table' => 'blobs_cluster8', 'is static' => true ], 'cluster9' => [ 'blobs table' => 'blobs_cluster9', 'is static' => true ], 'cluster10' => [ 'blobs table' => 'blobs_cluster10', 'is static' => true ], 'cluster20' => [ 'blobs table' => 'blobs_cluster20', 'is static' => true ], 'cluster21' => [ 'blobs table' => 'blobs_cluster21', 'is static' => true ], 'cluster22' => [ 'blobs table' => 'blobs_cluster22', 'is static' => true ], 'cluster23' => [ 'blobs table' => 'blobs_cluster23', 'is static' => true ], 'cluster24' => [ 'blobs table' => 'blobs_cluster24', 'is static' => true ], 'cluster25' => [ 'blobs table' => 'blobs_cluster25', 'is static' => true ], 'cluster26' => [ 'blobs table' => 'blobs_cluster26' ], 'cluster27' => [ 'blobs table' => 'blobs_cluster27' ], ], # This key must exist for the master switch script to work, which means comment and uncomment # the individual shards, but leave the 'readOnlyBySection' => [ ], alone. # # When going read only, please change the comment to something appropiate (like a brief idea # of what is happening, with a wiki link for further explanation. Avoid linking to external # infrastructure if possible (IRC, other webpages) or infrastructure not prepared to absorve # large traffic (phabricator) because they tend to collapse. A meta page would be appropiate. # # Also keep these read only messages if codfw is not the active dc, to prevent accidental writes # getting trasmmitted from codfw to eqiad when the master dc is eqiad. 'readOnlyBySection' => [ # LOOKING FOR READONLY SECTIONS? They no longer live in the PHP configs. # Instead try https://noc.wikimedia.org/dbconfig/codfw.json # For more info see also https://wikitech.wikimedia.org/wiki/dbctl ], ]; $wgDefaultExternalStore = [ 'DB://cluster26', 'DB://cluster27', ];