[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Add comment about bad BBU

2017-01-31 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335195 )

Change subject: db-eqiad.php: Add comment about bad BBU
..

db-eqiad.php: Add comment about bad BBU

db1072 might have a bad BBU and I have forced WriteBack to help it to
catch up with the master. We should not repool it yet, check:
T156226#2984963

Bug: T156226
Change-Id: I233c377f9750dd25a6d6540b6fbd7c912517f74d
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 7c08066..5c9c558 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,7 +99,7 @@
 #  'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
-#  'db1072' => 10,  # B2 2.8TB 160GB, api #T156226
+#  'db1072' => 10,  # B2 2.8TB 160GB, api #T156226 #possible bad 
BBU
'db1073' => 50,  # D1 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB, api
'db1083' => 500, # B1 3.6TB 512GB

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I233c377f9750dd25a6d6540b6fbd7c912517f74d
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Repool hosts in C2

2017-01-31 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335198 )

Change subject: db-eqiad.php: Repool hosts in C2
..

db-eqiad.php: Repool hosts in C2

C2 switch maintenance is over and so far it is behaving well, so we can
probably repool the hosts that were depooled beacuse the live in that
rack.
There were already some other hosts in that rack which were pooled.

Bug: T155999
Change-Id: I12aec6845dc6ae9c8e2115b89e8e3a9fb65bde29
---
M wmf-config/db-eqiad.php
1 file changed, 14 insertions(+), 14 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5c9c558..a7503bb 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -96,7 +96,7 @@
'db1052' => 0,   # B3 2.8TB  96GB, master
 #  'db1057' => 0,   # C2 2.8TB  96GB, old master
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+   'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
 #  'db1072' => 10,  # B2 2.8TB 160GB, api #T156226 #possible bad 
BBU
@@ -130,8 +130,8 @@
's4' => [
'db1040' => 0,   # B2 1.4TB  64GB, master
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1059' => 1,   # C2 2.8TB  96GB, api
+   'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+   'db1059' => 1,   # C2 2.8TB  96GB, api
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
@@ -239,23 +239,23 @@
's1' => [
'watchlist' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'recentchanges' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'recentchangeslinked' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'contributions' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'logpager' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'dump' => [
'db1065' => 1,
@@ -327,28 +327,28 @@
'db1064' => 1,
],
'api' => [
-#  'db1059' => 1,
+   'db1059' => 1,
'db1068' => 3,
],
'watchlist' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'recentchanges' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'recentchangeslinked' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'contributions' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'logpager' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
],
's5' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I12aec6845dc6ae9c8e2115b89e8e3a9fb65bde29
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Depool db2061

2017-01-31 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335404 )

Change subject: db-codfw.php: Depool db2061
..

db-codfw.php: Depool db2061

db2061 needs an ALTER table

Bug: T153300
Change-Id: Ie2926566b0d3a158629603606abfe71f770b9e3d
---
M wmf-config/db-codfw.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 2438b76..7c48b6f 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -145,9 +145,9 @@
's7' => [
'db2029' => 0,   # B6 2.9TB  96GB, master
'db2040' => 200, # C6 2.9TB 160GB, rc, log
-   'db2047' => 400, # C6 2.9TB 160GB
+   'db2047' => 200, # C6 2.9TB 160GB #temporary api #T153300
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
-   'db2061' => 200, # D6 3.3TB 160GB, api
+#  'db2061' => 200, # D6 3.3TB 160GB, api
'db2068' => 300, # D6 3.3TB 160GB
],
'silver' => [
@@ -407,7 +407,7 @@
'db2054' => 1,
],
'api' => [
-   'db2061' => 1,
+   'db2047' => 1,
],
],
 ],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie2926566b0d3a158629603606abfe71f770b9e3d
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Change db1064 to ROW

2017-02-01 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335407 )

Change subject: site.pp: Change db1064 to ROW
..

site.pp: Change db1064 to ROW

db1064 is going to be db1095 (new sanitarium) master soon and thus needs its
binary log changed to ROW based replication

Bug: T153743
Change-Id: I61ec1863c5eef9b7ffb3ebe990f9ee2c9c2a5e73
---
M manifests/site.pp
1 file changed, 9 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/07/335407/1

diff --git a/manifests/site.pp b/manifests/site.pp
index 678ddea..1e55430 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -531,12 +531,20 @@
 }
 }
 
-node /^db10(53|56|59|64|68|81|84|91)\.eqiad\.wmnet/ {
+node /^db10(53|56|59|68|81|84|91)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's4',
 }
 }
 
+# row-based replication to sanitarium2 (T150960)
+node 'db1064.eqiad.wmnet' {
+class { 'role::mariadb::core':
+shard => 's4',
+binlog_format => 'ROW',
+}
+}
+
 # s4 (commons) core production dbs on codfw
 # codfw master
 node 'db2019.codfw.wmnet' {

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I61ec1863c5eef9b7ffb3ebe990f9ee2c9c2a5e73
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-codfw.php: Depool db2061"

2017-02-01 Thread Marostegui (Code Review) 
Hello jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-codfw.php: Depool db2061"
..

Revert "db-codfw.php: Depool db2061"

ALTER table finished

This reverts commit 022106bcd526a215e9f71b12117461b29b8af844.

Change-Id: Ic29e643c354832e6ca1506cddc7aea429ec55009
---
M wmf-config/db-codfw.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 7c48b6f..2438b76 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -145,9 +145,9 @@
's7' => [
'db2029' => 0,   # B6 2.9TB  96GB, master
'db2040' => 200, # C6 2.9TB 160GB, rc, log
-   'db2047' => 200, # C6 2.9TB 160GB #temporary api #T153300
+   'db2047' => 400, # C6 2.9TB 160GB
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
-#  'db2061' => 200, # D6 3.3TB 160GB, api
+   'db2061' => 200, # D6 3.3TB 160GB, api
'db2068' => 300, # D6 3.3TB 160GB
],
'silver' => [
@@ -407,7 +407,7 @@
'db2054' => 1,
],
'api' => [
-   'db2047' => 1,
+   'db2061' => 1,
],
],
 ],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic29e643c354832e6ca1506cddc7aea429ec55009
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Repool db1072

2017-02-06 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336376 )

Change subject: db-eqiad.php: Repool db1072
..

db-eqiad.php: Repool db1072

After changing the BBU db1072 looks good and it is ready to be back in
the pool

Bug: T156226
Change-Id: I7c06e73c8f4a4479b358559b046bf055574fde93
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 11d7cca..a4386e9 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,9 +99,9 @@
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
-#  'db1072' => 10,  # B2 2.8TB 160GB, api #T156226 #possible bad 
BBU
+   'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # D1 2.8TB 160GB, api
-   'db1080' => 500, # A2 3.6TB 512GB, api
+   'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
@@ -265,7 +265,7 @@
],
'api' => [
'db1066' => 1,
-#  'db1072' => 1,
+   'db1072' => 1,
'db1073' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I7c06e73c8f4a4479b358559b046bf055574fde93
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Change db1073 IP

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336633 )

Change subject: db-codfw,db-eqiad.php: Change db1073 IP
..

db-codfw,db-eqiad.php: Change db1073 IP

db1073 is going to be moved to another rack and needs its IP changed

Bug: T156126
Change-Id: Id4abb95de5edf54a66fef0dc3f86d702a0c7a4f0
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 20ffe16..2349226 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -467,7 +467,7 @@
'db1070' => '10.64.48.25', # do not remove or comment out
'db1071' => '10.64.48.26', # do not remove or comment out
'db1072' => '10.64.16.39', # do not remove or comment out
-   'db1073' => '10.64.48.28', # do not remove or comment out
+   'db1073' => '10.64.16.79', # do not remove or comment out
'db1074' => '10.64.0.204', # do not remove or comment out
'db1075' => '10.64.0.205', # do not remove or comment out
'db1076' => '10.64.16.190', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a96e05f..72ecd11 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -494,7 +494,7 @@
'db1070' => '10.64.48.25', # do not remove or comment out
'db1071' => '10.64.48.26', # do not remove or comment out
'db1072' => '10.64.16.39', # do not remove or comment out
-   'db1073' => '10.64.48.28', # do not remove or comment out
+   'db1073' => '10.64.16.79', # do not remove or comment out
'db1074' => '10.64.0.204', # do not remove or comment out
'db1075' => '10.64.0.205', # do not remove or comment out
'db1076' => '10.64.16.190', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id4abb95de5edf54a66fef0dc3f86d702a0c7a4f0
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/dns[master]: Update db1073 IP to match rack change to B3

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/336631 )

Change subject: Update db1073 IP to match rack change to B3
..


Update db1073 IP to match rack change to B3

Bug: T156126
Change-Id: I708a4c60862a47ff72b635b33200ab69541930b8
---
M templates/10.in-addr.arpa
M templates/wmnet
2 files changed, 2 insertions(+), 2 deletions(-)

Approvals:
  Cmjohnson: Looks good to me, but someone else must approve
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/templates/10.in-addr.arpa b/templates/10.in-addr.arpa
index c429a9d..5b4da31 100644
--- a/templates/10.in-addr.arpa
+++ b/templates/10.in-addr.arpa
@@ -511,6 +511,7 @@
 76  1H IN PTR   db1051.eqiad.wmnet.
 77  1H IN PTR   db1052.eqiad.wmnet.
 78  1H IN PTR   aqs1008-b.eqiad.wmnet. ; cassandra instance
+79  1H IN PTR   db1073.eqiad.wmnet.
 101 1H IN PTR   db1083.eqiad.wmnet.
 102 1H IN PTR   db1084.eqiad.wmnet.
 103 1H IN PTR   db1085.eqiad.wmnet.
@@ -970,7 +971,6 @@
 25  1H IN PTR   db1070.eqiad.wmnet.
 26  1H IN PTR   db1071.eqiad.wmnet.
 
-28  1H IN PTR   db1073.eqiad.wmnet.
 29  1H IN PTR   scb1004.eqiad.wmnet.
 30  1H IN PTR   ms-be1013.eqiad.wmnet.
 31  1H IN PTR   ms-be1014.eqiad.wmnet.
diff --git a/templates/wmnet b/templates/wmnet
index 6bc5f52..31d0657 100644
--- a/templates/wmnet
+++ b/templates/wmnet
@@ -301,7 +301,7 @@
 db1070  1H  IN A10.64.48.25
 db1071  1H  IN A10.64.48.26
 db1072  1H  IN A10.64.16.39
-db1073  1H  IN A10.64.48.28
+db1073  1H  IN A10.64.16.79
 db1074  1H  IN A10.64.0.204
 db1075  1H  IN A10.64.0.205
 db1076  1H  IN A10.64.16.190

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I708a4c60862a47ff72b635b33200ab69541930b8
Gerrit-PatchSet: 3
Gerrit-Project: operations/dns
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Cmjohnson 
Gerrit-Reviewer: Elukey 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/dns[master]: Update db1072 IP to match rack change to B3

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336631 )

Change subject: Update db1072 IP to match rack change to B3
..

Update db1072 IP to match rack change to B3

Bug: T156126
Change-Id: I708a4c60862a47ff72b635b33200ab69541930b8
---
M templates/10.in-addr.arpa
M templates/wmnet
2 files changed, 2 insertions(+), 2 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/dns 
refs/changes/31/336631/1

diff --git a/templates/10.in-addr.arpa b/templates/10.in-addr.arpa
index c429a9d..1f13662 100644
--- a/templates/10.in-addr.arpa
+++ b/templates/10.in-addr.arpa
@@ -441,6 +441,7 @@
 1   1H IN PTR   vrrp-gw-1018.eqiad.wmnet.
 2   1H IN PTR   ae2-1018.cr1-eqiad.wikimedia.org.
 3   1H IN PTR   ae2-1018.cr2-eqiad.wikimedia.org.
+4   1H IN PTR   db1072.eqiad.wmnet.
 6   1H IN PTR   graphite1002.eqiad.wmnet.
 7   1H IN PTR   db1018.eqiad.wmnet.
 9   1H IN PTR   db1020.eqiad.wmnet.
@@ -471,7 +472,6 @@
 36  1H IN PTR   db1047.eqiad.wmnet.
 37  1H IN PTR   db1048.eqiad.wmnet.
 38  1H IN PTR   prometheus1004.eqiad.wmnet.
-39  1H IN PTR   db1072.eqiad.wmnet.
 40  1H IN PTR   ms-be1020.eqiad.wmnet.
 41  1H IN PTR   kafka1002.eqiad.wmnet.
 42  1H IN PTR   maps1002.eqiad.wmnet.
diff --git a/templates/wmnet b/templates/wmnet
index 6bc5f52..911e0f9 100644
--- a/templates/wmnet
+++ b/templates/wmnet
@@ -300,7 +300,7 @@
 db1069  1H  IN A10.64.48.24
 db1070  1H  IN A10.64.48.25
 db1071  1H  IN A10.64.48.26
-db1072  1H  IN A10.64.16.39
+db1072  1H  IN A10.64.16.4
 db1073  1H  IN A10.64.48.28
 db1074  1H  IN A10.64.0.204
 db1075  1H  IN A10.64.0.205

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I708a4c60862a47ff72b635b33200ab69541930b8
Gerrit-PatchSet: 1
Gerrit-Project: operations/dns
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: check_private_data.py: Add missing quote

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336600 )

Change subject: check_private_data.py: Add missing quote
..

check_private_data.py: Add missing quote

There is a missing quote on the UPDATE statement the script returns when
it find private data on a column.
This is what it shows:

-- UPDATE `commonswiki`.abuse_filter_log`   SET `afl_ip` = NULL;

Which is missing the `abuse

Bug: T153743
Change-Id: Icbbb594b611c9422d40ca0e63acc5a5819dc9aa4
---
M modules/role/files/mariadb/check_private_data.py
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/00/336600/1

diff --git a/modules/role/files/mariadb/check_private_data.py 
b/modules/role/files/mariadb/check_private_data.py
index 769be5a..475fa6c 100644
--- a/modules/role/files/mariadb/check_private_data.py
+++ b/modules/role/files/mariadb/check_private_data.py
@@ -179,7 +179,7 @@
 on the list
 """
 for col in cols:
-print(("-- UPDATE `{}`.{}`"
+print(("-- UPDATE `{}`.`{}`"
"   SET `{}` = NULL;").format(col[0], col[1], col[2]))
 
 

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Icbbb594b611c9422d40ca0e63acc5a5819dc9aa4
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: check_private_data.py: Add missing quote

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/336600 )

Change subject: check_private_data.py: Add missing quote
..


check_private_data.py: Add missing quote

There is a missing quote on the UPDATE statement the script returns when
it find private data on a column.
This is what it shows:

-- UPDATE `commonswiki`.abuse_filter_log`   SET `afl_ip` = NULL;

Which is missing the `abuse

Bug: T153743
Change-Id: Icbbb594b611c9422d40ca0e63acc5a5819dc9aa4
---
M modules/role/files/mariadb/check_private_data.py
1 file changed, 1 insertion(+), 1 deletion(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified
  Jcrespo: Looks good to me, but someone else must approve



diff --git a/modules/role/files/mariadb/check_private_data.py 
b/modules/role/files/mariadb/check_private_data.py
index 769be5a..475fa6c 100644
--- a/modules/role/files/mariadb/check_private_data.py
+++ b/modules/role/files/mariadb/check_private_data.py
@@ -179,7 +179,7 @@
 on the list
 """
 for col in cols:
-print(("-- UPDATE `{}`.{}`"
+print(("-- UPDATE `{}`.`{}`"
"   SET `{}` = NULL;").format(col[0], col[1], col[2]))
 
 

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Icbbb594b611c9422d40ca0e63acc5a5819dc9aa4
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: Volans 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1073

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336612 )

Change subject: db-eqiad.php: Depool db1073
..

db-eqiad.php: Depool db1073

db1073 is going to be moved to B3

Bug: T156126
Change-Id: I6eeda0c18d542b440e3e93f87be858af04f5272c
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 1458735..7fa48eb 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -100,7 +100,7 @@
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
-   'db1073' => 50,  # D1 2.8TB 160GB, api
+#  'db1073' => 50,  # B3 2.8TB 160GB, api #T156126
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
@@ -266,7 +266,7 @@
'api' => [
'db1066' => 1,
'db1072' => 1,
-   'db1073' => 1,
+#  'db1073' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6eeda0c18d542b440e3e93f87be858af04f5272c
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Depool db2060

2017-02-03 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335980 )

Change subject: db-codfw.php: Depool db2060
..

db-codfw.php: Depool db2060

db2060 needs its controller replaced on Monday, so depooling it.
Add db2067 to temporary serve API traffic

Bug: T156161
Change-Id: I36f8c62616b362341113d8a6fc1711780c0e05ec
---
M wmf-config/db-codfw.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 2438b76..20ffe16 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -139,8 +139,8 @@
'db2039' => 50,  # C6 2.9TB 160GB, rc, log
'db2046' => 400, # C6 2.9TB 160GB
'db2053' => 100, # D6 2.9TB 160GB, dump (inactive), vslow
-   'db2060' => 100, # D6 3.3TB 160GB, api
-   'db2067' => 400, # D6 3.3TB 160GB
+#  'db2060' => 100, # D6 3.3TB 160GB, api #T156161
+   'db2067' => 200, # D6 3.3TB 160GB, api #Temporary api #T156161
],
's7' => [
'db2029' => 0,   # B6 2.9TB  96GB, master
@@ -381,7 +381,7 @@
'db2053' => 1,
],
'api' => [
-   'db2060' => 1,
+   'db2067' => 1,
],
],
's7' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I36f8c62616b362341113d8a6fc1711780c0e05ec
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Use the common gtid_domain_id

