Jcrespo has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/296372

Change subject: Prepare old servers for decom by sending all queries to new 
servers
......................................................................

Prepare old servers for decom by sending all queries to new servers

Increase weight of new servers to check they can handle on its own
the load; putting to-be-decommed or extra servers to be changed
role/shard at 0 weight.

Bug: T134476
Change-Id: I0be6e7d65349ed987df27e359982b73b4918faff
---
M wmf-config/db-eqiad.php
1 file changed, 36 insertions(+), 36 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/mediawiki-config 
refs/changes/72/296372/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 04d594c..2dad42d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -89,37 +89,37 @@
 'sectionLoads' => array(
        's1' => array(
                'db1057' => 0,   # 2.8TB  96GB, master
-               'db1052' => 50 , # 2.8TB  96GB, old master
+               'db1052' => 0  , # 2.8TB  96GB, old master
                'db1053' => 0,   # 2.8TB  96GB, vslow, dump
                'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
                'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
                'db1065' => 50,  # 2.8TB 160GB, api
                'db1066' => 50,  # 2.8TB 160GB, api
-               'db1072' => 450, # 2.8TB 160GB
-               'db1073' => 500, # 2.8TB 160GB
-               'db1080' => 300, # 3.6TB 512GB
-               'db1083' => 300, # 3.6TB 512GB
-               'db1089' => 300, # 3.6TB 512GB
+               'db1072' => 0,   # 2.8TB 160GB
+               'db1073' => 0,   # 2.8TB 160GB
+               'db1080' => 500, # 3.6TB 512GB
+               'db1083' => 500, # 3.6TB 512GB
+               'db1089' => 500, # 3.6TB 512GB
        ),
        's2' => array(
                'db1018' => 0,   # 1.4TB  64GB, master
-               'db1024' => 100, # 1.4TB  64GB, old master
+               'db1024' => 0,   # 1.4TB  64GB, old master
                'db1021' => 0,   # 1.4TB  64GB, vslow, dump
                'db1036' => 0,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
                'db1054' => 0,   # 2.8TB  96GB, api
                'db1060' => 0,   # 2.8TB  96GB, api
-               'db1063' => 400, # 2.8TB 128GB
-               'db1067' => 500, # 2.8TB 160GB
+               'db1063' => 0,   # 2.8TB 128GB
+               'db1067' => 0,   # 2.8TB 160GB
                'db1074' => 500, # 3.6TB 512GB
                'db1076' => 500, # 3.6TB 512GB
-               'db1090' => 300, # 3.6TB 512GB
+               'db1090' => 500, # 3.6TB 512GB
        ),
        /* s3 */ 'DEFAULT' => array(
                'db1075' => 0,   # 3.6TB 512GB, master
                'db1038' => 0,   # 1.4TB  64GB, vslow, dump, old master
-               'db1015' => 100, # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-               'db1035' => 100, # 1.4TB  64GB
-               'db1044' => 100, # 1.4TB  64GB
+               'db1015' => 0  , # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+               'db1035' => 0,   # 1.4TB  64GB
+               'db1044' => 0,   # 1.4TB  64GB
                'db1077' => 500, # 3.6TB 512GB
                'db1078' => 500, # 3.6TB 512GB
        ),
@@ -129,11 +129,11 @@
                'db1019' => 0,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
                'db1056' => 0,   # 2.8TB  96GB, api
                'db1059' => 0,   # 2.8TB  96GB, api
-               'db1064' => 500, # 2.8TB 160GB
-               'db1068' => 500, # 2.8TB 160GB
-               'db1081' => 300, # 3.6TB 512GB
-               'db1084' => 300, # 3.6TB 512GB
-               'db1091' => 300, # 3.6TB 512GB
+               'db1064' => 0,   # 2.8TB 160GB
+               'db1068' => 0,   # 2.8TB 160GB
+               'db1081' => 500, # 3.6TB 512GB
+               'db1084' => 500, # 3.6TB 512GB
+               'db1091' => 500, # 3.6TB 512GB
        ),
        's5' => array(
                'db1049' => 0,   # 2.8TB  64GB, master
@@ -141,31 +141,31 @@
                'db1045' => 0,   # 1.4TB  64GB, vslow, dump
                'db1070' => 50,  # 2.8TB 160GB, api, old master
                'db1071' => 50,  # 2.8TB 160GB, api
-               'db1082' => 300, # 3.6TB 512GB
-               'db1087' => 300, # 3.6TB 512GB
-               'db1092' => 300, # 3.6TB 512GB
+               'db1082' => 500, # 3.6TB 512GB
+               'db1087' => 500, # 3.6TB 512GB
+               'db1092' => 500, # 3.6TB 512GB
        ),
        's6' => array(
                'db1050' => 0,   # 2.8TB  64GB, master
-               'db1023' => 200, # 1.4TB  64GB, old master
-               'db1022' => 100, # 1.4TB  64GB, api
+               'db1023' => 0,   # 1.4TB  64GB, old master
+               'db1022' => 0,   # 1.4TB  64GB, api
                'db1030' => 0,   # 1.4TB  64GB, vslow, dump
-               'db1037' => 50,  # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-               'db1061' => 500, # 2.8TB 128GB
-               'db1085' => 300, # 3.6TB 512GB
-               'db1088' => 300, # 3.6TB 512GB
-               'db1093' => 300, # 3.6TB 512GB
+               'db1037' => 0,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+               'db1061' => 0,   # 2.8TB 128GB
+               'db1085' => 500, # 3.6TB 512GB
+               'db1088' => 500, # 3.6TB 512GB
+               'db1093' => 500, # 3.6TB 512GB
        ),
        's7' => array(
                'db1041' => 0,   # 1.4TB  64GB, master
-               'db1033' => 150, # 1.4TB  64GB, old master
-               'db1028' => 50,  # 1.4TB  64GB, vslow, dump
-               'db1034' => 150, # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-               'db1039' => 300, # 1.4TB  64GB
-               'db1062' => 500, # 2.8TB 128GB
-               'db1079' => 300, # 3.6TB 512GB
-               'db1086' => 300, # 3.6TB 512GB
-               'db1094' => 300, # 3.6TB 512GB
+               'db1033' => 0,   # 1.4TB  64GB, old master
+               'db1028' => 0,   # 1.4TB  64GB, vslow, dump
+               'db1034' => 0,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+               'db1039' => 0,   # 1.4TB  64GB
+               'db1062' => 0,   # 2.8TB 128GB
+               'db1079' => 500, # 3.6TB 512GB
+               'db1086' => 500, # 3.6TB 512GB
+               'db1094' => 500, # 3.6TB 512GB
        ),
        'silver' => array(
                'silver' => 100,   # I have no idea if this is right

-- 
To view, visit https://gerrit.wikimedia.org/r/296372
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0be6e7d65349ed987df27e359982b73b4918faff
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Jcrespo <[email protected]>

_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to