2017-02-05 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/335817 )

Change subject: mariadb: Use the common gtid_domain_id
..


mariadb: Use the common gtid_domain_id

The labsdb hosts were still using the old way of generating
gtid_domain_id flag, which we changed. So for consistency just updating
the file to use the new one. This will not change the current value of
gtid_domain_id.
This is related to: https://gerrit.wikimedia.org/r/#/c/326086/

Bug: T149418
Change-Id: I721f29f0a10bd075423ea26094955b9f617b6d17
---
M templates/mariadb/labsdb-replica.my.cnf.erb
1 file changed, 7 insertions(+), 2 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified
  Jcrespo: Looks good to me, but someone else must approve



diff --git a/templates/mariadb/labsdb-replica.my.cnf.erb 
b/templates/mariadb/labsdb-replica.my.cnf.erb
index 21a44b3..63c744e 100644
--- a/templates/mariadb/labsdb-replica.my.cnf.erb
+++ b/templates/mariadb/labsdb-replica.my.cnf.erb
@@ -25,11 +25,16 @@
 port   = 3306
 datadir= <%= @datadir %>
 tmpdir = <%= @tmpdir %>
-# needed for multisource replication + GTID.
-gtid_domain_id = <%= @server_id %>
 server_id  = <%= @server_id %>
 read_only  = 0
 
+# gtid_domain_id flag is needed for multisource replication and GTID.
+# Strictly it is only needed on masters or servers that can potentially be
+# masters but for consistency it should be set in all of them.
+# https://mariadb.com/kb/en/mariadb/gtid/
+
+gtid_domain_id  = <%= @gtid_domain_id %>
+
 # enable socket authentication
 plugin-load = unix_socket=auth_socket.so
 

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I721f29f0a10bd075423ea26094955b9f617b6d17
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1064

2017-02-06 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336194 )

Change subject: db-eqiad.php: Depool db1064
..

db-eqiad.php: Depool db1064

db1064 is going to export dewiki and commonswiki to db1095 and needs to
be depooled.
Pool db1068 to vslow and remove it from API just in case it suffers
delays.
db1081 will help with API

Bug: T153743
Change-Id: I138509529cbce94560fe4338cb68a40a79879a0e
---
M wmf-config/db-eqiad.php
1 file changed, 6 insertions(+), 6 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a7503bb..642dda2 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -132,9 +132,9 @@
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1059' => 1,   # C2 2.8TB  96GB, api
-   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
-   'db1068' => 1,   # D1 2.8TB 160GB, api
-   'db1081' => 500, # A2 3.6TB 512GB
+#  'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095
+   'db1068' => 0,   # D1 2.8TB 160GB, #temp vslow, dump #T153743
+   'db1081' => 300, # A2 3.6TB 512GB, #temp api #T153743
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
],
@@ -321,14 +321,14 @@
],
's4' => [
'vslow' => [
-   'db1064' => 1,
+   'db1068' => 1,
],
'dump' => [
-   'db1064' => 1,
+   'db1068' => 1,
],
'api' => [
'db1059' => 1,
-   'db1068' => 3,
+   'db1081' => 1,
],
'watchlist' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I138509529cbce94560fe4338cb68a40a79879a0e
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1028

2017-02-06 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336198 )

Change subject: db-eqiad.php: Depool db1028
..

db-eqiad.php: Depool db1028

db1028 needs an ALTER table.
Pool db1039 temporarily for vslow and dump

Bug: T153300
Change-Id: I4c4f957272faecde389b6be68222323ed8c54e94
---
M wmf-config/db-eqiad.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 642dda2..11d7cca 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -162,9 +162,9 @@
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master
 #  'db1033' => 0,   # B2 1.4TB  64GB, old master
-   'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump
+#  'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump #T153300
'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1039' => 0,   # B2 1.4TB  64GB
+   'db1039' => 0,   # B2 1.4TB  64GB, #temp vslow, dump #T153300
'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
'db1086' => 500, # B3 3.6TB 512GB, api
@@ -406,10 +406,10 @@
],
's7' => [
'vslow' => [
-   'db1028' => 1,
+   'db1039' => 1,
],
'dump' => [
-   'db1028' => 1,
+   'db1039' => 1,
],
'api' => [
'db1079' => 100,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4c4f957272faecde389b6be68222323ed8c54e94
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Change db1064 to ROW

2017-02-03 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/335407 )

Change subject: site.pp: Change db1064 to ROW
..


site.pp: Change db1064 to ROW

db1064 is going to be db1095 (new sanitarium) master soon and thus needs its
binary log changed to ROW based replication

Bug: T153743
Change-Id: I61ec1863c5eef9b7ffb3ebe990f9ee2c9c2a5e73
---
M manifests/site.pp
1 file changed, 9 insertions(+), 1 deletion(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/manifests/site.pp b/manifests/site.pp
index 05b6d12..b08e3b1 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -531,12 +531,20 @@
 }
 }
 
-node /^db10(53|56|59|64|68|81|84|91)\.eqiad\.wmnet/ {
+node /^db10(53|56|59|68|81|84|91)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's4',
 }
 }
 
+# row-based replication to sanitarium2 (T150960)
+node 'db1064.eqiad.wmnet' {
+class { 'role::mariadb::core':
+shard => 's4',
+binlog_format => 'ROW',
+}
+}
+
 # s4 (commons) core production dbs on codfw
 # codfw master
 node 'db2019.codfw.wmnet' {

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I61ec1863c5eef9b7ffb3ebe990f9ee2c9c2a5e73
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1064"

2017-02-03 Thread Marostegui (Code Review) 
Hello jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1064"
..

Revert "db-eqiad.php: Depool db1064"

Maintenance is finished

This reverts commit 8abe377586d549e19a784b0cd9956b9f46f62ba0.

Change-Id: Ib5449885c776c4c23b32afd33dba0645a80f9e3d
---
M wmf-config/db-eqiad.php
1 file changed, 6 insertions(+), 6 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f574156..a7503bb 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -132,8 +132,8 @@
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1059' => 1,   # C2 2.8TB  96GB, api
-#  'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
-   'db1068' => 1,   # D1 2.8TB 160GB, api, vslow, dump #temporary 
vslow T153743
+   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
+   'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
@@ -321,14 +321,14 @@
],
's4' => [
'vslow' => [
-   'db1068' => 1,
+   'db1064' => 1,
],
'dump' => [
-   'db1068' => 1,
+   'db1064' => 1,
],
'api' => [
-   'db1059' => 3,
-   'db1068' => 1,
+   'db1059' => 1,
+   'db1068' => 3,
],
'watchlist' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib5449885c776c4c23b32afd33dba0645a80f9e3d
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1064

2017-02-03 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335774 )

Change subject: db-eqiad.php: Depool db1064
..

db-eqiad.php: Depool db1064

db1064 needs to get restarted to get its binary logs changed to ROW.
Pool db1068 in vslow temporarily

Bug: T153743
Change-Id: Iff845b32f13386281cbda847a8c6d2b48645ba98
---
M wmf-config/db-eqiad.php
1 file changed, 6 insertions(+), 6 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a7503bb..f574156 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -132,8 +132,8 @@
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1059' => 1,   # C2 2.8TB  96GB, api
-   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
-   'db1068' => 1,   # D1 2.8TB 160GB, api
+#  'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
+   'db1068' => 1,   # D1 2.8TB 160GB, api, vslow, dump #temporary 
vslow T153743
'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
@@ -321,14 +321,14 @@
],
's4' => [
'vslow' => [
-   'db1064' => 1,
+   'db1068' => 1,
],
'dump' => [
-   'db1064' => 1,
+   'db1068' => 1,
],
'api' => [
-   'db1059' => 1,
-   'db1068' => 3,
+   'db1059' => 3,
+   'db1068' => 1,
],
'watchlist' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iff845b32f13386281cbda847a8c6d2b48645ba98
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Add gtid_domain_id to s4

2017-02-03 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335816 )

Change subject: mariadb: Add gtid_domain_id to s4
..

mariadb: Add gtid_domain_id to s4

Enable gtid_domain_id on s4 shard (commons).
It has been running for for weeks on the misc shards so it is time to
slowly deploy it on production shards.

Bug: T149418
Change-Id: Ica9ed7a8d1f68e385539587c245f7567b65ba25f
---
M templates/mariadb/default.my.cnf.erb
1 file changed, 9 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/16/335816/1

diff --git a/templates/mariadb/default.my.cnf.erb 
b/templates/mariadb/default.my.cnf.erb
index 612ffb0..e804315 100644
--- a/templates/mariadb/default.my.cnf.erb
+++ b/templates/mariadb/default.my.cnf.erb
@@ -22,6 +22,15 @@
 server_id = <%= @server_id %>
 read_only = 0
 
+<% if @shard == 's4' -%>
+# gtid_domain_id flag is needed for multisource replication and GTID.
+# Strictly it is only needed on masters or servers that can potentially be
+# masters but for consistency it should be set in all of them.
+# https://mariadb.com/kb/en/mariadb/gtid/
+
+gtid_domain_id  = <%= @gtid_domain_id %>
+<% end -%>
+
 secure_file_priv   = /dev/null
 max_allowed_packet = 16M
 sync_binlog= 1

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ica9ed7a8d1f68e385539587c245f7567b65ba25f
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Use the common gtid_domain_id

2017-02-03 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335817 )

Change subject: mariadb: Use the common gtid_domain_id
..

mariadb: Use the common gtid_domain_id

The labsdb hosts were still using the old way of generating
gtid_domain_id flag, which we changed. So for consistency just updating
the file to use the new one. This will not change the current value of
gtid_domain_id.
This is related to: https://gerrit.wikimedia.org/r/#/c/326086/

Bug: T149418
Change-Id: I721f29f0a10bd075423ea26094955b9f617b6d17
---
M templates/mariadb/labsdb-replica.my.cnf.erb
1 file changed, 7 insertions(+), 2 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/17/335817/1

diff --git a/templates/mariadb/labsdb-replica.my.cnf.erb 
b/templates/mariadb/labsdb-replica.my.cnf.erb
index 21a44b3..63c744e 100644
--- a/templates/mariadb/labsdb-replica.my.cnf.erb
+++ b/templates/mariadb/labsdb-replica.my.cnf.erb
@@ -25,11 +25,16 @@
 port   = 3306
 datadir= <%= @datadir %>
 tmpdir = <%= @tmpdir %>
-# needed for multisource replication + GTID.
-gtid_domain_id = <%= @server_id %>
 server_id  = <%= @server_id %>
 read_only  = 0
 
+# gtid_domain_id flag is needed for multisource replication and GTID.
+# Strictly it is only needed on masters or servers that can potentially be
+# masters but for consistency it should be set in all of them.
+# https://mariadb.com/kb/en/mariadb/gtid/
+
+gtid_domain_id  = <%= @gtid_domain_id %>
+
 # enable socket authentication
 plugin-load = unix_socket=auth_socket.so
 

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I721f29f0a10bd075423ea26094955b9f617b6d17
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: eventlogging: Enable gtid_domainid on eventlogging

2017-01-22 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/332965 )

Change subject: eventlogging: Enable gtid_domainid on eventlogging
..


eventlogging: Enable gtid_domainid on eventlogging

After enabling gtid_domain_id on all the misc shards that have
replication. I want to enable it on the eventlogging host.
There is no replication chain there, but for consistency and just in
case we add slaves in the future.

Bug: T149418
Change-Id: I20ec0b2dc2d136d2fc0d93c811aaca9da7b0443c
---
M templates/mariadb/eventlogging.my.cnf.erb
1 file changed, 8 insertions(+), 0 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/templates/mariadb/eventlogging.my.cnf.erb 
b/templates/mariadb/eventlogging.my.cnf.erb
index bfe5800..0ccff98 100644
--- a/templates/mariadb/eventlogging.my.cnf.erb
+++ b/templates/mariadb/eventlogging.my.cnf.erb
@@ -28,6 +28,14 @@
 datadir= <%= @datadir %>
 tmpdir = <%= @tmpdir %>
 server_id  = <%= @server_id %>
+
+# gtid_domain_id flag is needed for multisource replication and GTID.
+# Strictly it is only needed on masters or servers that can potentially be
+# masters but for consistency it should be set in all of them.
+# https://mariadb.com/kb/en/mariadb/gtid/
+
+gtid_domain_id  = <%= @gtid_domain_id %>
+
 <% if @sql_mode != '' -%>
 sql-mode   = <%= @sql_mode %>
 <% end -%>

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I20ec0b2dc2d136d2fc0d93c811aaca9da7b0443c
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/software[master]: x1.hosts: Remove old hosts

2017-01-23 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333662 )

Change subject: x1.hosts: Remove old hosts
..

x1.hosts: Remove old hosts

Looks like db2008 and db2009 are no longer valid hosts as per tendril or
a ping.

Change-Id: I4f35db52776e106f10a6188ba939d963b5f430aa
---
M dbtools/x1.hosts
1 file changed, 0 insertions(+), 2 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/62/333662/1

diff --git a/dbtools/x1.hosts b/dbtools/x1.hosts
index 23b0984..3a1a113 100644
--- a/dbtools/x1.hosts
+++ b/dbtools/x1.hosts
@@ -1,7 +1,5 @@
 dbstore2001.codfw.wmnet 3306
 dbstore2002.codfw.wmnet 3306
-db2008.codfw.wmnet  3306
-db2009.codfw.wmnet  3306
 db2033.codfw.wmnet  3306
 dbstore1001.eqiad.wmnet 3306
 dbstore1002.eqiad.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4f35db52776e106f10a6188ba939d963b5f430aa
Gerrit-PatchSet: 1
Gerrit-Project: operations/software
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: Revert "site.pp: Enable RBR on db1072"

2017-01-24 Thread Marostegui (Code Review) 
Hello jenkins-bot, Jcrespo,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "site.pp: Enable RBR on db1072"
..

Revert "site.pp: Enable RBR on db1072"

This host isn't useful as db1095's master

This reverts commit dc1e332e22e1dab9c95d61c6e83a919f2a25a8aa.

Change-Id: I7f177202c20ebd07eb60bde4b790120a5191a862
---
M manifests/site.pp
1 file changed, 1 insertion(+), 9 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/48/333948/1

diff --git a/manifests/site.pp b/manifests/site.pp
index f1e042b..ec256bb 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -428,7 +428,7 @@
 }
 }
 
-node /^db10(51|55|65|66|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|65|66|72|73|80|83|89)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's1',
 }
@@ -436,14 +436,6 @@
 
 # Testing row-based replication to sanitarium2 (T150960)
 node 'db1052.eqiad.wmnet' {
-class { '::role::mariadb::core':
-shard => 's1',
-binlog_format => 'ROW',
-}
-}
-
-# Future new master for sanitarium2
-node 'db1072.eqiad.wmnet' {
 class { '::role::mariadb::core':
 shard => 's1',
 binlog_format => 'ROW',

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I7f177202c20ebd07eb60bde4b790120a5191a862
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1072

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333927 )

Change subject: db-eqiad.php: Depool db1072
..

db-eqiad.php: Depool db1072

db1072 needs its replication stopped in order to get db1095 repointed to
it.
Pooling it db1080 in vslow in the meanwhile. Also decreased weight for
db1080 while it servers vslow

Bug: T156006
Change-Id: I2dce2e3814d3ecfdcc3e35f28de61aed10f6c23f
---
M wmf-config/db-eqiad.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 447772b..8b50b8a 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,9 +99,9 @@
'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
'db1065' => 50,  # 2.8TB 160GB, api #D1
'db1066' => 50,  # 2.8TB 160GB, api #D1
-   'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1
+#  'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1 #T156006
'db1073' => 50,  # 2.8TB 160GB, api #D1
-   'db1080' => 500, # 3.6TB 512GB #A2
+   'db1080' => 100, # 3.6TB 512GB #A2
'db1083' => 500, # 3.6TB 512GB #B1
'db1089' => 500, # 3.6TB 512GB #C3
],
@@ -258,10 +258,10 @@
'db1055' => 2,
],
'dump' => [
-   'db1072' => 1,
+   'db1080' => 1,
],
'vslow' => [
-   'db1072' => 1,
+   'db1080' => 1,
],
'api' => [
'db1065' => 5,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2dce2e3814d3ecfdcc3e35f28de61aed10f6c23f
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Enable RBR on db1072

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/333926 )

Change subject: site.pp: Enable RBR on db1072
..


site.pp: Enable RBR on db1072

db1072 is going to be db1095 new master and needs ROW based replication
binlog format

Bug: T156006
Change-Id: I20fd887d53e0aa5e48ad4cde44e1f0ca92eef60b
---
M manifests/site.pp
1 file changed, 9 insertions(+), 1 deletion(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/manifests/site.pp b/manifests/site.pp
index ec256bb..f1e042b 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -428,7 +428,7 @@
 }
 }
 
-node /^db10(51|55|65|66|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|65|66|73|80|83|89)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's1',
 }
@@ -442,6 +442,14 @@
 }
 }
 
+# Future new master for sanitarium2
+node 'db1072.eqiad.wmnet' {
+class { '::role::mariadb::core':
+shard => 's1',
+binlog_format => 'ROW',
+}
+}
+
 # s1 (enwiki) core production dbs on codfw
 # codfw master
 node 'db2016.codfw.wmnet' {

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I20fd887d53e0aa5e48ad4cde44e1f0ca92eef60b
Gerrit-PatchSet: 3
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1073"

2017-01-24 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1073"
..

Revert "db-eqiad.php: Depool db1073"

This reverts commit fc672859deb638cdc5ef0377c8a9b358db263313.

Change-Id: Ia06171fed65f65d87afc8436ef4549ef3bf9f739
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 4e5a9d6..447772b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -100,7 +100,7 @@
'db1065' => 50,  # 2.8TB 160GB, api #D1
'db1066' => 50,  # 2.8TB 160GB, api #D1
'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1
-#  'db1073' => 50,  # 2.8TB 160GB, api #D1 #T155999
+   'db1073' => 50,  # 2.8TB 160GB, api #D1
'db1080' => 500, # 3.6TB 512GB #A2
'db1083' => 500, # 3.6TB 512GB #B1
'db1089' => 500, # 3.6TB 512GB #C3
@@ -266,7 +266,7 @@
'api' => [
'db1065' => 5,
'db1066' => 5,
-#  'db1073' => 5,
+   'db1073' => 5,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia06171fed65f65d87afc8436ef4549ef3bf9f739
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Enable RBR on db1072

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333926 )

Change subject: site.pp: Enable RBR on db1072
..

site.pp: Enable RBR on db1072

db1072 is going to be db1095 new master and needs ROW based replication
binlog format

Bug: T156006
Change-Id: I20fd887d53e0aa5e48ad4cde44e1f0ca92eef60b
---
M manifests/site.pp
1 file changed, 9 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/26/333926/1

diff --git a/manifests/site.pp b/manifests/site.pp
index ec256bb..546afa3 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -428,7 +428,7 @@
 }
 }
 
-node /^db10(51|55|65|66|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|65|66|72|80|83|89)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's1',
 }
@@ -442,6 +442,14 @@
 }
 }
 
+# Future new master for sanitarium2
+node 'db1073.eqiad.wmnet' {
+class { '::role::mariadb::core':
+shard => 's1',
+binlog_format => 'ROW',
+}
+}
+
 # s1 (enwiki) core production dbs on codfw
 # codfw master
 node 'db2016.codfw.wmnet' {

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I20fd887d53e0aa5e48ad4cde44e1f0ca92eef60b
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1072"

2017-01-24 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1072"
..

Revert "db-eqiad.php: Depool db1072"

This reverts commit c7d0cf6381e94a04ba9175931523817cea1a8fc6.

Change-Id: Ie7cd3e14cc98612d00f8fd4eb9a66ea60422517d
---
M wmf-config/db-eqiad.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8b50b8a..447772b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,9 +99,9 @@
'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
'db1065' => 50,  # 2.8TB 160GB, api #D1
'db1066' => 50,  # 2.8TB 160GB, api #D1
-#  'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1 #T156006
+   'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1
'db1073' => 50,  # 2.8TB 160GB, api #D1
-   'db1080' => 100, # 3.6TB 512GB #A2
+   'db1080' => 500, # 3.6TB 512GB #A2
'db1083' => 500, # 3.6TB 512GB #B1
'db1089' => 500, # 3.6TB 512GB #C3
],
@@ -258,10 +258,10 @@
'db1055' => 2,
],
'dump' => [
-   'db1080' => 1,
+   'db1072' => 1,
],
'vslow' => [
-   'db1080' => 1,
+   'db1072' => 1,
],
'api' => [
'db1065' => 5,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie7cd3e14cc98612d00f8fd4eb9a66ea60422517d
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1065

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333950 )

Change subject: db-eqiad.php: Depool db1065
..

db-eqiad.php: Depool db1065

db1065 needs to get restarted to get ROW based replication

Change-Id: Idccf9b9244e90b24946529db24c8637a77c25aba
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8b50b8a..5891e9c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -97,7 +97,7 @@
 #  'db1052' => 1,   # 2.8TB  96GB, old master #Temporary master 
for db1095 - new sanitarium #T150960 #B3
'db1051' => 1,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #B3
'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
-   'db1065' => 50,  # 2.8TB 160GB, api #D1
+#  'db1065' => 50,  # 2.8TB 160GB, api #D1 #Maintenance T156006
'db1066' => 50,  # 2.8TB 160GB, api #D1
 #  'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1 #T156006
'db1073' => 50,  # 2.8TB 160GB, api #D1
@@ -264,7 +264,7 @@
'db1080' => 1,
],
'api' => [
-   'db1065' => 5,
+#  'db1065' => 5,
'db1066' => 5,
'db1073' => 5,
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idccf9b9244e90b24946529db24c8637a77c25aba
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Disable RBR on db1052

2017-01-23 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333850 )

Change subject: site.pp: Disable RBR on db1052
..

site.pp: Disable RBR on db1052

db1052 will be the new s1 master. It is currently the master for db1095
(new sanitarium) and it is running RBR. It needs to go back to SBR.

Bug: T156006
Change-Id: I7f84cba6a556f3182723d3ca7b9bef9e3a0e237c
---
M manifests/site.pp
1 file changed, 1 insertion(+), 9 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/50/333850/1

diff --git a/manifests/site.pp b/manifests/site.pp
index 8b1f5a0..4839311 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -428,17 +428,9 @@
 }
 }
 
-node /^db10(51|55|65|66|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|52|55|65|66|72|73|80|83|89)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's1',
-}
-}
-
-# Testing row-based replication to sanitarium2 (T150960)
-node 'db1052.eqiad.wmnet' {
-class { '::role::mariadb::core':
-shard => 's1',
-binlog_format => 'ROW',
 }
 }
 

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I7f84cba6a556f3182723d3ca7b9bef9e3a0e237c
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: Revert "site.pp: db1052's binlog changed to ROW"

2017-01-23 Thread Marostegui (Code Review) 
Hello jenkins-bot, Jcrespo, Volans,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "site.pp: db1052's binlog changed to ROW"
..

Revert "site.pp: db1052's binlog changed to ROW"

In preparations for the DB switchover, db1052 needs to go back to SBR (T156006)


This reverts commit 83dbd721b243cd48197af3d7432ac3f28d49610a.

Change-Id: I0d3a339b3c3e6c9cfd1bc0d71babf0f7cc0340e3
---
M manifests/site.pp
1 file changed, 1 insertion(+), 9 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/49/333849/1

diff --git a/manifests/site.pp b/manifests/site.pp
index a8ceef7..09784ee 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -429,17 +429,9 @@
 }
 }
 
-node /^db10(51|55|65|66|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|52|55|65|66|72|73|80|83|89)\.eqiad\.wmnet/ {
 class { 'role::mariadb::core':
 shard => 's1',
-}
-}
-
-# Testing row-based replication to sanitarium2 (T150960)
-node 'db1052.eqiad.wmnet' {
-class { 'role::mariadb::core':
-shard => 's1',
-binlog_format => 'ROW',
 }
 }
 

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0d3a339b3c3e6c9cfd1bc0d71babf0f7cc0340e3
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Volans 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Add rack positions for s1

2017-01-23 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333851 )

Change subject: db-codfw,db-eqiad.php: Add rack positions for s1
..

db-codfw,db-eqiad.php: Add rack positions for s1

It is easier and faster to see in which rack each server is here
than opening racktables, specially for emergencies.
So far only done for s1

Bug: T155999
Change-Id: If623a38ef2f4a8e018fd461fb4681e92b068005b
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 19 insertions(+), 19 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index a4f47f4..af03cbe 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -93,14 +93,14 @@
 
 'sectionLoads' => [
's1' => [
-   'db2016' => 0,   # 2.9TB  96GB, master
-   'db2034' => 50,  # 2.9TB 160GB, rc, log
-   'db2042' => 50,  # 2.9TB 160GB, rc, log
-   'db2048' => 400, # 2.9TB 160GB
-   'db2055' => 50,  # 3.3TB 160GB, dump (inactive), vslow
-   'db2062' => 100, # 3.3TB 160GB, api
-   'db2069' => 100, # 3.3TB 160GB, api
-   'db2070' => 400, # 3.3TB 160GB
+   'db2016' => 0,   # 2.9TB  96GB, master #B6
+   'db2034' => 50,  # 2.9TB 160GB, rc, log #C6
+   'db2042' => 50,  # 2.9TB 160GB, rc, log #C6
+   'db2048' => 400, # 2.9TB 160GB #C6
+   'db2055' => 50,  # 3.3TB 160GB, dump (inactive), vslow #D6
+   'db2062' => 100, # 3.3TB 160GB, api #D6
+   'db2069' => 100, # 3.3TB 160GB, api #D6
+   'db2070' => 400, # 3.3TB 160GB #D6
],
's2' => [
'db2017' => 0,   # 2.9TB  96GB, master
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 04f6957..1f84df6 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -93,17 +93,17 @@
 
 'sectionLoads' => [
's1' => [
-   'db1057' => 0,   # 2.8TB  96GB, master
-#  'db1052' => 1,   # 2.8TB  96GB, old master #Temporary master 
for db1095 - new sanitarium #T150960
-   'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-   'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-   'db1065' => 1,   # 2.8TB 160GB, api, low weight after 
maintenance
-   'db1066' => 50,  # 2.8TB 160GB, api
-   'db1072' => 0,   # 2.8TB 160GB, vslow, dump
-   'db1073' => 50,  # 2.8TB 160GB, api
-   'db1080' => 500, # 3.6TB 512GB
-   'db1083' => 500, # 3.6TB 512GB
-   'db1089' => 500, # 3.6TB 512GB
+   'db1057' => 0,   # 2.8TB  96GB, master #C2
+#  'db1052' => 1,   # 2.8TB  96GB, old master #Temporary master 
for db1095 - new sanitarium #T150960 #C2
+   'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
+   'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
+   'db1065' => 1,   # 2.8TB 160GB, api, low weight after 
maintenance #D1
+   'db1066' => 50,  # 2.8TB 160GB, api #D1
+   'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1
+   'db1073' => 50,  # 2.8TB 160GB, api #D1
+   'db1080' => 500, # 3.6TB 512GB #A2
+   'db1083' => 500, # 3.6TB 512GB #B1
+   'db1089' => 500, # 3.6TB 512GB #C3
],
's2' => [
'db1018' => 0,   # 1.4TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If623a38ef2f4a8e018fd461fb4681e92b068005b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Restore original weight

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333856 )

Change subject: db-eqiad.php: Restore original weight
..

db-eqiad.php: Restore original weight

db1065 was out for maintenance and was pooled in yesterday night with
less weight than the original in order to warm it up.
According to the graphs and logs, the pool size is already loaded.

Bug: T156005
Change-Id: I6c921409fd11c2678efb67198971be982589a7a0
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 1f84df6..0bfdb11 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -97,7 +97,7 @@
 #  'db1052' => 1,   # 2.8TB  96GB, old master #Temporary master 
for db1095 - new sanitarium #T150960 #C2
'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
-   'db1065' => 1,   # 2.8TB 160GB, api, low weight after 
maintenance #D1
+   'db1065' => 50,  # 2.8TB 160GB, api #D1
'db1066' => 50,  # 2.8TB 160GB, api #D1
'db1072' => 0,   # 2.8TB 160GB, vslow, dump #D1
'db1073' => 50,  # 2.8TB 160GB, api #D1
@@ -264,7 +264,7 @@
'db1072' => 1,
],
'api' => [
-   'db1065' => 1, # low weight after maintenance
+   'db1065' => 5,
'db1066' => 5,
'db1073' => 5,
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6c921409fd11c2678efb67198971be982589a7a0
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php Depool db2054

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333859 )

Change subject: db-codfw.php Depool db2054
..

db-codfw.php Depool db2054

db2054 needs an ALTER table

Bug: T153300
Change-Id: I760d168d088bfcafe7f1bebfd92c0df6fdc5d26b
---
M wmf-config/db-codfw.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index af03cbe..946849c 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -146,9 +146,9 @@
'db2029' => 0,   # 2.9TB  96GB, master
'db2040' => 200, # 2.9TB 160GB, rc, log
'db2047' => 400, # 2.9TB 160GB
-   'db2054' => 200, # 2.9TB 160GB, dump (inactive), vslow
+#  'db2054' => 200, # 2.9TB 160GB, dump (inactive), vslow
'db2061' => 200, # 3.3TB 160GB, api
-   'db2068' => 300, # 3.3TB 160GB
+   'db2068' => 200, # 3.3TB 160GB #temporarily vslow,dump #T153300
],
'silver' => [
'silver' => 100,   # I have no idea if this is right
@@ -401,10 +401,10 @@
'db2040' => 1,
],
'dump' => [
-   'db2054' => 1,
+   'db2068' => 1,
],
'vslow' => [
-   'db2054' => 1,
+   'db2068' => 1,
],
'api' => [
'db2061' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I760d168d088bfcafe7f1bebfd92c0df6fdc5d26b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Split dbstore role classes

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/332228 )

Change subject: mariadb: Split dbstore role classes
..


mariadb: Split dbstore role classes

* Split the dbstore class out from mariadb.pp into two differnt files

* dbstore.pp will be used for the original dbstore hosts that still
run TokuDB as an engine.

* dbstore2.pp will be used for the new dbstore servers that no longer
use TokuDB as an engine but use InnoDB.

* dbstore2.my.cnf.erb: Enabled gtid_domain_id flag. Currently this only
applies to dbstore2001 and dbstore2002 which already have it enabled
manually

Bug: T130128
Bug: T150850
Bug: T149418
Change-Id: I2e87640257fc58ec16a02c825927129cfd4520eb
---
M manifests/site.pp
M modules/role/manifests/mariadb.pp
A modules/role/manifests/mariadb/dbstore.pp
A modules/role/manifests/mariadb/dbstore2.pp
A templates/mariadb/dbstore2.my.cnf.erb
5 files changed, 267 insertions(+), 50 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/manifests/site.pp b/manifests/site.pp
index 8b1f5a0..ec256bb 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -828,7 +828,7 @@
 
 node 'dbstore2001.codfw.wmnet' {
 # 24h delay on all repl streams
-class { '::role::mariadb::dbstore':
+class { 'role::mariadb::dbstore2':
 lag_warn => 9,
 lag_crit => 18,
 # Delayed slaves legitimately and cleanly (errno = 0) stop the SQL 
thread, so
diff --git a/modules/role/manifests/mariadb.pp 
b/modules/role/manifests/mariadb.pp
index 1374d56..3d37c0f 100644
--- a/modules/role/manifests/mariadb.pp
+++ b/modules/role/manifests/mariadb.pp
@@ -479,55 +479,6 @@
 }
 }
 
-# MariaDB 10 slaves replicating all shards
-class role::mariadb::dbstore(
-$lag_warn = 300,
-$lag_crit = 600,
-$warn_stopped = true,
-) {
-
-system::role { 'role::mariadb::dbstore':
-description => 'Delayed Slave',
-}
-
-include mariadb::packages_wmf
-include mariadb::service
-
-include standard
-include passwords::misc::scripts
-
-class { 'role::mariadb::grants::production':
-password => $passwords::misc::scripts::mysql_root_pass,
-prompt   => 'DBSTORE',
-}
-
-include role::mariadb::monitor::dba
-include passwords::misc::scripts
-include role::mariadb::ferm
-
-class {'role::mariadb::groups':
-mysql_group => 'dbstore',
-mysql_role  => 'slave',
-}
-
-class { 'mariadb::config':
-config  => 'mariadb/dbstore.my.cnf.erb',
-datadir => '/srv/sqldata',
-tmpdir  => '/srv/tmp',
-ssl => 'puppet-cert',
-p_s => 'off',
-}
-
-mariadb::monitor_replication {
-['s1','s2','s3','s4','s5','s6','s7','m2','m3','x1']:
-is_critical   => false,
-contact_group => 'admins', # only show on nagios/irc
-lag_warn  => $lag_warn,
-lag_crit  => $lag_crit,
-warn_stopped  => $warn_stopped,
-}
-}
-
 # MariaDB 10 Analytics all-shards slave, with scratch space and TokuDB
 # analytics slaves are already either dbstores or eventlogging slaves
 # so they just need the extra core monitoring
diff --git a/modules/role/manifests/mariadb/dbstore.pp 
b/modules/role/manifests/mariadb/dbstore.pp
new file mode 100644
index 000..5ef0594
--- /dev/null
+++ b/modules/role/manifests/mariadb/dbstore.pp
@@ -0,0 +1,48 @@
+# MariaDB 10 slaves replicating all shards and running TokuDB
+class role::mariadb::dbstore(
+$lag_warn = 300,
+$lag_crit = 600,
+$warn_stopped = true,
+) {
+
+system::role { 'role::mariadb::dbstore':
+description => 'Delayed Slave',
+}
+
+include mariadb::packages_wmf
+include mariadb::service
+
+include standard
+include passwords::misc::scripts
+
+class { 'role::mariadb::grants::production':
+password => $passwords::misc::scripts::mysql_root_pass,
+prompt   => 'DBSTORE',
+}
+
+include role::mariadb::monitor::dba
+include passwords::misc::scripts
+include role::mariadb::ferm
+
+class {'role::mariadb::groups':
+mysql_group => 'dbstore',
+mysql_role  => 'slave',
+}
+
+class { 'mariadb::config':
+config  => 'mariadb/dbstore.my.cnf.erb',
+datadir => '/srv/sqldata',
+tmpdir  => '/srv/tmp',
+ssl => 'puppet-cert',
+p_s => 'off',
+}
+
+mariadb::monitor_replication {
+['s1','s2','s3','s4','s5','s6','s7','m2','m3','x1']:
+is_critical   => false,
+contact_group => 'admins', # only show on nagios/irc
+lag_warn  => $lag_warn,
+lag_crit  => $lag_crit,
+warn_stopped  => $warn_stopped,
+}
+}
diff --git a/modules/role/manifests/mariadb/dbstore2.pp 
b/modules/role/manifests/mariadb/dbstore2.pp
new file mode 100644
index 000..c6bdbda
--- /dev/null
+++

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1051

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333873 )

Change subject: db-eqiad.php: Depool db1051
..

db-eqiad.php: Depool db1051

db1051 needs to be moved to another row (B3) so depool it.
Update the row it will be in after the move.

Bug: T156004
Change-Id: Iabc29427c533143009ddc58339d3d9ec3035423f
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0bfdb11..4d163c2 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -95,7 +95,7 @@
's1' => [
'db1057' => 0,   # 2.8TB  96GB, master #C2
 #  'db1052' => 1,   # 2.8TB  96GB, old master #Temporary master 
for db1095 - new sanitarium #T150960 #C2
-   'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
+#  'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #B3 #Maintenance - T156004
'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
'db1065' => 50,  # 2.8TB 160GB, api #D1
'db1066' => 50,  # 2.8TB 160GB, api #D1
@@ -238,7 +238,7 @@
 'groupLoadsBySection' => [
's1' => [
'watchlist' => [
-   'db1051' => 1,
+#  'db1051' => 1,
'db1055' => 1,
],
'recentchanges' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iabc29427c533143009ddc58339d3d9ec3035423f
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1051

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333898 )

Change subject: db-eqiad.php: Depool db1051
..

db-eqiad.php: Depool db1051

For maintenance

Bug: T156004
Change-Id: Ie346ccca0522e41170be6e669522fe123756694a
---
M wmf-config/db-eqiad.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 4d163c2..1219875 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -242,19 +242,19 @@
'db1055' => 1,
],
'recentchanges' => [
-   'db1051' => 1,
+#  'db1051' => 1,
'db1055' => 1,
],
'recentchangeslinked' => [
-   'db1051' => 1,
+#  'db1051' => 1,
'db1055' => 1,
],
'contributions' => [
-   'db1051' => 1,
+#  'db1051' => 1,
'db1055' => 1,
],
'logpager' => [
-   'db1051' => 1,
+#  'db1051' => 1,
'db1055' => 1,
],
'dump' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie346ccca0522e41170be6e669522fe123756694a
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Update db1051 IP

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/333900 )

Change subject: db-codfw,db-eqiad.php: Update db1051 IP
..

db-codfw,db-eqiad.php: Update db1051 IP

db1051 has been moved to a different rack and thus gets a new IP:
10.64.16.76

Bug: T156004
Change-Id: Ie8bfd3fa4aa5c6d77277780dc7ec4fd78f0f87f5
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 946849c..a9032cc 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -447,7 +447,7 @@
'db1047' => '10.64.16.36', # do not remove or comment out
'db1049' => '10.64.16.144', # do not remove or comment out
'db1050' => '10.64.16.145', # do not remove or comment out
-   'db1051' => '10.64.32.21', # do not remove or comment out
+   'db1051' => '10.64.16.76', # do not remove or comment out
'db1052' => '10.64.32.22', # do not remove or comment out
'db1053' => '10.64.0.87', # do not remove or comment out
'db1054' => '10.64.32.24', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 1219875..b21796c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -474,7 +474,7 @@
'db1047' => '10.64.16.36', # do not remove or comment out
'db1049' => '10.64.16.144', # do not remove or comment out
'db1050' => '10.64.16.145', # do not remove or comment out
-   'db1051' => '10.64.32.21', # do not remove or comment out
+   'db1051' => '10.64.16.76', # do not remove or comment out
'db1052' => '10.64.32.22', # do not remove or comment out
'db1053' => '10.64.0.87', # do not remove or comment out
'db1054' => '10.64.32.24', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie8bfd3fa4aa5c6d77277780dc7ec4fd78f0f87f5
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1051

2017-01-24 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/333873 )

Change subject: db-eqiad.php: Depool db1051
..


db-eqiad.php: Depool db1051

db1051 needs to be moved to another row (B3) so depool it.
Update the row it will be in after the move.

Bug: T156004
Change-Id: Iabc29427c533143009ddc58339d3d9ec3035423f
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0bfdb11..4d163c2 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -95,7 +95,7 @@
's1' => [
'db1057' => 0,   # 2.8TB  96GB, master #C2
 #  'db1052' => 1,   # 2.8TB  96GB, old master #Temporary master 
for db1095 - new sanitarium #T150960 #C2
-   'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
+#  'db1051' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #B3 #Maintenance - T156004
'db1055' => 50,  # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #C2
'db1065' => 50,  # 2.8TB 160GB, api #D1
'db1066' => 50,  # 2.8TB 160GB, api #D1
@@ -238,7 +238,7 @@
 'groupLoadsBySection' => [
's1' => [
'watchlist' => [
-   'db1051' => 1,
+#  'db1051' => 1,
'db1055' => 1,
],
'recentchanges' => [

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Iabc29427c533143009ddc58339d3d9ec3035423f
Gerrit-PatchSet: 2
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Change active master for enwiki

2017-01-25 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334030 )

Change subject: site.pp: Change active master for enwiki
..

site.pp: Change active master for enwiki

This changes the active enwiki master from db1057 to db1052

Bug: T156008
Change-Id: I4dd099044ba2b82cece6691273688e618c7336d8
---
M manifests/site.pp
1 file changed, 3 insertions(+), 3 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/30/334030/1

diff --git a/manifests/site.pp b/manifests/site.pp
index 1ad61b9..809d969 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -411,15 +411,15 @@
 
 # s1 (enwiki) core production dbs on eqiad
 # eqiad master
-node 'db1057.eqiad.wmnet' {
+node 'db1052.eqiad.wmnet' {
 class { '::role::mariadb::core':
 shard => 's1',
 master=> true,
 binlog_format => 'STATEMENT',
 }
 }
-# soon-to-be master
-node 'db1052.eqiad.wmnet' {
+# old master
+node 'db1057.eqiad.wmnet' {
 class { '::role::mariadb::core':
 shard => 's1',
 master=> false,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4dd099044ba2b82cece6691273688e618c7336d8
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-codfw.php Depool db2054"

2017-01-24 Thread Marostegui (Code Review) 
Hello jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-codfw.php Depool db2054"
..

Revert "db-codfw.php Depool db2054"

ALTER table finished

This reverts commit 621662d2bb1b4edc390a8407c1c5692a0df7071b.

Change-Id: I53908cd6a2d9fa62c4e7e42723f68bfe7c0878c8
---
M wmf-config/db-codfw.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 946849c..af03cbe 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -146,9 +146,9 @@
'db2029' => 0,   # 2.9TB  96GB, master
'db2040' => 200, # 2.9TB 160GB, rc, log
'db2047' => 400, # 2.9TB 160GB
-#  'db2054' => 200, # 2.9TB 160GB, dump (inactive), vslow
+   'db2054' => 200, # 2.9TB 160GB, dump (inactive), vslow
'db2061' => 200, # 3.3TB 160GB, api
-   'db2068' => 200, # 3.3TB 160GB #temporarily vslow,dump #T153300
+   'db2068' => 300, # 3.3TB 160GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right
@@ -401,10 +401,10 @@
'db2040' => 1,
],
'dump' => [
-   'db2068' => 1,
+   'db2054' => 1,
],
'vslow' => [
-   'db2068' => 1,
+   'db2054' => 1,
],
'api' => [
'db2061' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I53908cd6a2d9fa62c4e7e42723f68bfe7c0878c8
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-codfw.php Depool db2054"

2017-01-25 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/334029 )

Change subject: Revert "db-codfw.php Depool db2054"
..


Revert "db-codfw.php Depool db2054"

ALTER table finished

This reverts commit 621662d2bb1b4edc390a8407c1c5692a0df7071b.

Change-Id: I53908cd6a2d9fa62c4e7e42723f68bfe7c0878c8
---
M wmf-config/db-codfw.php
1 file changed, 4 insertions(+), 4 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index bc8577d..c907dc8 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -146,9 +146,9 @@
'db2029' => 0,   # 2.9TB  96GB, master
'db2040' => 200, # 2.9TB 160GB, rc, log
'db2047' => 400, # 2.9TB 160GB
-#  'db2054' => 200, # 2.9TB 160GB, dump (inactive), vslow
+   'db2054' => 200, # 2.9TB 160GB, dump (inactive), vslow
'db2061' => 200, # 3.3TB 160GB, api
-   'db2068' => 200, # 3.3TB 160GB #temporarily vslow,dump #T153300
+   'db2068' => 300, # 3.3TB 160GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right
@@ -401,10 +401,10 @@
'db2040' => 1,
],
'dump' => [
-   'db2068' => 1,
+   'db2054' => 1,
],
'vslow' => [
-   'db2068' => 1,
+   'db2054' => 1,
],
'api' => [
'db2061' => 1,

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I53908cd6a2d9fa62c4e7e42723f68bfe7c0878c8
Gerrit-PatchSet: 2
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Restore db1073 original weight

2017-01-30 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335023 )

Change subject: db-eqiad.php: Restore db1073 original weight
..

db-eqiad.php: Restore db1073 original weight

db1073 is now ready to start serving traffic with its normal weight

Bug: T156226
Change-Id: I06ca76166afdacd472396da803474539d4a85af0
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5946066..eaa714d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -100,8 +100,8 @@
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
 #  'db1072' => 10,  # B2 2.8TB 160GB, api #T156226
-   'db1073' => 10,  # D1 2.8TB 160GB, api
-   'db1080' => 100, # A2 3.6TB 512GB, api #temporarily api #T156226
+   'db1073' => 50,  # D1 2.8TB 160GB, api
+   'db1080' => 500, # A2 3.6TB 512GB, api
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
@@ -264,10 +264,9 @@
'db1065' => 1,
],
'api' => [
-   'db1066' => 2,
+   'db1066' => 1,
 #  'db1072' => 1,
'db1073' => 1,
-   'db1080' => 2,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I06ca76166afdacd472396da803474539d4a85af0
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Repool db1072, db1073 with less load

2017-01-30 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334987 )

Change subject: db-eqiad.php: Repool db1072,db1073 with less load
..

db-eqiad.php: Repool db1072,db1073 with less load

db1072 is back after its recloning.
db1073 was used to reclone db1072.

As both servers were stopped, pool them in with less weight so they can
warm up before going full live.

Bug: T156226
Change-Id: Idcc965727ba0694a5f481182499f8c9c37009942
---
M wmf-config/db-eqiad.php
1 file changed, 7 insertions(+), 5 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c0afe01..0d85000 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,9 +99,9 @@
 #  'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
-#  'db1072' => 0,   # B2 2.8TB 160GB #maintenance T156166
-#  'db1073' => 50,  # D1 2.8TB 160GB, api #T156226 going to 
reclone db1072 from this host
-   'db1080' => 100, # A2 3.6TB 512GB, api #T156226
+   'db1072' => 10,  # B2 2.8TB 160GB, api
+   'db1073' => 10,  # D1 2.8TB 160GB, api
+   'db1080' => 100, # A2 3.6TB 512GB, api #temporarily api #T156226
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
@@ -264,8 +264,10 @@
'db1065' => 1,
],
'api' => [
-   'db1066' => 1,
-   'db1080' => 1,
+   'db1066' => 2,
+   'db1072' => 1,
+   'db1073' => 1,
+   'db1080' => 2,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idcc965727ba0694a5f481182499f8c9c37009942
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Depool db2034

2017-01-30 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335048 )

Change subject: db-codfw.php: Depool db2034
..

db-codfw.php: Depool db2034

db2034 is going to be moved to another rack

Bug: T156478
Change-Id: I62204a97aeb321241cfba68ab3a66d14c28edee4
---
M wmf-config/db-codfw.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 0ac95cf..416bb7d 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -94,7 +94,7 @@
 'sectionLoads' => [
's1' => [
'db2016' => 0,   # B6 2.9TB  96GB, master
-   'db2034' => 50,  # C6 2.9TB 160GB, rc, log
+#  'db2034' => 50,  # C6 2.9TB 160GB, rc, log #T156478
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2048' => 400, # C6 2.9TB 160GB
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
@@ -218,7 +218,7 @@
 'groupLoadsBySection' => [
's1' => [
'watchlist' => [
-   'db2034' => 1,
+#  'db2034' => 1,
'db2042' => 1,
],
'recentchanges' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I62204a97aeb321241cfba68ab3a66d14c28edee4
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Update db2034 IP

2017-01-30 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335053 )

Change subject: db-codfw,db-eqiad.php: Update db2034 IP
..

db-codfw,db-eqiad.php: Update db2034 IP

db2034 is going to be moved to another rack so update its IP

Bug: T156478
Change-Id: I235ffdb9f71c0ea03b11ede72759662f37b176ce
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 6 insertions(+), 6 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 416bb7d..a1e3c82 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -222,19 +222,19 @@
'db2042' => 1,
],
'recentchanges' => [
-   'db2034' => 1,
+#  'db2034' => 1,
'db2042' => 1,
],
'recentchangeslinked' => [
-   'db2034' => 1,
+#  'db2034' => 1,
'db2042' => 1,
],
'contributions' => [
-   'db2034' => 1,
+#  'db2034' => 1,
'db2042' => 1,
],
'logpager' => [
-   'db2034' => 1,
+#  'db2034' => 1,
'db2042' => 1,
],
'dump' => [
@@ -520,7 +520,7 @@
'db2031' => '10.192.16.19', # do not remove or comment out
'db2032' => '10.192.16.20', # do not remove or comment out
'db2033' => '10.192.32.4', # do not remove or comment out
-   'db2034' => '10.192.32.5', # do not remove or comment out
+   'db2034' => '10.192.0.87', # do not remove or comment out
'db2035' => '10.192.32.6', # do not remove or comment out
'db2036' => '10.192.32.7', # do not remove or comment out
'db2037' => '10.192.32.8', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index eaa714d..7c08066 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -547,7 +547,7 @@
'db2031' => '10.192.16.19', # do not remove or comment out
'db2032' => '10.192.16.20', # do not remove or comment out
'db2033' => '10.192.32.4', # do not remove or comment out
-   'db2034' => '10.192.32.5', # do not remove or comment out
+   'db2034' => '10.192.0.87', # do not remove or comment out
'db2035' => '10.192.32.6', # do not remove or comment out
'db2036' => '10.192.32.7', # do not remove or comment out
'db2037' => '10.192.32.8', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I235ffdb9f71c0ea03b11ede72759662f37b176ce
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Repool db2034

2017-01-30 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/335190 )

Change subject: db-codfw.php: Repool db2034
..

db-codfw.php: Repool db2034

db2034 has been moved to another rack. Repool it and change its rack
location

Bug: T156478
Change-Id: I268d63cb3082f0dcdd60967226d82cabb8963724
---
M wmf-config/db-codfw.php
1 file changed, 6 insertions(+), 6 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index a1e3c82..2438b76 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -94,7 +94,7 @@
 'sectionLoads' => [
's1' => [
'db2016' => 0,   # B6 2.9TB  96GB, master
-#  'db2034' => 50,  # C6 2.9TB 160GB, rc, log #T156478
+   'db2034' => 50,  # A5 2.9TB 160GB, rc, log
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2048' => 400, # C6 2.9TB 160GB
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
@@ -218,23 +218,23 @@
 'groupLoadsBySection' => [
's1' => [
'watchlist' => [
-#  'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'recentchanges' => [
-#  'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'recentchangeslinked' => [
-#  'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'contributions' => [
-#  'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'logpager' => [
-#  'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'dump' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I268d63cb3082f0dcdd60967226d82cabb8963724
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1073

2017-01-29 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334973 )

Change subject: db-eqiad.php: Depool db1073
..

db-eqiad.php: Depool db1073

db1073 is going to be used to reclone db1072

Bug: T156226
Change-Id: I80223e60c6dc11784b3a628b50acaf273ddb7299
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 57c27db..c0afe01 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -100,8 +100,8 @@
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
 #  'db1072' => 0,   # B2 2.8TB 160GB #maintenance T156166
-   'db1073' => 50,  # D1 2.8TB 160GB, api
-   'db1080' => 500, # A2 3.6TB 512GB
+#  'db1073' => 50,  # D1 2.8TB 160GB, api #T156226 going to 
reclone db1072 from this host
+   'db1080' => 100, # A2 3.6TB 512GB, api #T156226
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
@@ -265,7 +265,7 @@
],
'api' => [
'db1066' => 1,
-   'db1073' => 1,
+   'db1080' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I80223e60c6dc11784b3a628b50acaf273ddb7299
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1054

2017-01-25 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334106 )

Change subject: db-eqiad.php: Depool db1054
..

db-eqiad.php: Depool db1054

db1054 needs to be moved to another rack.
Pool db1074 temporaliy to help with API traffic.

Bug: T156225
Change-Id: I6c32de83a44deaac153215a3126065091ceead5c
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 151dceb..488d80c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -110,11 +110,11 @@
 #  'db1024' => 0,   # 1.4TB  64GB, old master
'db1021' => 0,   # 1.4TB  64GB, vslow, dump
'db1036' => 1,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1054' => 1,   # 2.8TB  96GB, api
+#  'db1054' => 1,   # 2.8TB  96GB, api #T156225
'db1060' => 1,   # 2.8TB  96GB, api
 #  'db1063' => 0,   # 2.8TB 128GB
 #  'db1067' => 0,   # 2.8TB 160GB
-   'db1074' => 500, # 3.6TB 512GB
+   'db1074' => 200, # 3.6TB 512GB, api #temporarily api T156225
'db1076' => 500, # 3.6TB 512GB
'db1090' => 500, # 3.6TB 512GB
],
@@ -276,7 +276,7 @@
'db1021' => 1,
],
'api' => [
-   'db1054' => 1,
+   'db1074' => 1,
'db1060' => 1,
],
'watchlist' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6c32de83a44deaac153215a3126065091ceead5c
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Change db1054 IP

2017-01-25 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334139 )

Change subject: db-codfw,db-eqiad.php: Change db1054 IP
..

db-codfw,db-eqiad.php: Change db1054 IP

db1054 has been moved to another rack and got a new IP. Update it.

Bug: T156225
Change-Id: I371fd67fc1e071bd52650a58ed16f96f9bcecac0
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index c907dc8..1140002 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -450,7 +450,7 @@
'db1051' => '10.64.16.76', # do not remove or comment out
'db1052' => '10.64.16.77', # do not remove or comment out
'db1053' => '10.64.0.87', # do not remove or comment out
-   'db1054' => '10.64.32.24', # do not remove or comment out
+   'db1054' => '10.64.0.206', # do not remove or comment out
'db1055' => '10.64.32.25', # do not remove or comment out
'db1056' => '10.64.32.26', # do not remove or comment out
'db1057' => '10.64.32.27', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 488d80c..00ffc18 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -476,7 +476,7 @@
'db1051' => '10.64.16.76', # do not remove or comment out
'db1052' => '10.64.16.77', # do not remove or comment out
'db1053' => '10.64.0.87', # do not remove or comment out
-   'db1054' => '10.64.32.24', # do not remove or comment out
+   'db1054' => '10.64.0.206', # do not remove or comment out
'db1055' => '10.64.32.25', # do not remove or comment out
'db1056' => '10.64.32.26', # do not remove or comment out
'db1057' => '10.64.32.27', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I371fd67fc1e071bd52650a58ed16f96f9bcecac0
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1054"

2017-01-25 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1054"
..

Revert "db-eqiad.php: Depool db1054"

Maintenance finished

This reverts commit 7e0f43a58471765d16e80745e27824b7be16865e.

Change-Id: I3e13d66fbb153edb342db74a0497c550df35b71b
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 488d80c..151dceb 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -110,11 +110,11 @@
 #  'db1024' => 0,   # 1.4TB  64GB, old master
'db1021' => 0,   # 1.4TB  64GB, vslow, dump
'db1036' => 1,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1054' => 1,   # 2.8TB  96GB, api #T156225
+   'db1054' => 1,   # 2.8TB  96GB, api
'db1060' => 1,   # 2.8TB  96GB, api
 #  'db1063' => 0,   # 2.8TB 128GB
 #  'db1067' => 0,   # 2.8TB 160GB
-   'db1074' => 200, # 3.6TB 512GB, api #temporarily api T156225
+   'db1074' => 500, # 3.6TB 512GB
'db1076' => 500, # 3.6TB 512GB
'db1090' => 500, # 3.6TB 512GB
],
@@ -276,7 +276,7 @@
'db1021' => 1,
],
'api' => [
-   'db1074' => 1,
+   'db1054' => 1,
'db1060' => 1,
],
'watchlist' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I3e13d66fbb153edb342db74a0497c550df35b71b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Change active master for enwiki

2017-01-25 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/334030 )

Change subject: site.pp: Change active master for enwiki
..


site.pp: Change active master for enwiki

This changes the active enwiki master from db1057 to db1052

Bug: T156008
Change-Id: I4dd099044ba2b82cece6691273688e618c7336d8
---
M manifests/site.pp
1 file changed, 4 insertions(+), 4 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified
  Jcrespo: Looks good to me, but someone else must approve



diff --git a/manifests/site.pp b/manifests/site.pp
index 153d652..c0e23ae 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -411,18 +411,18 @@
 
 # s1 (enwiki) core production dbs on eqiad
 # eqiad master
-node 'db1057.eqiad.wmnet' {
+node 'db1052.eqiad.wmnet' {
 class { '::role::mariadb::core':
 shard => 's1',
 master=> true,
 binlog_format => 'STATEMENT',
 }
 }
-# soon-to-be master
-node 'db1052.eqiad.wmnet' {
+# old master
+node 'db1057.eqiad.wmnet' {
 class { '::role::mariadb::core':
 shard => 's1',
-master=> false,
+master=> true,
 binlog_format => 'STATEMENT',
 }
 }

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I4dd099044ba2b82cece6691273688e618c7336d8
Gerrit-PatchSet: 3
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: Volans 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Change s1 master

2017-01-25 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334242 )

Change subject: db-eqiad.php: Change s1 master
..

db-eqiad.php: Change s1 master

db1052 is the new master

Bug: T156008
Change-Id: Ibbf4d812299a8d592c84a968d7f80c1f44d8cb6d
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 00ffc18..4f914cc 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -93,8 +93,8 @@
 
 'sectionLoads' => [
's1' => [
-   'db1057' => 0,   # C2 2.8TB  96GB, master
-   'db1052' => 50,  # B3 2.8TB  96GB, old master
+   'db1052' => 0,  # B3 2.8TB  96GB, master
+#  'db1057' => 0,   # C2 2.8TB  96GB, old master
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibbf4d812299a8d592c84a968d7f80c1f44d8cb6d
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1052

2017-01-25 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334243 )

Change subject: db-eqiad.php: Depool db1052
..

db-eqiad.php: Depool db1052

db1052 is going to be the master in a few minutes. So depool it first

Bug: T156008
Change-Id: I7d8792e51f68837c84f924193a6f2fde8099a6d5
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 00ffc18..0f15281 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -94,7 +94,7 @@
 'sectionLoads' => [
's1' => [
'db1057' => 0,   # C2 2.8TB  96GB, master
-   'db1052' => 50,  # B3 2.8TB  96GB, old master
+#  'db1052' => 50,  # B3 2.8TB  96GB, old master
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I7d8792e51f68837c84f924193a6f2fde8099a6d5
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/software[master]: s1.hosts: db1052 is the new master

2017-01-26 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334254 )

Change subject: s1.hosts: db1052 is the new master
..

s1.hosts: db1052 is the new master

db1052 is the new s1 master so moving its position

Bug: T156008
Change-Id: I4788ff676bfffd9250d8339afc56af5a09c74003
---
M dbtools/s1.hosts
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/54/334254/1

diff --git a/dbtools/s1.hosts b/dbtools/s1.hosts
index e8944b3..70cc60e 100644
--- a/dbtools/s1.hosts
+++ b/dbtools/s1.hosts
@@ -25,7 +25,7 @@
 db1066.eqiad.wmnet  3306
 db1065.eqiad.wmnet  3306
 db1055.eqiad.wmnet  3306
-db1052.eqiad.wmnet  3306
 db1051.eqiad.wmnet  3306
 db1047.eqiad.wmnet  3306
 db1057.eqiad.wmnet  3306
+db1052.eqiad.wmnet  3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4788ff676bfffd9250d8339afc56af5a09c74003
Gerrit-PatchSet: 1
Gerrit-Project: operations/software
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Add rack positions for s4

2017-01-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334561 )

Change subject: db-codfw,db-eqiad.php: Add rack positions for s4
..

db-codfw,db-eqiad.php: Add rack positions for s4

Add rack positions for s4 across eqiad and codfw

Change-Id: I7fd4a3f9eacd6983cf8c2be935d7f88d82e87170
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 15 insertions(+), 15 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index af61769..36a0df5 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -119,12 +119,12 @@
'db2057' => 400, # D6 3.3TB 160GB
],
's4' => [
-   'db2019' => 0,   # 2.9TB  96GB, master
-   'db2037' => 50,  # 2.9TB 160GB, rc, log
-   'db2044' => 50,  # 2.9TB 160GB, rc, log
-   'db2051' => 200, # 2.9TB 160GB, api
-   'db2058' => 50,  # 3.3TB 160GB, dump (inactive), vslow
-   'db2065' => 400, # 3.3TB 160GB
+   'db2019' => 0,   # B6 2.9TB  96GB, master
+   'db2037' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2044' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2051' => 200, # C6 2.9TB 160GB, api
+   'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
+   'db2065' => 400, # D6 3.3TB 160GB
],
's5' => [
'db2023' => 0,   # 2.9TB  96GB, master
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a392436..e0b835b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -128,15 +128,15 @@
'db1078' => 500, # C3 3.6TB 512GB
],
's4' => [
-   'db1040' => 0,   # 1.4TB  64GB, master
-   'db1053' => 1,   # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1056' => 1,   # 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1059' => 1,   # 2.8TB  96GB, api
-   'db1064' => 0,   # 2.8TB 160GB, vslow, dump
-   'db1068' => 1,   # 2.8TB 160GB, api
-   'db1081' => 500, # 3.6TB 512GB
-   'db1084' => 500, # 3.6TB 512GB
-   'db1091' => 500, # 3.6TB 512GB
+   'db1040' => 0,   # B2 1.4TB  64GB, master
+   'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1059' => 1,   # C2 2.8TB  96GB, api
+   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
+   'db1068' => 1,   # D1 2.8TB 160GB, api
+   'db1081' => 500, # A2 3.6TB 512GB
+   'db1084' => 500, # B1 3.6TB 512GB
+   'db1091' => 500, # D2 3.6TB 512GB
],
's5' => [
'db1049' => 0,   # 2.8TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I7fd4a3f9eacd6983cf8c2be935d7f88d82e87170
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Add rack positions for s5

2017-01-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334568 )

Change subject: db-codfw,db-eqiad.php: Add rack positions for s5
..

db-codfw,db-eqiad.php: Add rack positions for s5

Add rack positions for s5 across eqiad and codfw

Change-Id: If3ca54ff1d2f4841b0eeb192f3cd2df06b2af31c
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 14 insertions(+), 14 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 36a0df5..745dee8 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -127,12 +127,12 @@
'db2065' => 400, # D6 3.3TB 160GB
],
's5' => [
-   'db2023' => 0,   # 2.9TB  96GB, master
-   'db2038' => 50,  # 2.9TB 160GB, rc, log
-   'db2045' => 400, # 2.9TB 160GB
-   'db2052' => 50,  # 2.9TB 160GB, dump (inactive), vslow
-   'db2059' => 100, # 3.3TB 160GB, api
-   'db2066' => 400, # 3.3TB 160GB
+   'db2023' => 0,   # B6 2.9TB  96GB, master
+   'db2038' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2045' => 400, # C6 2.9TB 160GB
+   'db2052' => 50,  # D6 2.9TB 160GB, dump (inactive), vslow
+   'db2059' => 100, # D6 3.3TB 160GB, api
+   'db2066' => 400, # D6 3.3TB 160GB
],
's6' => [
'db2028' => 0,   # 2.9TB  96GB, master
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index e0b835b..fd0e1d4 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -139,14 +139,14 @@
'db1091' => 500, # D2 3.6TB 512GB
],
's5' => [
-   'db1049' => 0,   # 2.8TB  64GB, master
-   'db1026' => 1,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1045' => 0,   # 1.4TB  64GB, vslow, dump
-   'db1070' => 50,  # 2.8TB 160GB, api, old master
-   'db1071' => 50,  # 2.8TB 160GB, api
-   'db1082' => 500, # 3.6TB 512GB
-   'db1087' => 500, # 3.6TB 512GB
-   'db1092' => 500, # 3.6TB 512GB
+   'db1049' => 0,   # B1 2.8TB  64GB, master
+   'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+   'db1045' => 0,   # B2 1.4TB  64GB, vslow, dump
+   'db1070' => 50,  # D1 2.8TB 160GB, api, old master
+   'db1071' => 50,  # D1 2.8TB 160GB, api
+   'db1082' => 500, # A2 3.6TB 512GB
+   'db1087' => 500, # C2 3.6TB 512GB
+   'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
'db1050' => 0,   # 2.8TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If3ca54ff1d2f4841b0eeb192f3cd2df06b2af31c
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Add rack positions for s6

2017-01-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334606 )

Change subject: db-codfw,db-eqiad.php: Add rack positions for s6
..

db-codfw,db-eqiad.php: Add rack positions for s6

Add rack positions for s6 across eqiad and codfw

Change-Id: I92e14e57c1fe58f372b9f537966d36bcaca0be77
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 15 insertions(+), 15 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 745dee8..a78a1a1 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -135,12 +135,12 @@
'db2066' => 400, # D6 3.3TB 160GB
],
's6' => [
-   'db2028' => 0,   # 2.9TB  96GB, master
-   'db2039' => 50,  # 2.9TB 160GB, rc, log
-   'db2046' => 400, # 2.9TB 160GB
-   'db2053' => 100, # 2.9TB 160GB, dump (inactive), vslow
-   'db2060' => 100, # 3.3TB 160GB, api
-   'db2067' => 400, # 3.3TB 160GB
+   'db2028' => 0,   # B6  2.9TB  96GB, master
+   'db2039' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2046' => 400, # C6 2.9TB 160GB
+   'db2053' => 100, # D6 2.9TB 160GB, dump (inactive), vslow
+   'db2060' => 100, # D6 3.3TB 160GB, api
+   'db2067' => 400, # D6 3.3TB 160GB
],
's7' => [
'db2029' => 0,   # 2.9TB  96GB, master
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index fd0e1d4..92288d1 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -149,15 +149,15 @@
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
-   'db1050' => 0,   # 2.8TB  64GB, master
-#  'db1023' => 0,   # 1.4TB  64GB, old master
-   'db1022' => 1,   # 1.4TB  64GB, api
-   'db1030' => 0,   # 1.4TB  64GB, vslow, dump
-   'db1037' => 1,   # 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
+   'db1050' => 0,   # B2 2.8TB  64GB, master
+#  'db1023' => 0,   # B1 1.4TB  64GB, old master
+   'db1022' => 1,   # B1 1.4TB  64GB, api
+   'db1030' => 0,   # B1 1.4TB  64GB, vslow, dump
+   'db1037' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1061' => 0,   # D1 2.8TB 128GB
+   'db1085' => 500, # B3 3.6TB 512GB
+   'db1088' => 500, # C2 3.6TB 512GB
+   'db1093' => 500, # D2 3.6TB 512GB
],
's7' => [
'db1041' => 0,   # 1.4TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I92e14e57c1fe58f372b9f537966d36bcaca0be77
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Add rack positions for s7

2017-01-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334644 )

Change subject: db-codfw,db-eqiad.php: Add rack positions for s7
..

db-codfw,db-eqiad.php: Add rack positions for s7

Add rack positions for s7 across eqiad and codfw

Change-Id: If1880a421dbd1510d0b329a7d281d7242b81d23b
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 15 insertions(+), 15 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index a78a1a1..9e5d5c0 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -143,12 +143,12 @@
'db2067' => 400, # D6 3.3TB 160GB
],
's7' => [
-   'db2029' => 0,   # 2.9TB  96GB, master
-   'db2040' => 200, # 2.9TB 160GB, rc, log
-   'db2047' => 400, # 2.9TB 160GB
-   'db2054' => 200, # 2.9TB 160GB, dump (inactive), vslow
-   'db2061' => 200, # 3.3TB 160GB, api
-   'db2068' => 300, # 3.3TB 160GB
+   'db2029' => 0,   # B6 2.9TB  96GB, master
+   'db2040' => 200, # C6 2.9TB 160GB, rc, log
+   'db2047' => 400, # C6 2.9TB 160GB
+   'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
+   'db2061' => 200, # D6 3.3TB 160GB, api
+   'db2068' => 300, # D6 3.3TB 160GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 92288d1..101d1cd 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -160,15 +160,15 @@
'db1093' => 500, # D2 3.6TB 512GB
],
's7' => [
-   'db1041' => 0,   # 1.4TB  64GB, master
-#  'db1033' => 0,   # 1.4TB  64GB, old master
-   'db1028' => 0,   # 1.4TB  64GB, vslow, dump
-   'db1034' => 1,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1039' => 0,   # 1.4TB  64GB
-   'db1062' => 1,   # 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
-   'db1079' => 300, # 3.6TB 512GB, api
-   'db1086' => 500, # 3.6TB 512GB, api
-   'db1094' => 500, # 3.6TB 512GB
+   'db1041' => 0,   # B2 1.4TB  64GB, master
+#  'db1033' => 0,   # B2 1.4TB  64GB, old master
+   'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump
+   'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1039' => 0,   # B2 1.4TB  64GB
+   'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
+   'db1079' => 300, # A2 3.6TB 512GB, api
+   'db1086' => 500, # B3 3.6TB 512GB, api
+   'db1094' => 500, # D2 3.6TB 512GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If1880a421dbd1510d0b329a7d281d7242b81d23b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Change db1072 IP and rack

2017-01-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334670 )

Change subject: db-codfw,db-eqiad.php: Change db1072 IP and rack
..

db-codfw,db-eqiad.php: Change db1072 IP and rack

db1072 is moved to B2 and thus got another IP.

Bug: T156226
Change-Id: Idfc3ab1198212e543140f21e567563ebc13330a8
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 9e5d5c0..0ac95cf 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -466,7 +466,7 @@
'db1068' => '10.64.48.23', # do not remove or comment out
'db1070' => '10.64.48.25', # do not remove or comment out
'db1071' => '10.64.48.26', # do not remove or comment out
-   'db1072' => '10.64.48.27', # do not remove or comment out
+   'db1072' => '10.64.16.39', # do not remove or comment out
'db1073' => '10.64.48.28', # do not remove or comment out
'db1074' => '10.64.0.204', # do not remove or comment out
'db1075' => '10.64.0.205', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 101d1cd..57c27db 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,7 +99,7 @@
 #  'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
-#  'db1072' => 0,   # D1 2.8TB 160GB #maintenance T156166
+#  'db1072' => 0,   # B2 2.8TB 160GB #maintenance T156166
'db1073' => 50,  # D1 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
@@ -492,7 +492,7 @@
'db1068' => '10.64.48.23', # do not remove or comment out
'db1070' => '10.64.48.25', # do not remove or comment out
'db1071' => '10.64.48.26', # do not remove or comment out
-   'db1072' => '10.64.48.27', # do not remove or comment out
+   'db1072' => '10.64.16.39', # do not remove or comment out
'db1073' => '10.64.48.28', # do not remove or comment out
'db1074' => '10.64.0.204', # do not remove or comment out
'db1075' => '10.64.0.205', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idfc3ab1198212e543140f21e567563ebc13330a8
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Add rack positions

2017-01-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334552 )

Change subject: db-codfw,db-eqiad.php: Add rack positions
..

db-codfw,db-eqiad.php: Add rack positions

Add rack positions for s1 and s2 across eqiad and codfw

Change-Id: I3085bab6554c0cceaf5add4f8083844b9453fb8b
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 26 insertions(+), 26 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1140002..26f003a 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -93,23 +93,23 @@
 
 'sectionLoads' => [
's1' => [
-   'db2016' => 0,   # 2.9TB  96GB, master #B6
-   'db2034' => 50,  # 2.9TB 160GB, rc, log #C6
-   'db2042' => 50,  # 2.9TB 160GB, rc, log #C6
-   'db2048' => 400, # 2.9TB 160GB #C6
-   'db2055' => 50,  # 3.3TB 160GB, dump (inactive), vslow #D6
-   'db2062' => 100, # 3.3TB 160GB, api #D6
-   'db2069' => 100, # 3.3TB 160GB, api #D6
-   'db2070' => 400, # 3.3TB 160GB #D6
+   'db2016' => 0,   # B6 2.9TB  96GB, master
+   'db2034' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2042' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2048' => 400, # C6 2.9TB 160GB
+   'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
+   'db2062' => 100, # D6 3.3TB 160GB, api
+   'db2069' => 100, # D6 3.3TB 160GB, api
+   'db2070' => 400, # D6 3.3TB 160GB
],
's2' => [
-   'db2017' => 0,   # 2.9TB  96GB, master
-   'db2035' => 50,  # 2.9TB 160GB, rc, log
-   'db2041' => 100, # 2.9TB 160GB, api
-   'db2049' => 400, # 2.9TB 160GB,
-   'db2056' => 50,  # 3.3TB 160GB, dump (inactive), vslow
-   'db2063' => 100, # 3.3TB 160GB, api
-   'db2064' => 400, # 3.3TB 160GB
+   'db2017' => 0,   # B6 2.9TB  96GB, master
+   'db2035' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2041' => 100, # C6 2.9TB 160GB, api
+   'db2049' => 400, # C6 2.9TB 160GB,
+   'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
+   'db2063' => 100, # D6 3.3TB 160GB, api
+   'db2064' => 400, # D6 3.3TB 160GB
],
/* s3 */ 'DEFAULT' => [
'db2018' => 0,   # 2.9TB  96GB, master
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 2bff1b9..2cdd33f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -106,17 +106,17 @@
'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [
-   'db1018' => 0,   # 1.4TB  64GB, master
-#  'db1024' => 0,   # 1.4TB  64GB, old master
-   'db1021' => 0,   # 1.4TB  64GB, vslow, dump
-   'db1036' => 1,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1054' => 1,   # 2.8TB  96GB, api
-   'db1060' => 1,   # 2.8TB  96GB, api
-#  'db1063' => 0,   # 2.8TB 128GB
-#  'db1067' => 0,   # 2.8TB 160GB
-   'db1074' => 500, # 3.6TB 512GB
-   'db1076' => 500, # 3.6TB 512GB
-   'db1090' => 500, # 3.6TB 512GB
+   'db1018' => 0,   # B1 1.4TB  64GB, master
+#  'db1024' => 0,   # B1 1.4TB  64GB, old master
+   'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
+   'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+   'db1054' => 1,   # A3 2.8TB  96GB, api
+   'db1060' => 1,   # C2 2.8TB  96GB, api
+#  'db1063' => 0,   # D1 2.8TB 128GB
+#  'db1067' => 0,   # D1 2.8TB 160GB
+   'db1074' => 500, # A2 3.6TB 512GB
+   'db1076' => 500, # B1 3.6TB 512GB
+   'db1090' => 500, # C3 3.6TB 512GB
],
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # 3.6TB 512GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I3085bab6554c0cceaf5add4f8083844b9453fb8b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Add rack positions

2017-01-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/334554 )

Change subject: db-codfw,db-eqiad.php: Add rack positions
..

db-codfw,db-eqiad.php: Add rack positions

Add rack positions for s3 across eqiad and codfw

Change-Id: Ie834f3c1868398161b701b6111d8582f81c33906
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 12 insertions(+), 12 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 26f003a..af61769 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -112,11 +112,11 @@
'db2064' => 400, # D6 3.3TB 160GB
],
/* s3 */ 'DEFAULT' => [
-   'db2018' => 0,   # 2.9TB  96GB, master
-   'db2036' => 50,  # 2.9TB 160GB, rc, log
-   'db2043' => 50,  # 2.9TB 160GB, dump (inactive), vslow
-   'db2050' => 150, # 2.9TB 160GB, api
-   'db2057' => 400, # 3.3TB 160GB
+   'db2018' => 0,   # B6 2.9TB  96GB, master
+   'db2036' => 50,  # C6 2.9TB 160GB, rc, log
+   'db2043' => 50,  # C6 2.9TB 160GB, dump (inactive), vslow
+   'db2050' => 150, # C6 2.9TB 160GB, api
+   'db2057' => 400, # D6 3.3TB 160GB
],
's4' => [
'db2019' => 0,   # 2.9TB  96GB, master
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 2cdd33f..a392436 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -119,13 +119,13 @@
'db1090' => 500, # C3 3.6TB 512GB
],
/* s3 */ 'DEFAULT' => [
-   'db1075' => 0,   # 3.6TB 512GB, master
-   'db1038' => 0,   # 1.4TB  64GB, vslow, dump, old master
-   'db1015' => 1,   # 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1035' => 0,   # 1.4TB  64GB
-#  'db1044' => 0,   # 1.4TB  64GB, #Temporary master for db1095 - 
new sanitarium #T150802
-   'db1077' => 500, # 3.6TB 512GB
-   'db1078' => 500, # 3.6TB 512GB
+   'db1075' => 0,   # A2 3.6TB 512GB, master
+   'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master
+   'db1015' => 1,   # A2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1035' => 0,   # B2 1.4TB  64GB
+#  'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
+   'db1077' => 500, # B1 3.6TB 512GB
+   'db1078' => 500, # C3 3.6TB 512GB
],
's4' => [
'db1040' => 0,   # 1.4TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie834f3c1868398161b701b6111d8582f81c33906
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-codfw.php: Depool db2060"

2017-02-15 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-codfw.php: Depool db2060"
..

Revert "db-codfw.php: Depool db2060"

This reverts commit 2f383c0aab77a23c6c2e68a3166933fc937b0914.

Change-Id: Idc1542c631234f894e14b04d1ceae05388fadf93
---
M wmf-config/db-codfw.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 20ffe16..2438b76 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -139,8 +139,8 @@
'db2039' => 50,  # C6 2.9TB 160GB, rc, log
'db2046' => 400, # C6 2.9TB 160GB
'db2053' => 100, # D6 2.9TB 160GB, dump (inactive), vslow
-#  'db2060' => 100, # D6 3.3TB 160GB, api #T156161
-   'db2067' => 200, # D6 3.3TB 160GB, api #Temporary api #T156161
+   'db2060' => 100, # D6 3.3TB 160GB, api
+   'db2067' => 400, # D6 3.3TB 160GB
],
's7' => [
'db2029' => 0,   # B6 2.9TB  96GB, master
@@ -381,7 +381,7 @@
'db2053' => 1,
],
'api' => [
-   'db2067' => 1,
+   'db2060' => 1,
],
],
's7' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idc1542c631234f894e14b04d1ceae05388fadf93
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Increase load db1082

2017-02-15 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/338067 )

Change subject: db-eqiad.php: Increase load db1082
..

db-eqiad.php: Increase load db1082

db1082 had a crash and was repooled with reduced load.
Increase it a bit to see how it reacts

Bug: T158188
Change-Id: If465b5ffe974fca026b8fc08a9fb3acd9ff3deea
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index cb4ed2c..bdd5508 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
 #  'db1045' => 0,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump
'db1071' => 50,  # D1 2.8TB 160GB, api
-   'db1082' => 10,  # A2 3.6TB 512GB, #mysql crashed, pooled with 
low load
+   'db1082' => 100,  # A2 3.6TB 512GB, #mysql crashed, pooled with 
low load
'db1087' => 300, # C2 3.6TB 512GB, api #temp
'db1092' => 500, # D2 3.6TB 512GB
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If465b5ffe974fca026b8fc08a9fb3acd9ff3deea
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Repool db2055 restore db2048 weight

2017-02-21 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339118 )

Change subject: db-codfw.php: Repool db2055 restore db2048 weight
..

db-codfw.php: Repool db2055 restore db2048 weight

db2055 and db2048 had their alter table finished

Bug: T132416
Change-Id: Iae2d0ae017dd894d82a9dafda30de7cf19cf93b0
---
M wmf-config/db-codfw.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1bfc4b3..da44f55 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -96,8 +96,8 @@
'db2016' => 0,   # B6 2.9TB  96GB, master
'db2034' => 50,  # A5 2.9TB 160GB, rc, log
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
-   'db2048' => 50, # C6 2.9TB 160GB, dump,vslow #temporary vslow 
T132416
-#  'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T132416
+   'db2048' => 400, # C6 2.9TB 160GB,
+   'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2062' => 100, # B5 3.3TB 160GB, api
'db2069' => 100, # D6 3.3TB 160GB, api
'db2070' => 400, # C5 3.3TB 160GB
@@ -238,10 +238,10 @@
'db2042' => 1,
],
'dump' => [
-   'db2048' => 1,
+   'db2055' => 1,
],
'vslow' => [
-   'db2048' => 1,
+   'db2055' => 1,
],
'api' => [
'db2062' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iae2d0ae017dd894d82a9dafda30de7cf19cf93b0
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Depool db2062

2017-02-21 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339119 )

Change subject: db-codfw.php: Depool db2062
..

db-codfw.php: Depool db2062

db2062 needs an ALTER table

Bug: T132416
Change-Id: I9ee6fcf091839ed8ec4bfc80e5f420c4f59acb38
---
M wmf-config/db-codfw.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index da44f55..0e0fa86 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -98,7 +98,7 @@
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2048' => 400, # C6 2.9TB 160GB,
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   'db2062' => 100, # B5 3.3TB 160GB, api
+#  'db2062' => 100, # B5 3.3TB 160GB, api #T132416
'db2069' => 100, # D6 3.3TB 160GB, api
'db2070' => 400, # C5 3.3TB 160GB
],
@@ -244,7 +244,7 @@
'db2055' => 1,
],
'api' => [
-   'db2062' => 1,
+#  'db2062' => 1,
'db2069' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9ee6fcf091839ed8ec4bfc80e5f420c4f59acb38
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1060"

2017-02-22 Thread Marostegui (Code Review) 
Hello jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1060"
..

Revert "db-eqiad.php: Depool db1060"

This reverts commit 7bf036ee171b2841bffed98f7464bd2b1a60f06d.

Change-Id: I2b9de63e3313d7cead35b6f68ba01cdd00eeedbc
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 85b9795..06c5d6d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -111,10 +111,10 @@
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
-#  'db1060' => 1,   # C2 2.8TB  96GB, api #T158194
+   'db1060' => 1,   # C2 2.8TB  96GB, api
 #  'db1063' => 0,   # D1 2.8TB 128GB
 #  'db1067' => 0,   # D1 2.8TB 160GB
-   'db1074' => 300, # A2 3.6TB 512GB, api #T158194
+   'db1074' => 500, # A2 3.6TB 512GB
'db1076' => 500, # B1 3.6TB 512GB
'db1090' => 500, # C3 3.6TB 512GB
],
@@ -278,7 +278,7 @@
],
'api' => [
'db1054' => 1,
-   'db1074' => 1,
+   'db1060' => 1,
],
'watchlist' => [
'db1036' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2b9de63e3313d7cead35b6f68ba01cdd00eeedbc
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Add gtid_domain_id to s2

2017-02-20 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/338734 )

Change subject: mariadb: Add gtid_domain_id to s2
..

mariadb: Add gtid_domain_id to s2

Enable gtid_domain_id on s2. After a few days letting it run on s6
It has been running for for weeks on the misc shards so it is time to
slowly deploy it on production shards.

Change-Id: Iacfd9cab8535e34e40e29d3afa9fda3310f9d8f0
---
M modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/34/338734/1

diff --git a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
index a856935..1346ad2 100644
--- a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
@@ -30,7 +30,7 @@
 datadir= <%= @datadir %>
 tmpdir = <%= @tmpdir %>
 server_id  = <%= @server_id %>
-<% if @shard == 's6' -%>
+<% if @shard == 's6' || @shard == 's2' -%>
 # gtid_domain_id flag is needed for multisource replication and GTID.
 # Strictly it is only needed on masters or servers that can potentially be
 # masters but for consistency it should be set in all of them.

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iacfd9cab8535e34e40e29d3afa9fda3310f9d8f0
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Add gtid_domain_id to s6

2017-02-20 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/335816 )

Change subject: mariadb: Add gtid_domain_id to s6
..


mariadb: Add gtid_domain_id to s6

Enable gtid_domain_id on s6 shard (frwiki,jawiki,ruwiki).
It has been running for for weeks on the misc shards so it is time to
slowly deploy it on production shards.

Bug: T149418
Change-Id: Ica9ed7a8d1f68e385539587c245f7567b65ba25f
---
M modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
1 file changed, 8 insertions(+), 0 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified
  Jcrespo: Looks good to me, but someone else must approve



diff --git a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
index a111aea..a856935 100644
--- a/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/production.my.cnf.erb
@@ -30,6 +30,14 @@
 datadir= <%= @datadir %>
 tmpdir = <%= @tmpdir %>
 server_id  = <%= @server_id %>
+<% if @shard == 's6' -%>
+# gtid_domain_id flag is needed for multisource replication and GTID.
+# Strictly it is only needed on masters or servers that can potentially be
+# masters but for consistency it should be set in all of them.
+# https://mariadb.com/kb/en/mariadb/gtid/
+
+gtid_domain_id  = <%= @gtid_domain_id %>
+<% end -%>
 
 skip-external-locking
 skip-name-resolve

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ica9ed7a8d1f68e385539587c245f7567b65ba25f
Gerrit-PatchSet: 4
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Repool db2070

2017-02-16 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/338319 )

Change subject: db-codfw.php: Repool db2070
..

db-codfw.php: Repool db2070

db2070 was moved to another rack and was depooled. Repool it
Also, update its rack position in the file.

Bug: T156478
Change-Id: Ida46942190eb2046d26855a038f08f9f3e762644
---
M wmf-config/db-codfw.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 4888401..d1f19ed 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -100,7 +100,7 @@
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2062' => 100, # B5 3.3TB 160GB, api
'db2069' => 100, # D6 3.3TB 160GB, api
-#  'db2070' => 400, # D6 3.3TB 160GB #T156478
+   'db2070' => 400, # C5 3.3TB 160GB
],
's2' => [
'db2017' => 0,   # B6 2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ida46942190eb2046d26855a038f08f9f3e762644
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Repool db2069 depool db2070

2017-02-23 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339602 )

Change subject: db-codfw.php: Repool db2069 depool db2070
..

db-codfw.php: Repool db2069 depool db2070

db2069 finished the alter table
db2070 needs an alter table

Bug: T132416
Change-Id: Ic8bfa42066e7394b1c7a623b156e165b8a70659f
---
M wmf-config/db-codfw.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 85b3449..c877a54 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -99,8 +99,8 @@
'db2048' => 400, # C6 2.9TB 160GB,
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2062' => 100, # B5 3.3TB 160GB, api
-#  'db2069' => 100, # D6 3.3TB 160GB, api #T132416
-   'db2070' => 400, # C5 3.3TB 160GB
+   'db2069' => 100, # D6 3.3TB 160GB, api
+#  'db2070' => 400, # C5 3.3TB 160GB
],
's2' => [
'db2017' => 0,   # B6 2.9TB  96GB, master
@@ -245,7 +245,7 @@
],
'api' => [
'db2062' => 1,
-#  'db2069' => 1,
+   'db2069' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic8bfa42066e7394b1c7a623b156e165b8a70659f
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Repool db1036

2017-02-24 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339609 )

Change subject: db-eqiad.php: Repool db1036
..

db-eqiad.php: Repool db1036

db1036 was out due to the lag generated while doing a pt-table-checkskum

Bug: T154485
Change-Id: I6b7336fa6d0cfc21241380811f3c74d44700d639
---
M wmf-config/db-eqiad.php
1 file changed, 7 insertions(+), 7 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0cfd0da..06c5d6d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -109,10 +109,10 @@
'db1018' => 0,   # B1 1.4TB  64GB, master
 #  'db1024' => 0,   # B1 1.4TB  64GB, old master
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
-#  'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+   'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
'db1060' => 1,   # C2 2.8TB  96GB, api
-   'db1063' => 0,   # D1 2.8TB 128GB #temporary recentchanges
+#  'db1063' => 0,   # D1 2.8TB 128GB
 #  'db1067' => 0,   # D1 2.8TB 160GB
'db1074' => 500, # A2 3.6TB 512GB
'db1076' => 500, # B1 3.6TB 512GB
@@ -281,19 +281,19 @@
'db1060' => 1,
],
'watchlist' => [
-   'db1063' => 1,
+   'db1036' => 1,
],
'recentchanges' => [
-   'db1063' => 1,
+   'db1036' => 1,
],
'recentchangeslinked' => [
-   'db1063' => 1,
+   'db1036' => 1,
],
'contributions' => [
-   'db1063' => 1,
+   'db1036' => 1,
],
'logpager' => [
-   'db1063' => 1,
+   'db1036' => 1,
],
],
/* s3 */ 'DEFAULT' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6b7336fa6d0cfc21241380811f3c74d44700d639
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Repool db1060 with low weight

2017-02-22 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339226 )

Change subject: db-eqiad.php: Repool db1060 with low weight
..

db-eqiad.php: Repool db1060 with low weight

db1060 had a BBU replaced, repool it with less load until it warms up

Bug: T158194
Change-Id: I6acfe0ba2a52276af52ad4f1546534dd98d84b3b
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 85b9795..41bf55e 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -111,7 +111,7 @@
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
-#  'db1060' => 1,   # C2 2.8TB  96GB, api #T158194
+   'db1060' => 20,   # C2 2.8TB  96GB, api #T158194
 #  'db1063' => 0,   # D1 2.8TB 128GB
 #  'db1067' => 0,   # D1 2.8TB 160GB
'db1074' => 300, # A2 3.6TB 512GB, api #T158194

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6acfe0ba2a52276af52ad4f1546534dd98d84b3b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1036 from logpager

2017-02-23 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339366 )

Change subject: db-eqiad.php: Depool db1036 from logpager
..

db-eqiad.php: Depool db1036 from logpager

Change-Id: I4f6080460f3c1aa1adfd8aa241721332deff9f3b
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5f00606..0cfd0da 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -293,7 +293,7 @@
'db1063' => 1,
],
'logpager' => [
-   'db1036' => 1,
+   'db1063' => 1,
],
],
/* s3 */ 'DEFAULT' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4f6080460f3c1aa1adfd8aa241721332deff9f3b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: linux-host-entries: Remove trusty from dbstore1001

2017-02-23 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/339351 )

Change subject: linux-host-entries: Remove trusty from dbstore1001
..


linux-host-entries: Remove trusty from dbstore1001

dbstore1001 is going to be reimaged with new disks, and needs to go to
jessie.

Bug: T153768
Change-Id: Ie1a2f42134e3c7248c858a0910106adf050e3f18
---
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
1 file changed, 0 insertions(+), 2 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200 
b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
index 84faaee..b3bfd06 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1728,8 +1728,6 @@
 host dbstore1001 {
 hardware ethernet C8:1F:66:B8:2A:04;
 fixed-address dbstore1001.eqiad.wmnet;
-option pxelinux.pathprefix "trusty-installer/";
-filename "trusty-installer/ubuntu-installer/amd64/pxelinux.0";
 }
 
 host dbstore1002 {

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ie1a2f42134e3c7248c858a0910106adf050e3f18
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Depool db2048

2017-02-19 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/338707 )

Change subject: db-codfw.php: Depool db2048
..

db-codfw.php: Depool db2048

db2048 needs an ALTER table

Bug: T132416
Change-Id: Id21ffbc2c08c65ccb7b2cdb7fb9e5279ce367425
---
M wmf-config/db-codfw.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index d1f19ed..553393f 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -96,7 +96,7 @@
'db2016' => 0,   # B6 2.9TB  96GB, master
'db2034' => 50,  # A5 2.9TB 160GB, rc, log
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
-   'db2048' => 400, # C6 2.9TB 160GB
+#  'db2048' => 400, # C6 2.9TB 160GB #T147305
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2062' => 100, # B5 3.3TB 160GB, api
'db2069' => 100, # D6 3.3TB 160GB, api

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id21ffbc2c08c65ccb7b2cdb7fb9e5279ce367425
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Update ticket for db2048

2017-02-19 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/338709 )

Change subject: db-codfw.php: Update ticket for db2048
..

db-codfw.php: Update ticket for db2048

Changing the ticket that reflects why db2048 is out. As this is the
correct one

Change-Id: I5bcef2dd16bb0387cbc0c4909754692a91d57451
---
M wmf-config/db-codfw.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 553393f..7fbb024 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -96,7 +96,7 @@
'db2016' => 0,   # B6 2.9TB  96GB, master
'db2034' => 50,  # A5 2.9TB 160GB, rc, log
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
-#  'db2048' => 400, # C6 2.9TB 160GB #T147305
+#  'db2048' => 400, # C6 2.9TB 160GB #T132416
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2062' => 100, # B5 3.3TB 160GB, api
'db2069' => 100, # D6 3.3TB 160GB, api

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I5bcef2dd16bb0387cbc0c4909754692a91d57451
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: realm.pp: Add __wmf_checksums table to be ignored

2017-02-22 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/339182 )

Change subject: realm.pp: Add __wmf_checksums table to be ignored
..


realm.pp: Add __wmf_checksums table to be ignored

When using pt-table-checksums, it does some writes to that table, not
ignoring that table makes sanitarium hosts break as it tries to do write
to it after selecting from other tables that might not exist as well.

Bug: T154485
Change-Id: I8e8a79f5f8a8a706684b24c90e8d348d39ea270b
---
M manifests/realm.pp
1 file changed, 1 insertion(+), 0 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified
  Jcrespo: Looks good to me, but someone else must approve



diff --git a/manifests/realm.pp b/manifests/realm.pp
index b1b1bbf..11477d4 100644
--- a/manifests/realm.pp
+++ b/manifests/realm.pp
@@ -154,6 +154,7 @@
 'zerowiki' ]
 
 $private_tables = [
+'__wmf_checksums',
 'accountaudit_login',
 'arbcom1_vote',
 'archive_old',

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I8e8a79f5f8a8a706684b24c90e8d348d39ea270b
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: realm.pp: Add __wmf_checksum table to be ignored

2017-02-22 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339182 )

Change subject: realm.pp: Add __wmf_checksum table to be ignored
..

realm.pp: Add __wmf_checksum table to be ignored

When using pt-table-checksum, it does some writes to that table, not
ignoring that table makes sanitarium hosts break as it tries to do write
to it after selecting from other tables that might not exist as well.

Bug: T154485
Change-Id: I8e8a79f5f8a8a706684b24c90e8d348d39ea270b
---
M manifests/realm.pp
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/82/339182/1

diff --git a/manifests/realm.pp b/manifests/realm.pp
index b1b1bbf..4ed0736 100644
--- a/manifests/realm.pp
+++ b/manifests/realm.pp
@@ -154,6 +154,7 @@
 'zerowiki' ]
 
 $private_tables = [
+'__wmf_checksum',
 'accountaudit_login',
 'arbcom1_vote',
 'archive_old',

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8e8a79f5f8a8a706684b24c90e8d348d39ea270b
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Restore db1060 original load

2017-02-22 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339349 )

Change subject: db-eqiad.php: Restore db1060 original load
..

db-eqiad.php: Restore db1060 original load

db1060 was depooled to get the BBU replaced and now restoring its
original load and role on the API service

Bug: T158194
Change-Id: Iae5ae168671473d9c6ee34de3f40cbd757f8e70a
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 41bf55e..06c5d6d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -111,10 +111,10 @@
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
-   'db1060' => 20,   # C2 2.8TB  96GB, api #T158194
+   'db1060' => 1,   # C2 2.8TB  96GB, api
 #  'db1063' => 0,   # D1 2.8TB 128GB
 #  'db1067' => 0,   # D1 2.8TB 160GB
-   'db1074' => 300, # A2 3.6TB 512GB, api #T158194
+   'db1074' => 500, # A2 3.6TB 512GB
'db1076' => 500, # B1 3.6TB 512GB
'db1090' => 500, # C3 3.6TB 512GB
],
@@ -278,7 +278,7 @@
],
'api' => [
'db1054' => 1,
-   'db1074' => 1,
+   'db1060' => 1,
],
'watchlist' => [
'db1036' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iae5ae168671473d9c6ee34de3f40cbd757f8e70a
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Repool db2062 - depool db2069

2017-02-22 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339350 )

Change subject: db-codfw.php: Repool db2062 - depool db2069
..

db-codfw.php: Repool db2062 - depool db2069

db2062 finished the ALTER table so repool it
db2069 needs an ALTER table so depool it

Bug: T132416
Change-Id: I8874f82da47c9fb6739ab521467c3353290d7dbd
---
M wmf-config/db-codfw.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 0e0fa86..85b3449 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -98,8 +98,8 @@
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2048' => 400, # C6 2.9TB 160GB,
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-#  'db2062' => 100, # B5 3.3TB 160GB, api #T132416
-   'db2069' => 100, # D6 3.3TB 160GB, api
+   'db2062' => 100, # B5 3.3TB 160GB, api
+#  'db2069' => 100, # D6 3.3TB 160GB, api #T132416
'db2070' => 400, # C5 3.3TB 160GB
],
's2' => [
@@ -244,8 +244,8 @@
'db2055' => 1,
],
'api' => [
-#  'db2062' => 1,
-   'db2069' => 1,
+   'db2062' => 1,
+#  'db2069' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8874f82da47c9fb6739ab521467c3353290d7dbd
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: linux-host-entries: Remove trusty from dbstore1001

2017-02-22 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339351 )

Change subject: linux-host-entries: Remove trusty from dbstore1001
..

linux-host-entries: Remove trusty from dbstore1001

dbstore1001 is going to be reimaged with new disks, and needs to go to
jessie.

Bug: T153768
Change-Id: Ie1a2f42134e3c7248c858a0910106adf050e3f18
---
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
1 file changed, 0 insertions(+), 2 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/51/339351/1

diff --git a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200 
b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
index 84faaee..b3bfd06 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1728,8 +1728,6 @@
 host dbstore1001 {
 hardware ethernet C8:1F:66:B8:2A:04;
 fixed-address dbstore1001.eqiad.wmnet;
-option pxelinux.pathprefix "trusty-installer/";
-filename "trusty-installer/ubuntu-installer/amd64/pxelinux.0";
 }
 
 host dbstore1002 {

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie1a2f42134e3c7248c858a0910106adf050e3f18
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1060

2017-02-22 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339200 )

Change subject: db-eqiad.php: Depool db1060
..

db-eqiad.php: Depool db1060

db1060 needs its BBU replaced

Bug: T158194
Change-Id: I0560050491557ab83e6bd505b6d938519d8f4779
---
M wmf-config/db-eqiad.php
1 file changed, 3 insertions(+), 3 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 06c5d6d..85b9795 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -111,10 +111,10 @@
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
-   'db1060' => 1,   # C2 2.8TB  96GB, api
+#  'db1060' => 1,   # C2 2.8TB  96GB, api #T158194
 #  'db1063' => 0,   # D1 2.8TB 128GB
 #  'db1067' => 0,   # D1 2.8TB 160GB
-   'db1074' => 500, # A2 3.6TB 512GB
+   'db1074' => 300, # A2 3.6TB 512GB, api #T158194
'db1076' => 500, # B1 3.6TB 512GB
'db1090' => 500, # C3 3.6TB 512GB
],
@@ -278,7 +278,7 @@
],
'api' => [
'db1054' => 1,
-   'db1060' => 1,
+   'db1074' => 1,
],
'watchlist' => [
'db1036' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0560050491557ab83e6bd505b6d938519d8f4779
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1063

2017-02-23 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/339364 )

Change subject: db-eqiad.php: Depool db1063
..

db-eqiad.php: Depool db1063

Change-Id: I89b18f94365b2875d035ce49e9911bcc1ee39d11
---
M wmf-config/db-eqiad.php
1 file changed, 5 insertions(+), 5 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 06c5d6d..f2bfbc9 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -112,7 +112,7 @@
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
'db1060' => 1,   # C2 2.8TB  96GB, api
-#  'db1063' => 0,   # D1 2.8TB 128GB
+   'db1063' => 0,   # D1 2.8TB 128GB #temporary recentchanges
 #  'db1067' => 0,   # D1 2.8TB 160GB
'db1074' => 500, # A2 3.6TB 512GB
'db1076' => 500, # B1 3.6TB 512GB
@@ -281,16 +281,16 @@
'db1060' => 1,
],
'watchlist' => [
-   'db1036' => 1,
+   'db1063' => 1,
],
'recentchanges' => [
-   'db1036' => 1,
+   'db1063' => 1,
],
'recentchangeslinked' => [
-   'db1036' => 1,
+   'db1063' => 1,
],
'contributions' => [
-   'db1036' => 1,
+   'db1063' => 1,
],
'logpager' => [
'db1036' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I89b18f94365b2875d035ce49e9911bcc1ee39d11
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Depool db2062

2017-02-14 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/337592 )

Change subject: db-codfw.php: Depool db2062
..

db-codfw.php: Depool db2062

db2062 is going to be moved to another rack (B5) so needs to be
depooled.

Bug: T156478
Change-Id: Ieeb5bb4b6da05d333e26ecb41c5635903e1c1f02
---
M wmf-config/db-codfw.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 2349226..1d484b4 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -98,7 +98,7 @@
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2048' => 400, # C6 2.9TB 160GB
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   'db2062' => 100, # D6 3.3TB 160GB, api
+#  'db2062' => 100, # B5 3.3TB 160GB, api #T156478
'db2069' => 100, # D6 3.3TB 160GB, api
'db2070' => 400, # D6 3.3TB 160GB
],
@@ -244,7 +244,7 @@
'db2055' => 1,
],
'api' => [
-   'db2062' => 1,
+#  'db2062' => 1,
'db2069' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ieeb5bb4b6da05d333e26ecb41c5635903e1c1f02
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/puppet[production]: Reporting tests with the private data script

2017-02-14 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/328352 )

Change subject: Reporting tests with the private data script
..


Reporting tests with the private data script

* For now just run the private data script and  email me
once something is found so it can be polished.
* Scheduled to run once per week now: every Monday.

Ideally it should be an icinga check eventually.

Bug: T153680
Change-Id: I7796d6860f70c34b1758655f18a4ed8196724e97
---
A modules/role/files/mariadb/check_private_data_report
M modules/role/manifests/labs/db/check_private_data.pp
2 files changed, 48 insertions(+), 0 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified
  Volans: Looks good to me, but someone else must approve



diff --git a/modules/role/files/mariadb/check_private_data_report 
b/modules/role/files/mariadb/check_private_data_report
new file mode 100755
index 000..fa232f6
--- /dev/null
+++ b/modules/role/files/mariadb/check_private_data_report
@@ -0,0 +1,28 @@
+#!/bin/bash
+set -e
+
+PRIVATE_DATA="/usr/local/sbin/check_private_data.py"
+REPORT_PATH="/var/log/private_data_report_${HOSTNAME}.log"
+
+if [ ! -f "$PRIVATE_DATA" ]
+then
+echo "$PRIVATE_DATA is not present"
+exit 1
+fi
+
+# run the script
+
+if [ "$HOSTNAME" == "db1069" ]
+then
+echo "This script will not work on db1069 as it has multiple instances"
+exit 1
+fi
+echo "Start time: $(date)" > "$REPORT_PATH"
+$PRIVATE_DATA >> "$REPORT_PATH" 2>&1
+
+DATA=$(/bin/egrep -v "^--|^Start time" -c "$REPORT_PATH")
+
+if [ "$DATA" -gt "0" ]
+then
+echo "Private data detected at $HOSTNAME check: $REPORT_PATH" | 
/usr/bin/mail -s "Private data found at $HOSTNAME" maroste...@wikimedia.org
+fi
diff --git a/modules/role/manifests/labs/db/check_private_data.pp 
b/modules/role/manifests/labs/db/check_private_data.pp
index 0859bbc..fb5fe03 100644
--- a/modules/role/manifests/labs/db/check_private_data.pp
+++ b/modules/role/manifests/labs/db/check_private_data.pp
@@ -30,4 +30,24 @@
 File['/etc/mysql/private_tables.txt'],
 ],
 }
+
+file { '/usr/local/sbin/check_private_data_report':
+ensure => file,
+source => 'puppet:///modules/role/mariadb/check_private_data_report',
+owner  => 'root',
+group  => 'root',
+mode   => '0744',
+}
+
+cron { 'check-private-data':
+minute  => 0,
+hour=> 5,
+weekday => 1,
+user=> 'root',
+command => '/usr/local/sbin/check_private_data_report > /dev/null 
2>&1',
+require => [File['/usr/local/sbin/check_private_data_report'],
+File['/usr/local/sbin/check_private_data.py'],
+],
+}
+
 }

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I7796d6860f70c34b1758655f18a4ed8196724e97
Gerrit-PatchSet: 15
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: Volans 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1064"

2017-02-08 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot, Jcrespo,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1064"
..

Revert "db-eqiad.php: Depool db1064"

db1064 is ready to be repooled

This reverts commit b4afcdfce5112d66f4478ff4554ab6b19af058f6.

Change-Id: If96ac65872e072a9e1232c4a270f3fc4fe2896f3
---
M wmf-config/db-eqiad.php
1 file changed, 6 insertions(+), 6 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 642dda2..a7503bb 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -132,9 +132,9 @@
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1059' => 1,   # C2 2.8TB  96GB, api
-#  'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095
-   'db1068' => 0,   # D1 2.8TB 160GB, #temp vslow, dump #T153743
-   'db1081' => 300, # A2 3.6TB 512GB, #temp api #T153743
+   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
+   'db1068' => 1,   # D1 2.8TB 160GB, api
+   'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
],
@@ -321,14 +321,14 @@
],
's4' => [
'vslow' => [
-   'db1068' => 1,
+   'db1064' => 1,
],
'dump' => [
-   'db1068' => 1,
+   'db1064' => 1,
],
'api' => [
'db1059' => 1,
-   'db1081' => 1,
+   'db1068' => 3,
],
'watchlist' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If96ac65872e072a9e1232c4a270f3fc4fe2896f3
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Add comment for db1064

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336760 )

Change subject: db-eqiad.php: Add comment for db1064
..

db-eqiad.php: Add comment for db1064

db1064 is master for new sanitarium, db1095. Add that comment to its
line to make sure it is visible and not forgotten

Bug: T153743
Change-Id: I9901e75b087f401591bcca51028ec2643394c8e4
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index d230d6c..d8e3a93 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -132,7 +132,7 @@
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1059' => 1,   # C2 2.8TB  96GB, api
-   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
+   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium #T153743
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9901e75b087f401591bcca51028ec2643394c8e4
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Repool db1028

2017-02-09 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336775 )

Change subject: db-eqiad.php: Repool db1028
..

db-eqiad.php: Repool db1028

db1028 finished its ALTER table, so repool it and get db1039 to its
previous state:
https://gerrit.wikimedia.org/r/#/c/336198/1/wmf-config/db-eqiad.php

Bug: T153300
Change-Id: Iedaea9155d5917ce361691fd4116a7ca9312889f
---
M wmf-config/db-eqiad.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index d8e3a93..f2788c4 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -162,9 +162,9 @@
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master
 #  'db1033' => 0,   # B2 1.4TB  64GB, old master
-#  'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump #T153300
+   'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump #T153300
'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1039' => 0,   # B2 1.4TB  64GB, #temp vslow, dump #T153300
+#  'db1039' => 0,   # B2 1.4TB  64GB
'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
'db1086' => 500, # B3 3.6TB 512GB, api
@@ -406,10 +406,10 @@
],
's7' => [
'vslow' => [
-   'db1039' => 1,
+   'db1028' => 1,
],
'dump' => [
-   'db1039' => 1,
+   'db1028' => 1,
],
'api' => [
'db1079' => 100,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iedaea9155d5917ce361691fd4116a7ca9312889f
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1064"

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/336759 )

Change subject: Revert "db-eqiad.php: Depool db1064"
..


Revert "db-eqiad.php: Depool db1064"

db1064 is ready to be repooled

This reverts commit b4afcdfce5112d66f4478ff4554ab6b19af058f6.

Change-Id: If96ac65872e072a9e1232c4a270f3fc4fe2896f3
---
M wmf-config/db-eqiad.php
1 file changed, 6 insertions(+), 6 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 51c1d34..d230d6c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -132,9 +132,9 @@
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1059' => 1,   # C2 2.8TB  96GB, api
-#  'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095
-   'db1068' => 0,   # D1 2.8TB 160GB, #temp vslow, dump #T153743
-   'db1081' => 300, # A2 3.6TB 512GB, #temp api #T153743
+   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump
+   'db1068' => 1,   # D1 2.8TB 160GB, api
+   'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
],
@@ -321,14 +321,14 @@
],
's4' => [
'vslow' => [
-   'db1068' => 1,
+   'db1064' => 1,
],
'dump' => [
-   'db1068' => 1,
+   'db1064' => 1,
],
'api' => [
'db1059' => 1,
-   'db1081' => 1,
+   'db1068' => 3,
],
'watchlist' => [
'db1053' => 1,

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

Gerrit-MessageType: merged
Gerrit-Change-Id: If96ac65872e072a9e1232c4a270f3fc4fe2896f3
Gerrit-PatchSet: 2
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1028"

2017-02-09 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1028"
..

Revert "db-eqiad.php: Depool db1028"

ALTER table is done

This reverts commit 829f9c0362dd7bd376870cbb422e24d6f94a0a46.

Change-Id: I773a13fc37024cabac7ec4d633836a0448c109a6
---
M wmf-config/db-eqiad.php
1 file changed, 4 insertions(+), 4 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 11d7cca..642dda2 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -162,9 +162,9 @@
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master
 #  'db1033' => 0,   # B2 1.4TB  64GB, old master
-#  'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump #T153300
+   'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1039' => 0,   # B2 1.4TB  64GB, #temp vslow, dump #T153300
+#  'db1039' => 0,   # B2 1.4TB  64GB
'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
'db1086' => 500, # B3 3.6TB 512GB, api
@@ -406,10 +406,10 @@
],
's7' => [
'vslow' => [
-   'db1039' => 1,
+   'db1028' => 1,
],
'dump' => [
-   'db1039' => 1,
+   'db1028' => 1,
],
'api' => [
'db1079' => 100,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I773a13fc37024cabac7ec4d633836a0448c109a6
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Repool db1073

2017-02-08 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/336750 )

Change subject: db-eqiad.php: Repool db1073
..

db-eqiad.php: Repool db1073

db1073 was moved to B3 and it is now ready to be repooled

Bug: T156126
Change-Id: I57b95643cec6ff5bc9a9ec510eb089dca470795d
---
M wmf-config/db-eqiad.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 43a8e21..51c1d34 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -100,7 +100,7 @@
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
-#  'db1073' => 50,  # B3 2.8TB 160GB, api #T156126
+   'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
@@ -266,7 +266,7 @@
'api' => [
'db1066' => 1,
'db1072' => 1,
-#  'db1073' => 1,
+   'db1073' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I57b95643cec6ff5bc9a9ec510eb089dca470795d
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/dns[master]: DNS: change db2062 production DNS Bug:T156478

2017-02-14 Thread Marostegui (Code Review) 
Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/337600 )

Change subject: DNS: change db2062 production DNS Bug:T156478
..


DNS: change db2062 production DNS
Bug:T156478

Change-Id: Id4cc0e7b06f7e1329b2cddc8c5b7d6fb057ee556
---
M templates/10.in-addr.arpa
M templates/wmnet
2 files changed, 3 insertions(+), 2 deletions(-)

Approvals:
  Marostegui: Looks good to me, approved
  jenkins-bot: Verified



diff --git a/templates/10.in-addr.arpa b/templates/10.in-addr.arpa
index 44bc7dd..e3caf67 100644
--- a/templates/10.in-addr.arpa
+++ b/templates/10.in-addr.arpa
@@ -2845,6 +2845,7 @@
 192 1H IN PTR   elastic2029.codfw.wmnet.
 193 1H IN PTR   elastic2030.codfw.wmnet.
 194 1H IN PTR   mc2026.codfw.wmnet.
+195  1H IN PTR   db2062.codfw.wmnet.
 
 $ORIGIN 17.192.{{ zonename }}.
 1   1H IN PTR   vl2018-eth1.lvs2001.codfw.wmnet.
@@ -3072,7 +3073,7 @@
 11  1H IN PTR   db2059.codfw.wmnet.
 12  1H IN PTR   db2060.codfw.wmnet.
 13  1H IN PTR   db2061.codfw.wmnet.
-14  1H IN PTR   db2062.codfw.wmnet.
+
 15  1H IN PTR   db2063.codfw.wmnet.
 16  1H IN PTR   db2064.codfw.wmnet.
 17  1H IN PTR   db2065.codfw.wmnet.
diff --git a/templates/wmnet b/templates/wmnet
index daec32a..c666d31 100644
--- a/templates/wmnet
+++ b/templates/wmnet
@@ -2378,7 +2378,7 @@
 db2059  1H  IN A10.192.48.11
 db2060  1H  IN A10.192.48.12
 db2061  1H  IN A10.192.48.13
-db2062  1H  IN A10.192.48.14
+db2062  1H  IN A10.192.16.195
 db2063  1H  IN A10.192.48.15
 db2064  1H  IN A10.192.48.16
 db2065  1H  IN A10.192.48.17

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Id4cc0e7b06f7e1329b2cddc8c5b7d6fb057ee556
Gerrit-PatchSet: 2
Gerrit-Project: operations/dns
Gerrit-Branch: master
Gerrit-Owner: Papaul 
Gerrit-Reviewer: Dzahn 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw, db-eqiad.php: Change db2062 IP

2017-02-14 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/337597 )

Change subject: db-codfw,db-eqiad.php: Change db2062 IP
..

db-codfw,db-eqiad.php: Change db2062 IP

db2062 has been moved to B5 and needs to get a new IP.

Bug: T156478
Change-Id: I9601e1da1a4a5da6836735eb7b4f78aebb23
---
M wmf-config/db-codfw.php
M wmf-config/db-eqiad.php
2 files changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1d484b4..b4daad5 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -548,7 +548,7 @@
'db2059' => '10.192.48.11', # do not remove or comment out
'db2060' => '10.192.48.12', # do not remove or comment out
'db2061' => '10.192.48.13', # do not remove or comment out
-   'db2062' => '10.192.48.14', # do not remove or comment out
+   'db2062' => '10.192.16.195', # do not remove or comment out
'db2063' => '10.192.48.15', # do not remove or comment out
'db2064' => '10.192.48.16', # do not remove or comment out
'db2065' => '10.192.48.17', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f2788c4..df93998 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -575,7 +575,7 @@
'db2059' => '10.192.48.11', # do not remove or comment out
'db2060' => '10.192.48.12', # do not remove or comment out
'db2061' => '10.192.48.13', # do not remove or comment out
-   'db2062' => '10.192.48.14', # do not remove or comment out
+   'db2062' => '10.192.16.195', # do not remove or comment out
'db2063' => '10.192.48.15', # do not remove or comment out
'db2064' => '10.192.48.16', # do not remove or comment out
'db2065' => '10.192.48.17', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9601e1da1a4a5da6836735eb7b4f78aebb23
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Repool db2062

2017-02-14 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/33 )

Change subject: db-codfw.php: Repool db2062
..

db-codfw.php: Repool db2062

db2062 was moved to a different rack and it has caught up already so it
is ready to be repooled.

Bug: T156478
Change-Id: Ied190db4117d4578d1966f437a4ae839efe7c6d8
---
M wmf-config/db-codfw.php
1 file changed, 2 insertions(+), 2 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index b4daad5..554f8f3 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -98,7 +98,7 @@
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2048' => 400, # C6 2.9TB 160GB
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-#  'db2062' => 100, # B5 3.3TB 160GB, api #T156478
+   'db2062' => 100, # B5 3.3TB 160GB, api
'db2069' => 100, # D6 3.3TB 160GB, api
'db2070' => 400, # D6 3.3TB 160GB
],
@@ -244,7 +244,7 @@
'db2055' => 1,
],
'api' => [
-#  'db2062' => 1,
+   'db2062' => 1,
'db2069' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ied190db4117d4578d1966f437a4ae839efe7c6d8
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1077

2017-02-13 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/337368 )

Change subject: db-eqiad.php: Depool db1077
..

db-eqiad.php: Depool db1077

db1077 needs an ALTER table

Bug: T136428
Change-Id: I3bdc345fb425d2ef25820e169d5dea91791d3938
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f2788c4..8b9fd7e 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -124,7 +124,7 @@
'db1015' => 1,   # A2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1035' => 0,   # B2 1.4TB  64GB
 #  'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
-   'db1077' => 500, # B1 3.6TB 512GB
+#  'db1077' => 500, # B1 3.6TB 512GB #T136428
'db1078' => 500, # C3 3.6TB 512GB
],
's4' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I3bdc345fb425d2ef25820e169d5dea91791d3938
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1077"

2017-02-13 Thread Marostegui (Code Review) 
Hello jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1077"
..

Revert "db-eqiad.php: Depool db1077"

This reverts commit 79a8d0a00ef5c4359000df917fae48e62c187ae3.

Change-Id: Ia41c171c4103e3ea0866d8e4c038b7de93fa9892
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8b9fd7e..f2788c4 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -124,7 +124,7 @@
'db1015' => 1,   # A2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1035' => 0,   # B2 1.4TB  64GB
 #  'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
-#  'db1077' => 500, # B1 3.6TB 512GB #T136428
+   'db1077' => 500, # B1 3.6TB 512GB
'db1078' => 500, # C3 3.6TB 512GB
],
's4' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia41c171c4103e3ea0866d8e4c038b7de93fa9892
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1078

2017-02-13 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/337371 )

Change subject: db-eqiad.php: Depool db1078
..

db-eqiad.php: Depool db1078

db1078 needs an ALTER table

Bug: T136428
Change-Id: I1a8ee8d0d427122f8a65fff7dc9f5d1488a597f0
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f2788c4..987bc10 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -125,7 +125,7 @@
 #  'db1035' => 0,   # B2 1.4TB  64GB
 #  'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
'db1077' => 500, # B1 3.6TB 512GB
-   'db1078' => 500, # C3 3.6TB 512GB
+#  'db1078' => 500, # C3 3.6TB 512GB
],
's4' => [
'db1040' => 0,   # B2 1.4TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I1a8ee8d0d427122f8a65fff7dc9f5d1488a597f0
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: Revert "db-eqiad.php: Depool db1078"

2017-02-13 Thread Marostegui (Code Review) 
Hello jenkins-bot,

I'd like you to do a code review.  Please visit

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1078"
..

Revert "db-eqiad.php: Depool db1078"

This reverts commit cb8b6c54db1cba54109fd65acd78559f658a3e02.

Change-Id: I279dcac3cf08341465e49e709b9686c00ac9c3e5
---
M wmf-config/db-eqiad.php
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 987bc10..f2788c4 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -125,7 +125,7 @@
 #  'db1035' => 0,   # B2 1.4TB  64GB
 #  'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
'db1077' => 500, # B1 3.6TB 512GB
-#  'db1078' => 500, # C3 3.6TB 512GB
+   'db1078' => 500, # C3 3.6TB 512GB
],
's4' => [
'db1040' => 0,   # B2 1.4TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I279dcac3cf08341465e49e709b9686c00ac9c3e5
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: jenkins-bot <>

___
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

  1   2   3   4   5   6   7   8   9   10   >