from:"Marostegui \(Code Review\)"

[MediaWiki-commits] [Gerrit] operations/puppet[production]: db1055.yaml: Update socket location

2017-08-01 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/369400 )

Change subject: db1055.yaml: Update socket location
..


db1055.yaml: Update socket location

db1055 was out for maintenance so taking the opportunity to update its
socket location

Bug: T148507
Change-Id: I1741d28224040d29189925dddac7f5834562b6bb
---
M hieradata/hosts/db1055.yaml
1 file changed, 0 insertions(+), 1 deletion(-)

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



diff --git a/hieradata/hosts/db1055.yaml b/hieradata/hosts/db1055.yaml
index b1bf6dc..e60febc 100644
--- a/hieradata/hosts/db1055.yaml
+++ b/hieradata/hosts/db1055.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's1'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I1741d28224040d29189925dddac7f5834562b6bb
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Giuseppe Lavagetto 
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]: s3.hosts: Add db2074 to s3 list

2017-08-01 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/369389 )

Change subject: s3.hosts: Add db2074 to s3 list
..

s3.hosts: Add db2074 to s3 list

db2074 is now replicating s3

Bug: T170662
Change-Id: If8fddb6f4c6dece6082da024c8da23fcd8d7329d
---
M dbtools/s3.hosts
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/89/369389/1

diff --git a/dbtools/s3.hosts b/dbtools/s3.hosts
index 256611b..39b3294 100644
--- a/dbtools/s3.hosts
+++ b/dbtools/s3.hosts
@@ -1,4 +1,5 @@
 dbstore2001.codfw.wmnet3306
+db2074.codfw.wmnet 3306
 db2036.codfw.wmnet 3306
 db2043.codfw.wmnet 3306
 db2050.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If8fddb6f4c6dece6082da024c8da23fcd8d7329d
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]: mariadb: Add db2073 to s4

2017-07-31 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/368804 )

Change subject: mariadb: Add db2073 to s4
..


mariadb: Add db2073 to s4

db2073 will soon be added to s4 in codfw

Bug: T170662
Change-Id: I1175689274bf8145028da7f4cde48dd14fe8160d
---
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_codfw.yaml
2 files changed, 2 insertions(+), 1 deletion(-)

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



diff --git a/manifests/site.pp b/manifests/site.pp
index 2bc166c..f0819bc 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -388,7 +388,7 @@
 }
 
 # codfw replicas
-node /^db20(16|34|42|55|62|69|70|71|72)\.codfw\.wmnet/ {
+node /^db20(16|34|42|55|62|69|70|71|72|73)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index a474858..1c5ddbb 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -56,6 +56,7 @@
   - db2051:9104
   - db2058:9104
   - db2065:9104
+  - db2073:9104
 - labels:
 shard: s4
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I1175689274bf8145028da7f4cde48dd14fe8160d
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Giuseppe Lavagetto 
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]: mariadb: db2073 is going to s4, not s1

2017-07-31 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/368980 )

Change subject: mariadb: db2073 is going to s4, not s1
..

mariadb: db2073 is going to s4, not s1

Change-Id: I1b6abc300b334b11ab596940349b6fc7cbad6fc1
---
M manifests/site.pp
1 file changed, 2 insertions(+), 2 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/80/368980/1

diff --git a/manifests/site.pp b/manifests/site.pp
index f0819bc..ef8acc7 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -388,7 +388,7 @@
 }
 
 # codfw replicas
-node /^db20(16|34|42|55|62|69|70|71|72|73)\.codfw\.wmnet/ {
+node /^db20(16|34|42|55|62|69|70|71|72)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 
@@ -460,7 +460,7 @@
 role(mariadb::core)
 }
 
-node /^db20(37|44|51|58|65)\.codfw\.wmnet/ {
+node /^db20(37|44|51|58|65|73)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I1b6abc300b334b11ab596940349b6fc7cbad6fc1
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: db2073 is going to s4, not s1

2017-07-31 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/368980 )

Change subject: mariadb: db2073 is going to s4, not s1
..


mariadb: db2073 is going to s4, not s1

Change-Id: I1b6abc300b334b11ab596940349b6fc7cbad6fc1
---
M manifests/site.pp
1 file changed, 2 insertions(+), 2 deletions(-)

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



diff --git a/manifests/site.pp b/manifests/site.pp
index f0819bc..ef8acc7 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -388,7 +388,7 @@
 }
 
 # codfw replicas
-node /^db20(16|34|42|55|62|69|70|71|72|73)\.codfw\.wmnet/ {
+node /^db20(16|34|42|55|62|69|70|71|72)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 
@@ -460,7 +460,7 @@
 role(mariadb::core)
 }
 
-node /^db20(37|44|51|58|65)\.codfw\.wmnet/ {
+node /^db20(37|44|51|58|65|73)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I1b6abc300b334b11ab596940349b6fc7cbad6fc1
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
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]: mariadb: db2073 yaml file for s4

2017-07-31 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/368981 )

Change subject: mariadb: db2073 yaml file for s4
..

mariadb: db2073 yaml file for s4

db2073 is going to be provisioned on s4

Change-Id: I1b9153a4fbddfd43afe37bc05f679d886aeb8269
---
A hieradata/hosts/db2073.yaml
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/81/368981/1

diff --git a/hieradata/hosts/db2073.yaml b/hieradata/hosts/db2073.yaml
new file mode 100644
index 000..7db8adb
--- /dev/null
+++ b/hieradata/hosts/db2073.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's4'

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I1b9153a4fbddfd43afe37bc05f679d886aeb8269
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: db2073 yaml file for s4

2017-07-31 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/368981 )

Change subject: mariadb: db2073 yaml file for s4
..


mariadb: db2073 yaml file for s4

db2073 is going to be provisioned on s4

Change-Id: I1b9153a4fbddfd43afe37bc05f679d886aeb8269
---
A hieradata/hosts/db2073.yaml
1 file changed, 1 insertion(+), 0 deletions(-)

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



diff --git a/hieradata/hosts/db2073.yaml b/hieradata/hosts/db2073.yaml
new file mode 100644
index 000..7db8adb
--- /dev/null
+++ b/hieradata/hosts/db2073.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's4'

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I1b9153a4fbddfd43afe37bc05f679d886aeb8269
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
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]: s4.hosts: Add db2073

2017-08-01 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/368982 )

Change subject: s4.hosts: Add db2073
..

s4.hosts: Add db2073

db2073 will be part of s4

Bug: T170662
Change-Id: I3b23072dc59dbdd92882218426b3f7435b917d3e
---
M dbtools/s4.hosts
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/82/368982/1

diff --git a/dbtools/s4.hosts b/dbtools/s4.hosts
index 4fa0811..6eb5efc 100644
--- a/dbtools/s4.hosts
+++ b/dbtools/s4.hosts
@@ -1,4 +1,5 @@
 dbstore2001.codfw.wmnet3306
+db2073.codfw.wmnet 3306
 db2065.codfw.wmnet 3306
 db2058.codfw.wmnet 3306
 db2051.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I3b23072dc59dbdd92882218426b3f7435b917d3e
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.php: Depool db2065

2017-08-01 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/368983 )

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

db-codfw.php: Depool db2065

db2065 is going to be used to populate db2073 on s4

Bug: T170662
Change-Id: Ifd12bb393b27bc38fc98119e5bf9ba50851ff619
---
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/83/368983/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 489e5ec..dbd05c0 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -126,7 +126,7 @@
'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
+   # 'db2065' => 400, # D6 3.3TB 160GB #T170662
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifd12bb393b27bc38fc98119e5bf9ba50851ff619
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, db-codfw.php: Change db2051 IP

2017-08-02 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/369673 )

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

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

db2051 is being moved to B8, so it needs its IP changed

Bug: T169501
Change-Id: I55a179f4d4d5ef58f2cc80c82a905656a140a46e
---
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/73/369673/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 431a720..b51e015 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -548,7 +548,7 @@
'db2048' => '10.192.32.108', # do not remove or comment out
'db2049' => '10.192.32.109', # do not remove or comment out
'db2050' => '10.192.32.110', # do not remove or comment out
-   'db2051' => '10.192.32.111', # do not remove or comment out
+   'db2051' => '10.192.16.22', # do not remove or comment out
'db2052' => '10.192.48.4', # do not remove or comment out
'db2053' => '10.192.48.5', # do not remove or comment out
'db2054' => '10.192.48.6', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 53bcfb1..feb5d80 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -565,7 +565,7 @@
'db2048' => '10.192.32.108', # do not remove or comment out
'db2049' => '10.192.32.109', # do not remove or comment out
'db2050' => '10.192.32.110', # do not remove or comment out
-   'db2051' => '10.192.32.111', # do not remove or comment out
+   'db2051' => '10.192.16.22', # do not remove or comment out
'db2052' => '10.192.48.4', # do not remove or comment out
'db2053' => '10.192.48.5', # do not remove or comment out
'db2054' => '10.192.48.6', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I55a179f4d4d5ef58f2cc80c82a905656a140a46e
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 production DNS for db2051

2017-08-02 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/369675 )

Change subject: DNS: Change production DNS for db2051
..


DNS: Change production DNS for db2051

Bug:T169501
Change-Id: Ie8016dd8415d91f78971380ea591b334dd3d06c8
---
M templates/10.in-addr.arpa
M templates/wmnet
2 files changed, 3 insertions(+), 3 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 c20322c..080da07 100644
--- a/templates/10.in-addr.arpa
+++ b/templates/10.in-addr.arpa
@@ -2985,7 +2985,7 @@
 19  1H IN PTR   db2031.codfw.wmnet.
 20  1H IN PTR   db2032.codfw.wmnet.
 21  1H IN PTR   poolcounter2002.codfw.wmnet. ; VM on ganeti01.svc.codfw.wmnet
-
+22  1H IN PTR   db2051.codfw.wmnet.
 25  1H IN PTR   tureis.codfw.wmnet. ; VM on the ganeti01.svc.codfw.wmnet 
cluster
 26  1H IN PTR   acrab.codfw.wmnet. ; VM on the ganeti01.svc.codfw.wmnet cluster
 27  1H IN PTR   es2003.codfw.wmnet.
@@ -3294,7 +3294,7 @@
 108 1H IN PTR   db2048.codfw.wmnet.
 109 1H IN PTR   db2049.codfw.wmnet.
 110 1H IN PTR   db2050.codfw.wmnet.
-111 1H IN PTR   db2051.codfw.wmnet.
+
 112 1H IN PTR   cp2013.codfw.wmnet.
 113 1H IN PTR   cp2014.codfw.wmnet.
 114 1H IN PTR   cp2015.codfw.wmnet.
diff --git a/templates/wmnet b/templates/wmnet
index cf3f473..3e3f44a 100644
--- a/templates/wmnet
+++ b/templates/wmnet
@@ -2601,7 +2601,7 @@
 db2048  1H  IN A10.192.32.108
 db2049  1H  IN A10.192.32.109
 db2050  1H  IN A10.192.32.110
-db2051  1H  IN A10.192.32.111
+db2051  1H  IN A10.192.16.22
 db2052  1H  IN A10.192.48.4
 db2053  1H  IN A10.192.48.5
 db2054  1H  IN A10.192.48.6

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ie8016dd8415d91f78971380ea591b334dd3d06c8
Gerrit-PatchSet: 1
Gerrit-Project: operations/dns
Gerrit-Branch: master
Gerrit-Owner: Papaul 
Gerrit-Reviewer: Dzahn 
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]: mariadb: Add db2074 as a new slave for s3

2017-08-01 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/368985 )

Change subject: mariadb: Add db2074 as a new slave for s3
..


mariadb: Add db2074 as a new slave for s3

db2074 will be added to s3

Bug: T170662
Change-Id: Idf57b022f88fba28bc673719562112b8145a18ac
---
A hieradata/hosts/db2074.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_codfw.yaml
3 files changed, 3 insertions(+), 1 deletion(-)

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



diff --git a/hieradata/hosts/db2074.yaml b/hieradata/hosts/db2074.yaml
new file mode 100644
index 000..654805a
--- /dev/null
+++ b/hieradata/hosts/db2074.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's3'
diff --git a/manifests/site.pp b/manifests/site.pp
index ef8acc7..b70d3ee 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -435,7 +435,7 @@
 role(mariadb::core)
 }
 
-node /^db20(36|43|50|57)\.codfw\.wmnet/ {
+node /^db20(36|43|50|57|74)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index 1c5ddbb..677e216 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -41,6 +41,7 @@
   - db2043:9104
   - db2050:9104
   - db2057:9104
+  - db2074:9104
 - labels:
 shard: s3
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Idf57b022f88fba28bc673719562112b8145a18ac
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Giuseppe Lavagetto 
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 db2057

2017-08-01 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/369335 )

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

db-codfw.php: Depool db2057

db2057 is going to transfer its data to db2074

Bug: T170662
Change-Id: I86c3630279efc12a07180135e27e668c95b38219
---
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/35/369335/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 489e5ec..6bfcaeb 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -118,7 +118,7 @@
'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
+   # 'db2057' => 400, # D6 3.3TB 160GB # T170662
],
's4' => [
'db2019' => 0,   # B6 2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I86c3630279efc12a07180135e27e668c95b38219
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 db2046"

2017-08-09 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/370919

to review the following change.


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

Revert "db-codfw.php: Depool db2046"

This reverts commit 554557000c4f781b60011749048839739b216f69.

Change-Id: Ie38f8a81e1b04ad2ba1fe7a01c46d5fe873cfaf5
---
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/370919/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 7afee2f..027b310 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -142,7 +142,7 @@
's6' => [
'db2028' => 0,   # B6  2.9TB  96GB, master
'db2039' => 50,  # C6 2.9TB 160GB, rc, log
-   # 'db2046' => 400, # C6 2.9TB 160GB # T170662
+   '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

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie38f8a81e1b04ad2ba1fe7a01c46d5fe873cfaf5
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/puppet[production]: mariadb: Add db2076 as s6 slave

2017-08-09 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/370805 )

Change subject: mariadb: Add db2076 as s6 slave
..


mariadb: Add db2076 as s6 slave

db2076 will be added to s6

Bug: T170662
Change-Id: I46b2a3372b9cd81c33544b82a13419bb7f7f79fe
---
A hieradata/hosts/db2076.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_codfw.yaml
3 files changed, 3 insertions(+), 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/hieradata/hosts/db2076.yaml b/hieradata/hosts/db2076.yaml
new file mode 100644
index 000..7308ffb
--- /dev/null
+++ b/hieradata/hosts/db2076.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's6'
diff --git a/manifests/site.pp b/manifests/site.pp
index 1ddb1c0..d3c1c62 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -512,7 +512,7 @@
 role(mariadb::core)
 }
 
-node /^db20(39|46|53|60|67)\.codfw\.wmnet/ {
+node /^db20(39|46|53|60|67|76)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index ef335d5..11259ec 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -89,6 +89,7 @@
   - db2053:9104
   - db2060:9104
   - db2067:9104
+  - db2076:9104
 - labels:
 shard: s6
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I46b2a3372b9cd81c33544b82a13419bb7f7f79fe
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Giuseppe Lavagetto 
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]: s6.host: Add db2076 to s6

2017-08-09 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370959 )

Change subject: s6.host: Add db2076 to s6
..

s6.host: Add db2076 to s6

db2076 is going to be a new slave on s6

Bug: T170662
Change-Id: I30a21b17469050e504915d1b2eb514ccd7c28cab
---
M dbtools/s6.hosts
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/59/370959/1

diff --git a/dbtools/s6.hosts b/dbtools/s6.hosts
index 6c398e5..3e862cc 100644
--- a/dbtools/s6.hosts
+++ b/dbtools/s6.hosts
@@ -1,4 +1,5 @@
 dbstore2001.codfw.wmnet3306
+db2076.codfw.wmnet 3306
 db2039.codfw.wmnet 3306
 db2046.codfw.wmnet 3306
 db2053.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I30a21b17469050e504915d1b2eb514ccd7c28cab
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]: db2045.yaml: Update socket location

2017-08-09 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370958 )

Change subject: db2045.yaml: Update socket location
..

db2045.yaml: Update socket location

Given that db2045 is depooled, taking the opportunity to update its
socket location

Bug: T148507
Change-Id: Ib652c1546970bc2f41a54d3a3bb0af2c0eccf6d3
---
M hieradata/hosts/db2045.yaml
1 file changed, 0 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/58/370958/1

diff --git a/hieradata/hosts/db2045.yaml b/hieradata/hosts/db2045.yaml
index 987af0e..0d8bce2 100644
--- a/hieradata/hosts/db2045.yaml
+++ b/hieradata/hosts/db2045.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's5'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib652c1546970bc2f41a54d3a3bb0af2c0eccf6d3
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, db-codfw.php: Add db2075 to s5 shard

2017-08-09 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370801 )

Change subject: db-eqiad,db-codfw.php: Add db2075 to s5 shard
..

db-eqiad,db-codfw.php: Add db2075 to s5 shard

db2075 will be a new slave in s5 shard.
It is finishing InnoDB compression, so that is why it is not pooled yet.

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 5fe0419..027b310 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -137,6 +137,7 @@
'db2052' => 50,  # D6 2.9TB 160GB, dump (inactive), vslow
'db2059' => 100, # D6 3.3TB 160GB, api
'db2066' => 400, # D6 3.3TB 160GB
+   # 'db2075' => 400, # A1 3.3TB 512GB # Compressing InnoDB
],
's6' => [
'db2028' => 0,   # B6  2.9TB  96GB, master
@@ -574,6 +575,7 @@
'db2072' => '10.192.16.37', # do not remove or comment out
'db2073' => '10.192.32.167', # do not remove or comment out
'db2074' => '10.192.48.84', # do not remove or comment out
+   'db2075' => '10.192.0.5', # do not remove or comment out
'virt1000' => '208.80.154.18', # do not remove or comment out
'silver' => '208.80.154.136', # do not remove or comment out
'labtestweb2001' => '208.80.153.14', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a10f0cf..902b5d4 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -596,6 +596,7 @@
'db2072' => '10.192.16.37', # do not remove or comment out
'db2073' => '10.192.32.167', # do not remove or comment out
'db2074' => '10.192.48.84', # do not remove or comment out
+   'db2075' => '10.192.0.5', # do not remove or comment out
'virt1000' => '208.80.154.18', # do not remove or comment out
'silver' => '208.80.154.136', # do not remove or comment out
'labtestweb2001' => '208.80.153.14', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibf5d32bf8e9e1b2773f706d1dfe47069a53e07d6
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 db2076 as s6 slave

2017-08-09 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370805 )

Change subject: mariadb: Add db2076 as s6 slave
..

mariadb: Add db2076 as s6 slave

db2076 will be added to s6

Bug: T170662
Change-Id: I46b2a3372b9cd81c33544b82a13419bb7f7f79fe
---
A hieradata/hosts/db2076.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_codfw.yaml
3 files changed, 3 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/05/370805/1

diff --git a/hieradata/hosts/db2076.yaml b/hieradata/hosts/db2076.yaml
new file mode 100644
index 000..7308ffb
--- /dev/null
+++ b/hieradata/hosts/db2076.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's6'
diff --git a/manifests/site.pp b/manifests/site.pp
index 1ddb1c0..d3c1c62 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -512,7 +512,7 @@
 role(mariadb::core)
 }
 
-node /^db20(39|46|53|60|67)\.codfw\.wmnet/ {
+node /^db20(39|46|53|60|67|76)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index ef335d5..11259ec 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -89,6 +89,7 @@
   - db2053:9104
   - db2060:9104
   - db2067:9104
+  - db2076:9104
 - labels:
 shard: s6
 role: master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I46b2a3372b9cd81c33544b82a13419bb7f7f79fe
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-codfw.php: Depool db2046

2017-08-09 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370813 )

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

db-codfw.php: Depool db2046

db2046 is going to be use to populate db2076

Bug: T170662
Change-Id: Ica803b6b6aef9f36b50fb4617afdc4a594398cdc
---
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/13/370813/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 027b310..7afee2f 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -142,7 +142,7 @@
's6' => [
'db2028' => 0,   # B6  2.9TB  96GB, master
'db2039' => 50,  # C6 2.9TB 160GB, rc, log
-   'db2046' => 400, # C6 2.9TB 160GB
+   # 'db2046' => 400, # C6 2.9TB 160GB # T170662
'db2053' => 100, # D6 2.9TB 160GB, dump (inactive), vslow
'db2060' => 100, # D6 3.3TB 160GB, api
'db2067' => 400, # D6 3.3TB 160GB

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ica803b6b6aef9f36b50fb4617afdc4a594398cdc
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 db2074"

2017-08-07 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/370457

to review the following change.


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

Revert "db-codfw.php: Depool db2074"

This reverts commit b8dc5dd1a5f7bbfb175477824aedd93a6ab5bbf4.

Change-Id: I08df5066860da7208175f638b9bd3f2d877382b7
---
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/57/370457/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index e6ba1f8..c386309 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -119,7 +119,7 @@
'db2043' => 50,  # C6 2.9TB 160GB, dump (inactive), vslow
'db2050' => 150, # C6 2.9TB 160GB, api
'db2057' => 400, # D6 3.3TB 160GB
-   # 'db2074' => 400, # D6 3.3TB 512GB # InnoDB compressed #T171321
+   'db2074' => 400, # D6 3.3TB 512GB # InnoDB compressed
],
's4' => [
'db2051' => 0,   # B8 2.9TB 160GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I08df5066860da7208175f638b9bd3f2d877382b7
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/software[master]: s3.hosts: dbstore2002 is now replicating s3

2017-08-07 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370448 )

Change subject: s3.hosts: dbstore2002 is now replicating s3
..

s3.hosts: dbstore2002 is now replicating s3

Bug: T171321
Change-Id: I6e29a33572643fd2099a79e62c580aa13bd0
---
M dbtools/s3.hosts
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/48/370448/1

diff --git a/dbtools/s3.hosts b/dbtools/s3.hosts
index 39b3294..3014ea7 100644
--- a/dbtools/s3.hosts
+++ b/dbtools/s3.hosts
@@ -1,4 +1,5 @@
 dbstore2001.codfw.wmnet3306
+dbstore2002.codfw.wmnet3313
 db2074.codfw.wmnet 3306
 db2036.codfw.wmnet 3306
 db2043.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6e29a33572643fd2099a79e62c580aa13bd0
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]: mariadb: dbstore2002 has now 5 shards replicating

2017-08-07 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370449 )

Change subject: mariadb: dbstore2002 has now 5 shards replicating
..

mariadb: dbstore2002 has now 5 shards replicating

Bug: T171321
Change-Id: Ia050d88ae041b0969b196f0fe94f7b5b90a71b44
---
M modules/role/manifests/mariadb/dbstore_multiinstance.pp
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/modules/role/manifests/mariadb/dbstore_multiinstance.pp 
b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
index 8f425d9..3011932 100644
--- a/modules/role/manifests/mariadb/dbstore_multiinstance.pp
+++ b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
@@ -103,7 +103,7 @@
 }
 
 class { 'mariadb::monitor_process':
-process_count => 4,
+process_count => 5,
 is_critical   => false,
 contact_group => 'admins',
 }

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia050d88ae041b0969b196f0fe94f7b5b90a71b44
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: dbstore2002 has now 5 shards replicating

2017-08-07 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/370449 )

Change subject: mariadb: dbstore2002 has now 5 shards replicating
..


mariadb: dbstore2002 has now 5 shards replicating

Bug: T171321
Change-Id: Ia050d88ae041b0969b196f0fe94f7b5b90a71b44
---
M modules/role/manifests/mariadb/dbstore_multiinstance.pp
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/manifests/mariadb/dbstore_multiinstance.pp 
b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
index 8f425d9..3011932 100644
--- a/modules/role/manifests/mariadb/dbstore_multiinstance.pp
+++ b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
@@ -103,7 +103,7 @@
 }
 
 class { 'mariadb::monitor_process':
-process_count => 4,
+process_count => 5,
 is_critical   => false,
 contact_group => 'admins',
 }

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ia050d88ae041b0969b196f0fe94f7b5b90a71b44
Gerrit-PatchSet: 1
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]: s5.hosts: Add db2075 as a new slave

2017-08-03 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/369875 )

Change subject: s5.hosts: Add db2075 as a new slave
..


s5.hosts: Add db2075 as a new slave

db2075 is going to be a slave in s5

Bug: T170662
Change-Id: I032a05c94fbb6641a1d7699b6d5c6aaf1a932342
---
M dbtools/s5.hosts
1 file changed, 1 insertion(+), 0 deletions(-)

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



diff --git a/dbtools/s5.hosts b/dbtools/s5.hosts
index 73465f2..1499896 100644
--- a/dbtools/s5.hosts
+++ b/dbtools/s5.hosts
@@ -1,4 +1,5 @@
 dbstore2001.codfw.wmnet3306
+db2075.codfw.wmnet 3306
 db2038.codfw.wmnet 3306
 db2045.codfw.wmnet 3306
 db2052.codfw.wmnet 3306

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I032a05c94fbb6641a1d7699b6d5c6aaf1a932342
Gerrit-PatchSet: 1
Gerrit-Project: operations/software
Gerrit-Branch: master
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/software[master]: s4.hosts: db2051 is now s4 codfw master

2017-08-03 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/369877 )

Change subject: s4.hosts: db2051 is now s4 codfw master
..

s4.hosts: db2051 is now s4 codfw master

Move it within the list to reflect that it is the master in codfw

Bug: T170351
Change-Id: I8810f59760f1dfcf38780cc8052683dc407ed3ba
---
M dbtools/s4.hosts
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/77/369877/1

diff --git a/dbtools/s4.hosts b/dbtools/s4.hosts
index 6eb5efc..ee44105 100644
--- a/dbtools/s4.hosts
+++ b/dbtools/s4.hosts
@@ -2,10 +2,10 @@
 db2073.codfw.wmnet 3306
 db2065.codfw.wmnet 3306
 db2058.codfw.wmnet 3306
-db2051.codfw.wmnet 3306
 db2044.codfw.wmnet 3306
 db2037.codfw.wmnet 3306
 db2019.codfw.wmnet 3306
+db2051.codfw.wmnet 3306
 labsdb1001.eqiad.wmnet 3306
 labsdb1003.eqiad.wmnet 3306
 db1069.eqiad.wmnet 3314

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8810f59760f1dfcf38780cc8052683dc407ed3ba
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]: mariadb: Promote db2051 as the new s4 codfw master

2017-08-03 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/369880 )

Change subject: mariadb: Promote db2051 as the new s4 codfw master
..

mariadb: Promote db2051 as the new s4 codfw master

db2051 will replace db2019 as new codfw s4 master

Bug: T170351
Change-Id: I809f45c64a2d88603b286b7abdc2745ad16a4781
---
M hieradata/hosts/db2019.yaml
M hieradata/hosts/db2051.yaml
M manifests/site.pp
3 files changed, 4 insertions(+), 5 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/80/369880/1

diff --git a/hieradata/hosts/db2019.yaml b/hieradata/hosts/db2019.yaml
index 196962b..7db8adb 100644
--- a/hieradata/hosts/db2019.yaml
+++ b/hieradata/hosts/db2019.yaml
@@ -1,4 +1 @@
 mariadb::shard: 's4'
-mariadb::mysql_role: 'master'
-mariadb::binlog_format: 'STATEMENT'
-mariadb::socket: '/tmp/mysql.sock'
diff --git a/hieradata/hosts/db2051.yaml b/hieradata/hosts/db2051.yaml
index 7db8adb..a816436 100644
--- a/hieradata/hosts/db2051.yaml
+++ b/hieradata/hosts/db2051.yaml
@@ -1 +1,3 @@
 mariadb::shard: 's4'
+mariadb::mysql_role: 'master'
+mariadb::binlog_format: 'STATEMENT'
diff --git a/manifests/site.pp b/manifests/site.pp
index bd2fd9f..9445c25 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -463,11 +463,11 @@
 
 # s4 (commons) core production dbs on codfw
 # codfw master
-node 'db2019.codfw.wmnet' {
+node 'db2051.codfw.wmnet' {
 role(mariadb::core)
 }
 
-node /^db20(37|44|51|58|65|73)\.codfw\.wmnet/ {
+node /^db20(19|37|44|58|65|73)\.codfw\.wmnet/ {
 role(mariadb::core)
 }
 

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I809f45c64a2d88603b286b7abdc2745ad16a4781
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] mediawiki/core[master]: tables.sql: Convert UNIQUE keys into PK

2017-08-04 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370190 )

Change subject: tables.sql: Convert UNIQUE keys into PK
..

tables.sql: Convert UNIQUE keys into PK

DBAs have been doing a massive effort to convert UNIQUE KEYS into
PRIMARY KEY.

Having a PK is essential to do maintenance, specially on large tasks.
By not having a PK it is impossible to add it in a safe way if not done
directly on the master.
During the DC switchover we took the opportunity to get the PKs added on
the master and some months after that we have finished all the slaves.

Having a PK means that we can easily change the PK into another one if
needed in the future. The ones we chose might not be the best ones, but
will allow us to get them changed.

This patch reflects the change in tables.sql so the new wikis that get
created will get the same PKs that we have deployed across the board.

Bug: T17441
Change-Id: Id635297838938c7c5dfe65d45285a4d16d65152d
---
M maintenance/tables.sql
1 file changed, 23 insertions(+), 35 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core 
refs/changes/90/370190/1

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 14f6932..071272e 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -178,10 +178,9 @@
 CREATE TABLE /*_*/user_former_groups (
   -- Key to user_id
   ufg_user int unsigned NOT NULL default 0,
-  ufg_group varbinary(255) NOT NULL default ''
+  ufg_group varbinary(255) NOT NULL default '',
+  PRIMARY KEY (ufg_user,ufg_group)
 ) /*$wgDBTableOptions*/;
-
-CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups 
(ufg_user,ufg_group);
 
 --
 -- Stores notifications of user talk page changes, for the display
@@ -220,10 +219,10 @@
   up_property varbinary(255) NOT NULL,
 
   -- Property value as a string.
-  up_value blob
+  up_value blob,
+  PRIMARY KEY (up_user,up_property)
 ) /*$wgDBTableOptions*/;
 
-CREATE UNIQUE INDEX /*i*/user_properties_user_property ON /*_*/user_properties 
(up_user,up_property);
 CREATE INDEX /*i*/user_properties_property ON /*_*/user_properties 
(up_property);
 
 --
@@ -552,7 +551,8 @@
   -- and deletions may refer to different page records as time
   -- goes by.
   pl_namespace int NOT NULL default 0,
-  pl_title varchar(255) binary NOT NULL default ''
+  pl_title varchar(255) binary NOT NULL default '',
+  PRIMARY KEY (pl_from,pl_namespace,pl_title)
 ) /*$wgDBTableOptions*/;
 
 -- Forward index, for page edit, save
@@ -579,7 +579,8 @@
   -- and deletions may refer to different page records as time
   -- goes by.
   tl_namespace int NOT NULL default 0,
-  tl_title varchar(255) binary NOT NULL default ''
+  tl_title varchar(255) binary NOT NULL default '',
+  PRIMARY KEY (tl_from,tl_namespace,tl_title)
 ) /*$wgDBTableOptions*/;
 
 -- Forward index, for page edit, save
@@ -606,11 +607,9 @@
   -- Filename of target image.
   -- This is also the page_title of the file's description page;
   -- all such pages are in namespace 6 (NS_FILE).
-  il_to varchar(255) binary NOT NULL default ''
+  il_to varchar(255) binary NOT NULL default '',
+  PRIMARY KEY (il_from,il_to)
 ) /*$wgDBTableOptions*/;
-
--- Forward index, for cache invalidation on file update, etc.
-CREATE UNIQUE INDEX /*i*/il_from ON /*_*/imagelinks (il_from,il_to);
 
 -- Reverse index, for Special:Whatlinkshere and file description page local 
usage
 CREATE INDEX /*i*/il_to ON /*_*/imagelinks (il_to,il_from);
@@ -661,10 +660,10 @@
   -- paginate the three categories separately.  This never has to be updated
   -- after the page is created, since none of these page types can be moved to
   -- any other.
-  cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page'
+  cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page',
+  PRIMARY KEY (cl_from,cl_to)
 ) /*$wgDBTableOptions*/;
 
-CREATE UNIQUE INDEX /*i*/cl_from ON /*_*/categorylinks (cl_from,cl_to);
 
 -- We always sort within a given category, and within a given type.  FIXME:
 -- Formerly this index didn't cover cl_type (since that didn't exist), so old
@@ -763,11 +762,9 @@
   ll_lang varbinary(20) NOT NULL default '',
 
   -- Title of the target, including namespace
-  ll_title varchar(255) binary NOT NULL default ''
+  ll_title varchar(255) binary NOT NULL default '',
+  PRIMARY KEY (ll_from,ll_lang)
 ) /*$wgDBTableOptions*/;
-
--- Forward index, for page edit, save, ApiQueryLanglinks
-CREATE UNIQUE INDEX /*i*/ll_from ON /*_*/langlinks (ll_from, ll_lang);
 
 -- Index for ApiQueryLangbacklinks
 CREATE INDEX /*i*/ll_lang ON /*_*/langlinks (ll_lang, ll_title);
@@ -784,11 +781,9 @@
   iwl_prefix varbinary(20) NOT NULL default '',
 
   -- Title of the target, including namespace
-  iwl_title varchar(255) binary NOT NULL default ''
+  iwl_title varchar(255) binary NOT NULL default '',
+  PRIMARY KEY (iwl_from,iwl_prefix,iwl_title)
 ) /*$wgDBTableOptions*/;
-
--- Forward index, for page edit,

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Add s3 to dbstore2002

2017-08-07 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/370441 )

Change subject: mariadb: Add s3 to dbstore2002
..


mariadb: Add s3 to dbstore2002

dbstore2002 is going to get s3

Bug: T171321
Change-Id: Idb3a64ca3cecadb64b46394a854b42658162aa63
---
M modules/role/manifests/mariadb/dbstore_multiinstance.pp
1 file changed, 6 insertions(+), 6 deletions(-)

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



diff --git a/modules/role/manifests/mariadb/dbstore_multiinstance.pp 
b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
index 83c4974..8f425d9 100644
--- a/modules/role/manifests/mariadb/dbstore_multiinstance.pp
+++ b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
@@ -60,12 +60,12 @@
 role::prometheus::mysqld_exporter_instance {'s2':
 port => 13312,
 }
-#mariadb::instance {'s3':
-#port => 3313,
-#}
-#role::prometheus::mysqld_exporter_instance {'s3':
-#port => 13313,
-#}
+mariadb::instance {'s3':
+port => 3313,
+}
+role::prometheus::mysqld_exporter_instance {'s3':
+port => 13313,
+}
 mariadb::instance {'s4':
 port => 3314,
 }

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Idb3a64ca3cecadb64b46394a854b42658162aa63
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Giuseppe Lavagetto 
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 db2074

2017-08-07 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370440 )

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

db-codfw.php: Depool db2074

db2074 is going to get its content copied to dbstore2002

Bug: T171321
Change-Id: Ie0714a257b1e23d47fa1c49dca34c77814b7ff08
---
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/40/370440/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index c386309..e6ba1f8 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -119,7 +119,7 @@
'db2043' => 50,  # C6 2.9TB 160GB, dump (inactive), vslow
'db2050' => 150, # C6 2.9TB 160GB, api
'db2057' => 400, # D6 3.3TB 160GB
-   'db2074' => 400, # D6 3.3TB 512GB # InnoDB compressed
+   # 'db2074' => 400, # D6 3.3TB 512GB # InnoDB compressed #T171321
],
's4' => [
'db2051' => 0,   # B8 2.9TB 160GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie0714a257b1e23d47fa1c49dca34c77814b7ff08
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 db2065

2017-08-07 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370442 )

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

db-codfw.php: Depool db2065

db2065 was used to populate db2073. It was discovered that db2073 had
issues on the following tables: linter, page and watchlist.
After they got fixed on db2073 and dbstore2002 now it is time to fix
db2065

Change-Id: I2e2768bfe83a983bbbf98b1dbc7843ce77b01ea8
---
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/42/370442/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index e6ba1f8..1e38aaf 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -127,8 +127,8 @@
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   'db2065' => 200, # D6 3.3TB 160GB, api
-   'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB
+   # 'db2065' => 200, # D6 3.3TB 160GB, api #fixing dup keys
+   'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB # 
temporary api
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
@@ -342,7 +342,7 @@
'db2058' => 1,
],
'api' => [
-   'db2065' => 1,
+   'db2073' => 1,
],
],
's5' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2e2768bfe83a983bbbf98b1dbc7843ce77b01ea8
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 s3 to dbstore2002

2017-08-07 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370441 )

Change subject: mariadb: Add s3 to dbstore2002
..

mariadb: Add s3 to dbstore2002

dbstore2002 is going to get s3

Bug: T171321
Change-Id: Idb3a64ca3cecadb64b46394a854b42658162aa63
---
M modules/role/manifests/mariadb/dbstore_multiinstance.pp
1 file changed, 6 insertions(+), 6 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/41/370441/1

diff --git a/modules/role/manifests/mariadb/dbstore_multiinstance.pp 
b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
index 83c4974..8f425d9 100644
--- a/modules/role/manifests/mariadb/dbstore_multiinstance.pp
+++ b/modules/role/manifests/mariadb/dbstore_multiinstance.pp
@@ -60,12 +60,12 @@
 role::prometheus::mysqld_exporter_instance {'s2':
 port => 13312,
 }
-#mariadb::instance {'s3':
-#port => 3313,
-#}
-#role::prometheus::mysqld_exporter_instance {'s3':
-#port => 13313,
-#}
+mariadb::instance {'s3':
+port => 3313,
+}
+role::prometheus::mysqld_exporter_instance {'s3':
+port => 13313,
+}
 mariadb::instance {'s4':
 port => 3314,
 }

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idb3a64ca3cecadb64b46394a854b42658162aa63
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 db2073"

2017-08-07 Thread Marostegui (Code Review)

Hello jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2073"

This reverts commit 772f8fc5dac7287c6043d75eb316998b71ef2e29.

Change-Id: I27e1469c9849c0c4506238c8094a3010789310f7
---
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/38/370438/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index ece6b5e..c386309 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -128,7 +128,7 @@
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 200, # D6 3.3TB 160GB, api
-   # 'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB #T171321
+   'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I27e1469c9849c0c4506238c8094a3010789310f7
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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]: Revert "db-codfw.php: Depool db2065"

2017-08-07 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/370444

to review the following change.


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

Revert "db-codfw.php: Depool db2065"

This reverts commit 2756a72e56756f5afd3278701a404cf4c9cf66b7.

Change-Id: I803d6a6281d87cab67b4ef228082a42ea2d4d1f4
---
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/44/370444/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1e38aaf..e6ba1f8 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -127,8 +127,8 @@
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   # 'db2065' => 200, # D6 3.3TB 160GB, api #fixing dup keys
-   'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB # 
temporary api
+   'db2065' => 200, # D6 3.3TB 160GB, api
+   'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
@@ -342,7 +342,7 @@
'db2058' => 1,
],
'api' => [
-   'db2073' => 1,
+   'db2065' => 1,
],
],
's5' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I803d6a6281d87cab67b4ef228082a42ea2d4d1f4
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/puppet[production]: realm.pp: Add two oauth tables to the private list

2017-08-07 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/370489 )

Change subject: realm.pp: Add two oauth tables to the private list
..


realm.pp: Add two oauth tables to the private list

oauth_accepted_consumer oauth_registered_consumer should not be
replicated to labs.

Bug: T172693
Change-Id: I463e864779c641c809463fd0062e3e5bb243bfca
---
M manifests/realm.pp
1 file changed, 2 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/manifests/realm.pp b/manifests/realm.pp
index d60e274..d15e255 100644
--- a/manifests/realm.pp
+++ b/manifests/realm.pp
@@ -178,6 +178,8 @@
 'moodbar_feedback_response',
 'msg_resource',
 'oathauth_users',
+'oauth_accepted_consumer',
+'oauth_registered_consumer',
 'objectcache',
 'old_growth',
 'oldimage_old',

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I463e864779c641c809463fd0062e3e5bb243bfca
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: BryanDavis 
Gerrit-Reviewer: Chasemp 
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 to oauth tables to the private list

2017-08-07 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/370489 )

Change subject: realm.pp: Add to oauth tables to the private list
..

realm.pp: Add to oauth tables to the private list

oauth_accepted_consumer oauth_registered_consumer should not be
replicated to labs.

Bug: T172693
Change-Id: I463e864779c641c809463fd0062e3e5bb243bfca
---
M manifests/realm.pp
1 file changed, 2 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/89/370489/1

diff --git a/manifests/realm.pp b/manifests/realm.pp
index d60e274..d15e255 100644
--- a/manifests/realm.pp
+++ b/manifests/realm.pp
@@ -178,6 +178,8 @@
 'moodbar_feedback_response',
 'msg_resource',
 'oathauth_users',
+'oauth_accepted_consumer',
+'oauth_registered_consumer',
 'objectcache',
 'old_growth',
 'oldimage_old',

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I463e864779c641c809463fd0062e3e5bb243bfca
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-codfw.php: Depool db2073

2017-08-23 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/373252 )

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

db-codfw.php: Depool db2073

I am going to test 10.0.32 on this host to make sure the enum bug is
solved on 10.0.32 as stated by MariaDB

Bug: T168661
Change-Id: I94ee37cb65ff864261eee2752aea41fe80f84da5
---
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/52/373252/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 6567c75..03deefb 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -128,7 +128,7 @@
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 200, # D6 3.3TB 160GB, api
-   'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB
+   #'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB #T168661
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I94ee37cb65ff864261eee2752aea41fe80f84da5
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, db-codfw.php: Remove db1041

2017-08-23 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/373276 )

Change subject: db-eqiad,db-codfw.php: Remove db1041
..

db-eqiad,db-codfw.php: Remove db1041

db1041 is going to be decommissioned

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 030ac1f..6409e4c 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -451,7 +451,6 @@
'db1037' => '10.64.16.26', # do not remove or comment out
'db1038' => '10.64.16.27', # do not remove or comment out
'db1039' => '10.64.16.28', # do not remove or comment out
-   'db1041' => '10.64.16.30', # do not remove or comment out
'db1043' => '10.64.16.32', # do not remove or comment out
'db1044' => '10.64.16.33', # do not remove or comment out
'db1045' => '10.64.16.34', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 937b0dc..0d721dc 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -157,7 +157,6 @@
],
's7' => [
'db1062' => 0,   # D4 2.8TB 128GB, master
-   # 'db1041' => 0,   # B2 1.4TB  64GB, old master2
# '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
@@ -469,7 +468,6 @@
'db1037' => '10.64.16.26', # do not remove or comment out
'db1038' => '10.64.16.27', # do not remove or comment out
'db1039' => '10.64.16.28', # do not remove or comment out
-   'db1041' => '10.64.16.30', # do not remove or comment out
'db1043' => '10.64.16.32', # do not remove or comment out
'db1044' => '10.64.16.33', # do not remove or comment out
'db1045' => '10.64.16.34', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I3735b6d0f23777db0623c39cff3ad8d384f1afda
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: Remove db1041

2017-08-23 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/373282 )

Change subject: mariadb: Remove db1041
..

mariadb: Remove db1041

db1041 is going to be decomissioned

Bug: T173915
Change-Id: I472849e7deba92fd2799b32275c14baa402fb14e
---
M manifests/site.pp
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
M modules/role/files/prometheus/mysql-core_eqiad.yaml
3 files changed, 7 insertions(+), 9 deletions(-)


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

diff --git a/manifests/site.pp b/manifests/site.pp
index 2bb8b99..2df9fec 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -527,10 +527,16 @@
 role(mariadb::core)
 }
 
-node /^db10(28|33|34|39|41|79|86|94)\.eqiad\.wmnet/ {
+node /^db10(28|33|34|39|79|86|94)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
+# To be decommissioned in T173915
+node 'db1041.eqiad.wmnet' {
+role(spare::system)
+}
+
+
 # s7 (centralauth, meta et al.) core production dbs on codfw
 # codfw master
 node 'db2029.codfw.wmnet' {
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 efbed07..c592113 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1023,13 +1023,6 @@
 filename "trusty-installer/ubuntu-installer/amd64/pxelinux.0";
 }
 
-host db1041 {
-hardware ethernet 78:2b:cb:03:6f:71;
-fixed-address db1041.eqiad.wmnet;
-option pxelinux.pathprefix "trusty-installer/";
-filename "trusty-installer/ubuntu-installer/amd64/pxelinux.0";
-}
-
 host db1043 {
 hardware ethernet 78:2b:cb:03:dd:3b;
 fixed-address db1043.eqiad.wmnet;
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index 4f49a8e..6252cf1 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -111,7 +111,6 @@
   - db1033:9104
   - db1034:9104
   - db1039:9104
-  - db1041:9104
   - db1079:9104
   - db1086:9104
   - db1094:9104

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I472849e7deba92fd2799b32275c14baa402fb14e
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: Remove db1041

2017-08-23 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/373282 )

Change subject: mariadb: Remove db1041
..


mariadb: Remove db1041

db1041 is going to be decomissioned

Bug: T173915
Change-Id: I472849e7deba92fd2799b32275c14baa402fb14e
---
M manifests/site.pp
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
M modules/role/files/prometheus/mysql-core_eqiad.yaml
3 files changed, 7 insertions(+), 9 deletions(-)

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



diff --git a/manifests/site.pp b/manifests/site.pp
index 2bb8b99..2df9fec 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -527,10 +527,16 @@
 role(mariadb::core)
 }
 
-node /^db10(28|33|34|39|41|79|86|94)\.eqiad\.wmnet/ {
+node /^db10(28|33|34|39|79|86|94)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
+# To be decommissioned in T173915
+node 'db1041.eqiad.wmnet' {
+role(spare::system)
+}
+
+
 # s7 (centralauth, meta et al.) core production dbs on codfw
 # codfw master
 node 'db2029.codfw.wmnet' {
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 efbed07..c592113 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1023,13 +1023,6 @@
 filename "trusty-installer/ubuntu-installer/amd64/pxelinux.0";
 }
 
-host db1041 {
-hardware ethernet 78:2b:cb:03:6f:71;
-fixed-address db1041.eqiad.wmnet;
-option pxelinux.pathprefix "trusty-installer/";
-filename "trusty-installer/ubuntu-installer/amd64/pxelinux.0";
-}
-
 host db1043 {
 hardware ethernet 78:2b:cb:03:dd:3b;
 fixed-address db1043.eqiad.wmnet;
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index 4f49a8e..6252cf1 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -111,7 +111,6 @@
   - db1033:9104
   - db1034:9104
   - db1039:9104
-  - db1041:9104
   - db1079:9104
   - db1086:9104
   - db1094:9104

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I472849e7deba92fd2799b32275c14baa402fb14e
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Giuseppe Lavagetto 
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, db-codfw.php: Add db2077

2017-08-17 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/372386 )

Change subject: db-eqiad,db-codfw.php: Add db2077
..

db-eqiad,db-codfw.php: Add db2077

db2077 is a new slave in s7

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 03ecd9f..5cb0439 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -147,6 +147,7 @@
'db2060' => 100, # D6 3.3TB 160GB, api
'db2067' => 400, # D6 3.3TB 160GB
'db2076' => 400, # B1 3.3TB 512GB
+   'db2077' => 400, # C1 3.3TB 512GB
],
's7' => [
'db2029' => 0,   # B6 2.9TB  96GB, master
@@ -578,6 +579,7 @@
'db2074' => '10.192.48.84', # do not remove or comment out
'db2075' => '10.192.0.5', # do not remove or comment out
'db2076' => '10.192.16.38', # do not remove or comment out
+   'db2077' => '10.192.32.168', # do not remove or comment out
'virt1000' => '208.80.154.18', # do not remove or comment out
'silver' => '208.80.154.136', # do not remove or comment out
'labtestweb2001' => '208.80.153.14', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index cc3aaee..ed94a53 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -598,6 +598,7 @@
'db2074' => '10.192.48.84', # do not remove or comment out
'db2075' => '10.192.0.5', # do not remove or comment out
'db2076' => '10.192.16.38', # do not remove or comment out
+   'db2077' => '10.192.32.168', # do not remove or comment out
'virt1000' => '208.80.154.18', # do not remove or comment out
'silver' => '208.80.154.136', # do not remove or comment out
'labtestweb2001' => '208.80.153.14', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I88cba856c39a6e495c782e0bf8a060fb9c660a1e
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]: mysql-dbstore_codfw: Add dbstore2001 - s7

2017-08-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/372508 )

Change subject: mysql-dbstore_codfw: Add dbstore2001 - s7
..

mysql-dbstore_codfw: Add dbstore2001 - s7

dbstore2001 will start replicating s7

Bug: T168409
Change-Id: I519d7abb89b5336bbb4d143a9d134a52f246e3f2
---
M modules/role/files/prometheus/mysql-dbstore_codfw.yaml
1 file changed, 6 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/08/372508/1

diff --git a/modules/role/files/prometheus/mysql-dbstore_codfw.yaml 
b/modules/role/files/prometheus/mysql-dbstore_codfw.yaml
index c0b6ab4..5fdf013 100644
--- a/modules/role/files/prometheus/mysql-dbstore_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-dbstore_codfw.yaml
@@ -39,6 +39,12 @@
   - dbstore2001:13316
 
 - labels:
+shard: s7
+role: slave
+  targets:
+  - dbstore2001:13317
+
+- labels:
 shard: x1
 role: slave
   targets:

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I519d7abb89b5336bbb4d143a9d134a52f246e3f2
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-codfw.php: Depool db2077

2017-08-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/372502 )

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

db-codfw.php: Depool db2077

db2077 data is going to be copied to dbstore2001

Bug: T168409
Change-Id: I33b848ef4c5e27894cffe3075013f43979e23ee1
---
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/02/372502/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 4d26a05..fa48b36 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -155,7 +155,7 @@
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
'db2061' => 200, # D6 3.3TB 160GB, api
'db2068' => 300, # D6 3.3TB 160GB
-   'db2077' => 400, # C1 3.3TB 512GB
+   # 'db2077' => 400, # C1 3.3TB 512GB #T168409
],
'silver' => [
'silver' => 100,   # I have no idea if this is right

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I33b848ef4c5e27894cffe3075013f43979e23ee1
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]: mysql-dbstore_codfw: Add dbstore2001 - s7

2017-08-18 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/372508 )

Change subject: mysql-dbstore_codfw: Add dbstore2001 - s7
..


mysql-dbstore_codfw: Add dbstore2001 - s7

dbstore2001 will start replicating s7

Bug: T168409
Change-Id: I519d7abb89b5336bbb4d143a9d134a52f246e3f2
---
M modules/role/files/prometheus/mysql-dbstore_codfw.yaml
1 file changed, 6 insertions(+), 0 deletions(-)

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



diff --git a/modules/role/files/prometheus/mysql-dbstore_codfw.yaml 
b/modules/role/files/prometheus/mysql-dbstore_codfw.yaml
index c0b6ab4..5fdf013 100644
--- a/modules/role/files/prometheus/mysql-dbstore_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-dbstore_codfw.yaml
@@ -39,6 +39,12 @@
   - dbstore2001:13316
 
 - labels:
+shard: s7
+role: slave
+  targets:
+  - dbstore2001:13317
+
+- labels:
 shard: x1
 role: slave
   targets:

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I519d7abb89b5336bbb4d143a9d134a52f246e3f2
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Giuseppe Lavagetto 
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-codfw.php: Depool db2077"

2017-08-18 Thread Marostegui (Code Review)

Hello Urbanecm, Florianschmidtwelzow, jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2077"

This reverts commit d6586ba019fcbef3ac2acbe5ae2d8adf9fe11cca.

Change-Id: If1eb15cd72715bae0ffc4f0bcc2f5341f1634b42
---
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/12/372512/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index fa48b36..4d26a05 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -155,7 +155,7 @@
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
'db2061' => 200, # D6 3.3TB 160GB, api
'db2068' => 300, # D6 3.3TB 160GB
-   # 'db2077' => 400, # C1 3.3TB 512GB #T168409
+   'db2077' => 400, # C1 3.3TB 512GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If1eb15cd72715bae0ffc4f0bcc2f5341f1634b42
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Florianschmidtwelzow 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
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]: sanitarium3: Prepare db1102 to run s4 instance

2017-08-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/372518 )

Change subject: sanitarium3: Prepare db1102 to run s4 instance
..

sanitarium3: Prepare db1102 to run s4 instance

s4 will be migrated from db1095 to db1102

Bug: T172996
Change-Id: I50e6af1a1312ba3aec61b5ed7ab1807266fb0c00
---
M modules/role/files/prometheus/mysql-labs_eqiad.yaml
M modules/role/manifests/mariadb/sanitarium_multiinstance.pp
2 files changed, 11 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/18/372518/1

diff --git a/modules/role/files/prometheus/mysql-labs_eqiad.yaml 
b/modules/role/files/prometheus/mysql-labs_eqiad.yaml
index 67bea22..8673535 100644
--- a/modules/role/files/prometheus/mysql-labs_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-labs_eqiad.yaml
@@ -15,6 +15,11 @@
   targets:
   - db1102:13312
 - labels:
+shard: s4
+role: slave
+  targets:
+  - db1102:13314
+- labels:
 shard: s6
 role: slave
   targets:
diff --git a/modules/role/manifests/mariadb/sanitarium_multiinstance.pp 
b/modules/role/manifests/mariadb/sanitarium_multiinstance.pp
index 55f653c..fd897b5 100644
--- a/modules/role/manifests/mariadb/sanitarium_multiinstance.pp
+++ b/modules/role/manifests/mariadb/sanitarium_multiinstance.pp
@@ -57,6 +57,12 @@
 role::prometheus::mysqld_exporter_instance {'s2':
 port => 13312,
 }
+mariadb::instance {'s4':
+port => 3314,
+}
+role::prometheus::mysqld_exporter_instance {'s4':
+port => 13314,
+}
 mariadb::instance {'s6':
 port => 3316,
 }

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I50e6af1a1312ba3aec61b5ed7ab1807266fb0c00
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/dns[master]: wmnet: Switch dns master alias to eqiad

2017-05-03 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/350824 )

Change subject: wmnet: Switch dns master alias to eqiad
..


wmnet: Switch dns master alias to eqiad

Switching back the aliases to eqiad hosts

Bug: T155099
Change-Id: I376851fa39505fe86c9b74f17becf80dcc1eb828
---
M templates/wmnet
1 file changed, 11 insertions(+), 11 deletions(-)

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



diff --git a/templates/wmnet b/templates/wmnet
index 65bbdca..fc13666 100644
--- a/templates/wmnet
+++ b/templates/wmnet
@@ -34,13 +34,13 @@
 udplog  1H  IN CNAMEmwlog1001.eqiad.wmnet.
 deployment  1H  IN CNAMEnaos.codfw.wmnet.
 people  1H  IN CNAMErutherfordium.eqiad.wmnet.
-s1-master   5M  IN CNAMEdb2016.codfw.wmnet.
-s2-master   5M  IN CNAMEdb2017.codfw.wmnet.
-s3-master   5M  IN CNAMEdb2018.codfw.wmnet.
-s4-master   5M  IN CNAMEdb2019.codfw.wmnet.
-s5-master   5M  IN CNAMEdb2023.codfw.wmnet.
-s6-master   5M  IN CNAMEdb2028.codfw.wmnet.
-s7-master   5M  IN CNAMEdb2029.codfw.wmnet.
+s1-master   5M  IN CNAMEdb1052.eqiad.wmnet.
+s2-master   5M  IN CNAMEdb1054.eqiad.wmnet.
+s3-master   5M  IN CNAMEdb1075.eqiad.wmnet.
+s4-master   5M  IN CNAMEdb1068.eqiad.wmnet.
+s5-master   5M  IN CNAMEdb1063.eqiad.wmnet.
+s6-master   5M  IN CNAMEdb1061.eqiad.wmnet.
+s7-master   5M  IN CNAMEdb1062.eqiad.wmnet.
 m1-master   5M  IN CNAMEdbproxy1006.eqiad.wmnet.
 m1-slave5M  IN CNAMEdb1001.eqiad.wmnet.
 m2-master   5M  IN CNAMEdbproxy1002.eqiad.wmnet.
@@ -50,10 +50,10 @@
 m4-master   5M  IN CNAMEdbproxy1004.eqiad.wmnet.
 m5-master   5M  IN CNAMEdb1009.eqiad.wmnet.
 m5-slave5M  IN CNAMEdb2030.codfw.wmnet.
-x1-master   5M  IN CNAMEdb2033.codfw.wmnet.
-x1-slave5M  IN CNAMEtempdb2001.codfw.wmnet.
-es2-master  5M  IN CNAMEes2016.codfw.wmnet.
-es3-master  5M  IN CNAMEes2018.codfw.wmnet.
+x1-master   5M  IN CNAMEdb1031.eqiad.wmnet.
+x1-slave5M  IN CNAMEdb1029.eqiad.wmnet.
+es2-master  5M  IN CNAMEes1011.eqiad.wmnet.
+es3-master  5M  IN CNAMEes1014.eqiad.wmnet.
 pc1-master  5M  IN CNAMEpc1004.eqiad.wmnet.
 pc2-master  5M  IN CNAMEpc1005.eqiad.wmnet.
 pc3-master  5M  IN CNAMEpc1006.eqiad.wmnet.

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I376851fa39505fe86c9b74f17becf80dcc1eb828
Gerrit-PatchSet: 3
Gerrit-Project: operations/dns
Gerrit-Branch: master
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-codfw.php: Repool db2064, depool db2063

2017-05-11 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353492 )

Change subject: db-codfw.php: Repool db2064, depool db2063
..

db-codfw.php: Repool db2064, depool db2063

db2064 finished alter table
db2063 needs alter table

Bug: T162611
Change-Id: I157a297e596eafdd244520399a6420885801c768
---
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/92/353492/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 62bbdda..2f606c2 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -109,8 +109,8 @@
'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 #T162611
+#  'db2063' => 100, # D6 3.3TB 160GB, api #T162611
+   'db2064' => 400, # D6 3.3TB 160GB
],
/* s3 */ 'DEFAULT' => [
'db2018' => 0,   # B6 2.9TB  96GB, master
@@ -275,7 +275,7 @@
],
'api' => [
'db2041' => 1,
-   'db2063' => 1,
+#  'db2063' => 1,
],
],
/* s3 */ 'DEFAULT' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I157a297e596eafdd244520399a6420885801c768
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 db1056 with less load

2017-05-11 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353218 )

Change subject: db-eqiad.php: Repool db1056 with less load
..

db-eqiad.php: Repool db1056 with less load

db1056 was out for rack change and reimage.
It is now back, pooling it with less load to see how the CPU behaves, as
we are not 100% sure it is healthy

Change-Id: Ib467bc4900fbf04fc084f61bc87c1e58b6df0bd2
---
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/18/353218/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 6421082..88eeaeb 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -127,7 +127,7 @@
's4' => [
'db1068' => 0,   # D1 2.8TB 160GB, master
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1056' => 1,   # C2 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 - new sanitarium
'db1081' => 300, # A2 3.6TB 512GB, api
@@ -329,7 +329,7 @@
],
'watchlist' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'recentchanges' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib467bc4900fbf04fc084f61bc87c1e58b6df0bd2
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]: wikitech.pp: Remove mira

2017-05-11 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353224 )

Change subject: wikitech.pp: Remove mira
..

wikitech.pp: Remove mira

mira has been decommissioned

Bug: T164968
Change-Id: I98f7710515dfcb139e857dadf49250861ce33ea6
---
M modules/role/manifests/mariadb/wikitech.pp
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/24/353224/1

diff --git a/modules/role/manifests/mariadb/wikitech.pp 
b/modules/role/manifests/mariadb/wikitech.pp
index 92ad45c..4a39626 100644
--- a/modules/role/manifests/mariadb/wikitech.pp
+++ b/modules/role/manifests/mariadb/wikitech.pp
@@ -32,7 +32,7 @@
 ferm::service { 'mysql_deployment_terbium':
 proto  => 'tcp',
 port   => '3306',
-srange => '@resolve((tin.eqiad.wmnet mira.codfw.wmnet naos.codfw.wmnet 
terbium.eqiad.wmnet wasat.codfw.wmnet))',
+srange => '@resolve((tin.eqiad.wmnet naos.codfw.wmnet 
terbium.eqiad.wmnet wasat.codfw.wmnet))',
 }
 
 service { 'mariadb':

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I98f7710515dfcb139e857dadf49250861ce33ea6
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: Increase load db1056

2017-05-11 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353245 )

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

db-eqiad.php: Increase load db1056

Give it more load

Change-Id: Iaf9b0a63443c74121fe3e32078f4388b38c4d2fb
---
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/45/353245/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 88eeaeb..c0914cd 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -333,7 +333,7 @@
],
'recentchanges' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'recentchangeslinked' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iaf9b0a63443c74121fe3e32078f4388b38c4d2fb
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: Increase db1056 load

2017-05-11 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353252 )

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

db-eqiad.php: Increase db1056 load

Give it a bit more load

Change-Id: I700559d863996609d46da564becb4a897550ccc5
---
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/52/353252/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c0914cd..9a1c14d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -337,7 +337,7 @@
],
'recentchangeslinked' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'contributions' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I700559d863996609d46da564becb4a897550ccc5
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 db1067"

2017-05-10 Thread Marostegui (Code Review)

Hello jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1067"

This reverts commit a94275c82771fd53119737e418f43d07c5f3a9e8.

Change-Id: Ibe32a5957ed0f5c3f4655c6cd37272172bb4daed
---
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/16/353216/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index aa642de..6421082 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -94,7 +94,7 @@
 'sectionLoads' => [
's1' => [
'db1052' => 0,   # B3 2.8TB  96GB, master
-#  'db1067' => 0,   # D1 2.8TB 160GB, old master #T147166 #T130067
+   'db1067' => 0,   # D1 2.8TB 160GB, 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/353216
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibe32a5957ed0f5c3f4655c6cd37272172bb4daed
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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-codfw.php: Depool db2064

2017-05-11 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353267 )

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

db-codfw.php: Depool db2064

Needs an alter table

Bug: T162611
Change-Id: I67773a66db089a14306a2b94e98e48746c69
---
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/67/353267/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index b1a5b0a..62bbdda 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -110,7 +110,7 @@
'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
+#  'db2064' => 400, # D6 3.3TB 160GB #T162611
],
/* s3 */ 'DEFAULT' => [
'db2018' => 0,   # B6 2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I67773a66db089a14306a2b94e98e48746c69
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 db1056 original load

2017-05-11 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353262 )

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

db-eqiad.php: Restore db1056 original load

Change-Id: I7e3c476688f6d628e0482fcfac3fde80956b699d
---
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/62/353262/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9a1c14d..705c97e 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -341,11 +341,11 @@
],
'contributions' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
'logpager' => [
'db1053' => 1,
-#  'db1056' => 1,
+   'db1056' => 1,
],
],
's5' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I7e3c476688f6d628e0482fcfac3fde80956b699d
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 db1097 for maintenance"

2017-05-10 Thread Marostegui (Code Review)

Hello jenkins-bot,

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

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1097 for maintenance"
..

Revert "db-eqiad.php: Depool db1097 for maintenance"

This reverts commit d2ff995cd2bcc9f6916ef93967d5f324d4b063d7.

Change-Id: Ie47586247e3325f2084eb1e203734ef6c7e0488f
---
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/80/353080/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index d86a57f..6421082 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,7 @@
'db1081' => 300, # A2 3.6TB 512GB, api
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
-#  'db1097' => 0,   # D1 3.6TB 512GB, old master
+   'db1097' => 0,   # D1 3.6TB 512GB, old master
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie47586247e3325f2084eb1e203734ef6c7e0488f
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 db1097 for maintenance

2017-05-10 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353057 )

Change subject: db-eqiad.php: Depool db1097 for maintenance
..

db-eqiad.php: Depool db1097 for maintenance

Change-Id: I4770d7369c71e8a4d6186b097cc3acc6a699b045
---
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/57/353057/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 6421082..d86a57f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,7 @@
'db1081' => 300, # A2 3.6TB 512GB, api
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
-   'db1097' => 0,   # D1 3.6TB 512GB, old master
+#  'db1097' => 0,   # D1 3.6TB 512GB, old master
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4770d7369c71e8a4d6186b097cc3acc6a699b045
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 db1067

2017-05-10 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353061 )

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

db-eqiad.php: Depool db1067

Going to use it to export change_tag, tag_summary and watchlist to codfw

Bug: T130067
Bug: T147166
Change-Id: I14f91dc486d5de68eb0bad09d11a6562b562b070
---
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/61/353061/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 6421082..aa642de 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -94,7 +94,7 @@
 'sectionLoads' => [
's1' => [
'db1052' => 0,   # B3 2.8TB  96GB, master
-   'db1067' => 0,   # D1 2.8TB 160GB, old master
+#  'db1067' => 0,   # D1 2.8TB 160GB, old master #T147166 #T130067
'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/353061
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I14f91dc486d5de68eb0bad09d11a6562b562b070
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 db1067

2017-05-10 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/353061 )

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


db-eqiad.php: Depool db1067

Going to use it to export change_tag, tag_summary and watchlist to codfw

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

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 6421082..aa642de 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -94,7 +94,7 @@
 'sectionLoads' => [
's1' => [
'db1052' => 0,   # B3 2.8TB  96GB, master
-   'db1067' => 0,   # D1 2.8TB 160GB, old master
+#  'db1067' => 0,   # D1 2.8TB 160GB, old master #T147166 #T130067
'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/353061
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: I14f91dc486d5de68eb0bad09d11a6562b562b070
Gerrit-PatchSet: 2
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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 es2019

2017-05-09 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/352752 )

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

db-codfw.php: Repool es2019

As there were no differences found by compare.py let's repool this host

Bug: T149526
Change-Id: I77f8611fbad7c0955d6b95b295b715cdd638c203
---
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/52/352752/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 01f194e..b1a5b0a 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -597,7 +597,7 @@
'cluster25' => [
'10.192.16.172' => 1, # es2018, master
'10.192.0.142'  => 3, # es2017
-#  '10.192.48.42'  => 3, # es2019 # crashed?
+   '10.192.48.42'  => 3, # es2019
],
# ExtensionStore shard1 - initially for AFTv5
'extension1' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I77f8611fbad7c0955d6b95b295b715cdd638c203
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 db1097"

2017-05-09 Thread Marostegui (Code Review)

Hello jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1097"

This reverts commit f44abe743ce81d1d18912cf9e05c826ba62d7f03.

Change-Id: Ia141302c6ec1b22c9e95b630a9a3951da0e71255
---
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/98/352798/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index fa04e9c..9301879 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,7 @@
'db1081' => 300, # A2 3.6TB 512GB, api
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
-#  'db1097' => 0,   # D1 3.6TB 512GB, old master #T130067 #T147166
+   'db1097' => 0,   # D1 3.6TB 512GB, old master
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia141302c6ec1b22c9e95b630a9a3951da0e71255
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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/dns[master]: wmnet: Point m3 slave to codfw master

2017-05-09 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/352769 )

Change subject: wmnet: Point m3 slave to codfw master
..

wmnet: Point m3 slave to codfw master

db1048 is having issues and needs to get its BBU replaced
Temporary point the slave to codfw master.
I rather use codfw master than the actual eqiad master to avoid possible
heavy report queries overloading the primary master

Bug: T160731
Change-Id: I149d91244b0ed90da5252edd308808d8f2b53807
---
M templates/wmnet
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/dns 
refs/changes/69/352769/1

diff --git a/templates/wmnet b/templates/wmnet
index 184bc3d..59ea98b 100644
--- a/templates/wmnet
+++ b/templates/wmnet
@@ -46,7 +46,7 @@
 m2-master   5M  IN CNAMEdbproxy1002.eqiad.wmnet.
 m2-slave5M  IN CNAMEdb2011.codfw.wmnet.
 m3-master   5M  IN CNAMEdbproxy1003.eqiad.wmnet.
-m3-slave5M  IN CNAMEdb1048.eqiad.wmnet.
+m3-slave5M  IN CNAMEdb2012.codfw.wmnet.
 m4-master   5M  IN CNAMEdbproxy1004.eqiad.wmnet.
 m5-master   5M  IN CNAMEdb1009.eqiad.wmnet.
 m5-slave5M  IN CNAMEdb2030.codfw.wmnet.

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I149d91244b0ed90da5252edd308808d8f2b53807
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/mediawiki-config[master]: db-eqiad.php: Depool db1090

2017-05-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354179 )

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

db-eqiad.php: Depool db1090

Needs alter table

Bug: T162611
Change-Id: Icabbf009ffa9065de20b89c8a15e802ffc2e65b3
---
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/79/354179/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 705c97e..682bf9c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -113,7 +113,7 @@
'db1060' => 1,   # C2 2.8TB  96GB, api
'db1074' => 300, # A2 3.6TB 512GB, api
'db1076' => 500, # B1 3.6TB 512GB
-   'db1090' => 500, # C3 3.6TB 512GB
+#  'db1090' => 500, # C3 3.6TB 512GB #T162611
],
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Icabbf009ffa9065de20b89c8a15e802ffc2e65b3
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: clean up duplicate GRANTs for phstats user

2017-05-18 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/348779 )

Change subject: mariadb: clean up duplicate GRANTs for phstats user
..


mariadb: clean up duplicate GRANTs for phstats user

These GRANTs for the phabricator-statistics (phstats)
user are duplicate, looks like copy/paste fail.

Cleaning up.

Change-Id: I806034b62145a7a53de26c5781dfb851a53e5c48
---
M modules/role/templates/mariadb/grants/production-m3.sql.erb
1 file changed, 0 insertions(+), 18 deletions(-)

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



diff --git a/modules/role/templates/mariadb/grants/production-m3.sql.erb 
b/modules/role/templates/mariadb/grants/production-m3.sql.erb
index ec5a105..1b02471 100644
--- a/modules/role/templates/mariadb/grants/production-m3.sql.erb
+++ b/modules/role/templates/mariadb/grants/production-m3.sql.erb
@@ -79,12 +79,6 @@
 GRANT SELECT ON `phabricator_project`.* TO 'phstats'@'10.64.32.150';
 GRANT SELECT ON `phabricator_differential`.* TO 'phstats'@'10.64.32.150';
 
-GRANT SELECT
-ON `phabricator_maniphest`.* TO 'phstats'@'10.64.32.150';
-
-GRANT SELECT
-ON `phabricator_user`.* TO 'phstats'@'iridium';
-
 -- phstats@dbproxy1003
 
 GRANT USAGE
@@ -95,12 +89,6 @@
 GRANT SELECT ON `phabricator_project`.* TO 'phstats'@'10.64.0.198';
 GRANT SELECT ON `phabricator_differential`.* TO 'phstats'@'10.64.0.198';
 
-GRANT SELECT
-ON `phabricator_maniphest`.* TO 'phstats'@'10.64.0.198';
-
-GRANT SELECT
-ON `phabricator_user`.* TO 'phstats'@'10.64.0.198';
-
 -- phstats@dbproxy1008
 
 GRANT USAGE
@@ -110,12 +98,6 @@
 GRANT SELECT ON `phabricator_user`.* TO 'phstats'@'10.64.32.157';
 GRANT SELECT ON `phabricator_project`.* TO 'phstats'@'10.64.32.157';
 GRANT SELECT ON `phabricator_differential`.* TO 'phstats'@'10.64.32.157';
-
-GRANT SELECT
-ON `phabricator_maniphest`.* TO 'phstats'@'10.64.32.157';
-
-GRANT SELECT
-ON `phabricator_user`.* TO 'phstats'@'10.64.32.157';
 
 -- phmanifest@iridium
 

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I806034b62145a7a53de26c5781dfb851a53e5c48
Gerrit-PatchSet: 4
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Dzahn 
Gerrit-Reviewer: Dzahn 
Gerrit-Reviewer: Giuseppe Lavagetto 
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 db1083

2017-05-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354195 )

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

db-eqiad.php: Depool db1083

Needs alter table

Bug: T159753
Bug: T164530
Change-Id: I98aa9a0102cd05840cb875c119d400da41777587
---
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/354195/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f4cc7ae..de388ad 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -102,7 +102,7 @@
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
-   'db1083' => 500, # B1 3.6TB 512GB
+#  'db1083' => 500, # B1 3.6TB 512GB #T159753 #T164530
'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I98aa9a0102cd05840cb875c119d400da41777587
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 db1083, depool db1080

2017-05-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354200 )

Change subject: db-eqiad.php: Repool db1083, depool db1080
..

db-eqiad.php: Repool db1083, depool db1080

db1083 finished alter
db1080 needs alter

Bug: T159753
Bug: T164530
Change-Id: Ic6fafb0d2895a68c95a6ccad043f92bf5b05735c
---
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/00/354200/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index de388ad..9030235 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -101,8 +101,8 @@
'db1066' => 10,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
-   'db1080' => 500, # A2 3.6TB 512GB
-#  'db1083' => 500, # B1 3.6TB 512GB #T159753 #T164530
+#  'db1080' => 500, # A2 3.6TB 512GB #T159753 #T164530
+   'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic6fafb0d2895a68c95a6ccad043f92bf5b05735c
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 db1080, depool db1073

2017-05-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354203 )

Change subject: db-eqiad.php: Repool db1080, depool db1073
..

db-eqiad.php: Repool db1080, depool db1073

db1080 finished alter table
db1073 needs alter table

Bug: T159753
Bug: T164530
Change-Id: Ib47ddae3ad268988672c60d76f2909df37ae475e
---
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/03/354203/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9030235..32574e5 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' => 10,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
-   'db1073' => 50,  # B3 2.8TB 160GB, api
-#  'db1080' => 500, # A2 3.6TB 512GB #T159753 #T164530
+#  'db1073' => 50,  # B3 2.8TB 160GB, api #T159753 #T164530
+   'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
@@ -263,7 +263,7 @@
'api' => [
'db1066' => 1,
'db1072' => 1,
-   'db1073' => 1,
+#  'db1073' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib47ddae3ad268988672c60d76f2909df37ae475e
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 db1090, depool db1076

2017-05-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354191 )

Change subject: db-eqiad.php: Repool db1090, depool db1076
..

db-eqiad.php: Repool db1090, depool db1076

db1090 finished alter
db1076 needs alter

Bug: T162611
Change-Id: I987a26a70cefefc7f285675f61909b3b204954c4
---
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/91/354191/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 682bf9c..f4cc7ae 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -112,8 +112,8 @@
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1060' => 1,   # C2 2.8TB  96GB, api
'db1074' => 300, # A2 3.6TB 512GB, api
-   'db1076' => 500, # B1 3.6TB 512GB
-#  'db1090' => 500, # C3 3.6TB 512GB #T162611
+#  'db1076' => 500, # B1 3.6TB 512GB #T162611
+   'db1090' => 500, # C3 3.6TB 512GB
],
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I987a26a70cefefc7f285675f61909b3b204954c4
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 db1090 for maintenance

2017-05-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354188 )

Change subject: db-eqiad.php: Depool db1090 for maintenance
..

db-eqiad.php: Depool db1090 for maintenance

Bug: T159753
Bug: T164530
Change-Id: I79940a01fb863007557ea2b81b6ef5e2057d5e68
---
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/88/354188/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 682bf9c..73ea27d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -103,7 +103,7 @@
'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
+#  'db1089' => 500, # C3 3.6TB 512GB #T164530 #T159753
],
's2' => [
'db1054' => 0,   # A3 2.8TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I79940a01fb863007557ea2b81b6ef5e2057d5e68
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 db1090 for maintenance"

2017-05-18 Thread Marostegui (Code Review)

Hello jenkins-bot, Jcrespo,

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

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1090 for maintenance"
..

Revert "db-eqiad.php: Depool db1090 for maintenance"

This reverts commit 188df554b91d5689ab79b4b17584fabd6c261e5a.

Change-Id: Idc164e2d2313d8c42c55ff0560af5803039e83e5
---
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/89/354189/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 73ea27d..682bf9c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -103,7 +103,7 @@
'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 #T164530 #T159753
+   'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [
'db1054' => 0,   # A3 2.8TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idc164e2d2313d8c42c55ff0560af5803039e83e5
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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: Repool db1073, depool db1072

2017-05-18 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354208 )

Change subject: db-eqiad.php: Repool db1073, depool db1072
..

db-eqiad.php: Repool db1073, depool db1072

db1073 finished alter
db1072 needs alter

Bug: T159753
Bug: T164530
Change-Id: Ida16812fab8219b972280db6c35f872803cae060
---
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/08/354208/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 32574e5..d91437a 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,8 +99,8 @@
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 10,  # D1 2.8TB 160GB, api
-   'db1072' => 50,  # B2 2.8TB 160GB, api
-#  'db1073' => 50,  # B3 2.8TB 160GB, api #T159753 #T164530
+#  'db1072' => 50,  # B2 2.8TB 160GB, api #T159753 #T164530
+   '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
@@ -262,8 +262,8 @@
],
'api' => [
'db1066' => 1,
-   'db1072' => 1,
-#  'db1073' => 1,
+#  'db1072' => 1,
+   'db1073' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ida16812fab8219b972280db6c35f872803cae060
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: Remove old comment

2017-05-16 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354003 )

Change subject: db-codfw.php: Remove old comment
..

db-codfw.php: Remove old comment

Change-Id: Id785cbc738cf9a804b3239c8b8acc4c9bb4bb245
---
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/03/354003/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 598711e..80163ba 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -108,7 +108,7 @@
'db2035' => 50,  # C6 2.9TB 160GB, rc, log
 #  'db2041' => 100, # C6 2.9TB 160GB, api #T162611
 #  'db2049' => 400, # C6 2.9TB 160GB, #T162611
-   'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T162611
+   'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2063' => 100, # D6 3.3TB 160GB, api
'db2064' => 400, # D6 3.3TB 160GB
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id785cbc738cf9a804b3239c8b8acc4c9bb4bb245
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 db2041, repool db2056

2017-05-16 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354000 )

Change subject: db-codfw.php: Depool db2041, repool db2056
..

db-codfw.php: Depool db2041, repool db2056

db2041 needs alter table
db2056 finished alter table

Bug: T162611
Change-Id: Ia5e706fe7132f7ff5d72f99551da5847102eb477
---
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/00/354000/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 3f11297..598711e 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -106,10 +106,10 @@
's2' => [
'db2017' => 0,   # B6 2.9TB  96GB, master
'db2035' => 50,  # C6 2.9TB 160GB, rc, log
-   'db2041' => 100, # C6 2.9TB 160GB, api
+#  'db2041' => 100, # C6 2.9TB 160GB, api #T162611
 #  'db2049' => 400, # C6 2.9TB 160GB, #T162611
-#  'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T162611
-   'db2063' => 100, # D6 3.3TB 160GB, api #temporary vslow #T162611
+   'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T162611
+   'db2063' => 100, # D6 3.3TB 160GB, api
'db2064' => 400, # D6 3.3TB 160GB
],
/* s3 */ 'DEFAULT' => [
@@ -268,13 +268,13 @@
'db2035' => 1,
],
'dump' => [
-   'db2063' => 1,
+   'db2056' => 1,
],
'vslow' => [
-   'db2063' => 1,
+   'db2056' => 1,
],
'api' => [
-   'db2041' => 1,
+#  'db2041' => 1,
'db2063' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia5e706fe7132f7ff5d72f99551da5847102eb477
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 db2041 and db2049

2017-05-17 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/354085 )

Change subject: db-codfw.php: Repool db2041 and db2049
..

db-codfw.php: Repool db2041 and db2049

They finished the alter table

Bug: T162611
Change-Id: If7659e6b48eae3090059986fa33028ecc830ece4
---
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/85/354085/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 80163ba..b1a5b0a 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -106,8 +106,8 @@
's2' => [
'db2017' => 0,   # B6 2.9TB  96GB, master
'db2035' => 50,  # C6 2.9TB 160GB, rc, log
-#  'db2041' => 100, # C6 2.9TB 160GB, api #T162611
-#  'db2049' => 400, # C6 2.9TB 160GB, #T162611
+   '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
@@ -274,7 +274,7 @@
'db2056' => 1,
],
'api' => [
-#  'db2041' => 1,
+   'db2041' => 1,
'db2063' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If7659e6b48eae3090059986fa33028ecc830ece4
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 db2063, depool db2056

2017-05-15 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353948 )

Change subject: db-codfw.php: Repool db2063, depool db2056
..

db-codfw.php: Repool db2063, depool db2056

db2063 finished alter table
db2056 needs alter table

Bug: T162611
Change-Id: I9b24104037596f2806eb80c12355595917de5156
---
M wmf-config/db-codfw.php
1 file changed, 5 insertions(+), 5 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 2f606c2..fe2aed2 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -108,8 +108,8 @@
'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 #T162611
+#  'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T162611
+   'db2063' => 100, # D6 3.3TB 160GB, api #temporary vslow #T162611
'db2064' => 400, # D6 3.3TB 160GB
],
/* s3 */ 'DEFAULT' => [
@@ -268,14 +268,14 @@
'db2035' => 1,
],
'dump' => [
-   'db2056' => 1,
+   'db2063' => 1,
],
'vslow' => [
-   'db2056' => 1,
+   'db2063' => 1,
],
'api' => [
'db2041' => 1,
-#  'db2063' => 1,
+   'db2063' => 1,
],
],
/* s3 */ 'DEFAULT' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9b24104037596f2806eb80c12355595917de5156
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 db2049

2017-05-16 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/353983 )

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

db-codfw.php: Depool db2049

Alter table

Bug: T162611
Change-Id: I8db14c057050ac6c412be37009fa0cc6df7d5f02
---
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/83/353983/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index fe2aed2..3f11297 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -107,7 +107,7 @@
'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,
+#  'db2049' => 400, # C6 2.9TB 160GB, #T162611
 #  'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T162611
'db2063' => 100, # D6 3.3TB 160GB, api #temporary vslow #T162611
'db2064' => 400, # D6 3.3TB 160GB

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8db14c057050ac6c412be37009fa0cc6df7d5f02
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 db1074

2017-06-07 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/357757 )

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

db-eqiad.php: Depool db1074

db1074 needs an alter table
pool db1076 to help with API meanwhile

Bug: T166205
Change-Id: I77bae4eb7a4b24610d18b391da84bdb82684708a
---
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/57/357757/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index efff5cf..9784d1f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -111,8 +111,8 @@
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1060' => 1,   # C2 2.8TB  96GB, api
-   'db1074' => 300, # A2 3.6TB 512GB, api
-   'db1076' => 500, # B1 3.6TB 512GB
+#  'db1074' => 300, # A2 3.6TB 512GB, api #T166205
+   'db1076' => 300, # B1 3.6TB 512GB #temporary api #T166205
'db1090' => 500, # C3 3.6TB 512GB
],
/* s3 */ 'DEFAULT' => [
@@ -274,7 +274,7 @@
],
'api' => [
'db1060' => 2,
-   'db1074' => 1,
+   'db1076' => 1,
],
'watchlist' => [
'db1036' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I77bae4eb7a4b24610d18b391da84bdb82684708a
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 db1076"

2017-06-07 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/357756

to review the following change.


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

Revert "db-eqiad.php: Depool db1076"

This reverts commit 7db9ff659f044de7af549469756d29e3ad6e10ca.

Change-Id: I8de8776511305ff5a2b85ac5b6d7afe7b758420d
---
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/56/357756/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 7339a5d..efff5cf 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
'db1060' => 1,   # C2 2.8TB  96GB, api
'db1074' => 300, # A2 3.6TB 512GB, api
-#  'db1076' => 500, # B1 3.6TB 512GB #T166205
+   'db1076' => 500, # B1 3.6TB 512GB
'db1090' => 500, # C3 3.6TB 512GB
],
/* s3 */ 'DEFAULT' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8de8776511305ff5a2b85ac5b6d7afe7b758420d
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]: Revert "db-eqiad.php: Depool db1074"

2017-06-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/357971

to review the following change.


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

Revert "db-eqiad.php: Depool db1074"

This reverts commit 2945514a25b98487706bf49f1bad0babd87d66dc.

Change-Id: Ifc216d198bd7c81f807574c3c12df3c97137b4fb
---
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/71/357971/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9784d1f..efff5cf 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -111,8 +111,8 @@
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1060' => 1,   # C2 2.8TB  96GB, api
-#  'db1074' => 300, # A2 3.6TB 512GB, api #T166205
-   'db1076' => 300, # B1 3.6TB 512GB #temporary api #T166205
+   'db1074' => 300, # A2 3.6TB 512GB, api
+   'db1076' => 500, # B1 3.6TB 512GB
'db1090' => 500, # C3 3.6TB 512GB
],
/* s3 */ 'DEFAULT' => [
@@ -274,7 +274,7 @@
],
'api' => [
'db1060' => 2,
-   'db1076' => 1,
+   'db1074' => 1,
],
'watchlist' => [
'db1036' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifc216d198bd7c81f807574c3c12df3c97137b4fb
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]: Revert "db-eqiad.php: Depool db1056"

2017-06-08 Thread Marostegui (Code Review)

Hello jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1056"

This reverts commit 52efc21c435cd403ff4871cb8ece0cee3a8ddd78.

Change-Id: Ife505306ae86d1de4128244ddd3117a120f2f393
---
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/72/357972/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index efff5cf..24b8792 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -127,7 +127,7 @@
's4' => [
'db1068' => 0,   # D1 2.8TB 160GB, master
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T166206
+   '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 - new sanitarium
'db1081' => 300, # A2 3.6TB 512GB, api
@@ -328,23 +328,23 @@
],
'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/357972
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ife505306ae86d1de4128244ddd3117a120f2f393
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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: Repool db1089 with less weight

2017-06-12 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/358394 )

Change subject: db-eqiad.php: Repool db1089 with less weight
..

db-eqiad.php: Repool db1089 with less weight

Change-Id: Idd5638c75b9619f5560de0393991ad04c34d4df3
---
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/94/358394/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index b98f4cb..c1768e9 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -103,7 +103,7 @@
'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 #T166935 - still needs raid 
firmware upgrade
+   'db1089' => 100, # C3 3.6TB 512GB #T166935 - still needs raid 
firmware upgrade
],
's2' => [
'db1054' => 0,   # A3 2.8TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idd5638c75b9619f5560de0393991ad04c34d4df3
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: Add db2072 to s1

2017-06-20 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360318 )

Change subject: s1.hosts: Add db2072 to s1
..

s1.hosts: Add db2072 to s1

Bug: T168356
Change-Id: I0d69cba80a806ea31bc039c37f99336e1c728418
---
M dbtools/s1.hosts
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/18/360318/1

diff --git a/dbtools/s1.hosts b/dbtools/s1.hosts
index 73fca00..e1a6387 100644
--- a/dbtools/s1.hosts
+++ b/dbtools/s1.hosts
@@ -1,3 +1,4 @@
+db2072.codfw.wmnet 3306
 db2034.codfw.wmnet 3306
 db2042.codfw.wmnet 3306
 db2048.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0d69cba80a806ea31bc039c37f99336e1c728418
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]: Revert "db-eqiad.php: Depool db1087"

2017-06-20 Thread Marostegui (Code Review)

Hello jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1087"

This reverts commit 3c90fabba911365d56848fd02b924f06ec2b5b1f.

Change-Id: I62a4e60a019440e3108ca0c1fb68e6bc6188076b
---
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/04/360604/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index e7dc414..efa5635 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
-#  'db1087' => 500, # C2 3.6TB 512GB #T166207
+   'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I62a4e60a019440e3108ca0c1fb68e6bc6188076b
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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 db1070

2017-06-21 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360616 )

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

db-eqiad.php: Depool db1070

db1070 needs alter table
pool db1049 temporarily for vslow service

Bug: T166207
Change-Id: I953e39b49a0c6eea0b1b15d24b474da1bacbca79
---
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/16/360616/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 40a9c4b..bca90b1 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -140,10 +140,10 @@
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
-#  'db1049' => 1,   # B1 2.8TB  64GB, old master
+   'db1049' => 1,   # B1 2.8TB  64GB, old master #temporary vslow 
T166207
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
+#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T166207
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
@@ -352,10 +352,10 @@
],
's5' => [
'vslow' => [
-   'db1070' => 1,
+   'db1049' => 1,
],
'dump' => [
-   'db1070' => 1,
+   'db1049' => 1,
],
'api' => [
'db1071' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I953e39b49a0c6eea0b1b15d24b474da1bacbca79
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 db1021"

2017-06-20 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/360602

to review the following change.


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

Revert "db-eqiad.php: Depool db1021"

This reverts commit 8160fc96d0da3daa02a5574c42856c0522393cab.

Change-Id: I8a33cfc31c9ff68ea87dbd1c9dcad7f863828989
---
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/02/360602/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a3677b8..e82074e 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -110,8 +110,8 @@
],
's2' => [
'db1054' => 0,   # A3 2.8TB  96GB, master
-   'db1018' => 0,   # B1 1.4TB  64GB, old master 2 #temporary vslow
-#  'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump #T166205
+#  'db1018' => 0,   # B1 1.4TB  64GB, old master 2
+   'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1060' => 1,   # C2 2.8TB  96GB, api
'db1074' => 300, # A2 3.6TB 512GB, api
@@ -270,10 +270,10 @@
],
's2' => [
'vslow' => [
-   'db1018' => 1,
+   'db1021' => 1,
],
'dump' => [
-   'db1018' => 1,
+   'db1021' => 1,
],
'api' => [
'db1060' => 2,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8a33cfc31c9ff68ea87dbd1c9dcad7f863828989
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-codfw.php: Depool db2066

2017-06-21 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360607 )

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

db-codfw.php: Depool db2066

Going to export s5 from db2066 to dbstore2001

Bug: T168354
Change-Id: I2427aa730b3cef05a43825ed570b9e1c64092f29
---
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/360607/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 2184636..88d14f7 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -133,7 +133,7 @@
'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
+#  'db2066' => 400, # D6 3.3TB 160GB #T168354
],
's6' => [
'db2028' => 0,   # B6  2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2427aa730b3cef05a43825ed570b9e1c64092f29
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 db1082

2017-06-21 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360605 )

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

db-eqiad.php: Depool db1082

db1082 needs an alter table
add db1087 to api service to help temporarily

Bug: T166207
Change-Id: Iac74a0f8134ceb6e616a3cc4fe3c317aedecea2f
---
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/05/360605/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 40a9c4b..e0300c8 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -145,8 +145,8 @@
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
-   'db1082' => 300, # A2 3.6TB 512GB, api
-   'db1087' => 500, # C2 3.6TB 512GB
+#  'db1082' => 300, # A2 3.6TB 512GB, api #T166207
+   'db1087' => 300, # C2 3.6TB 512GB #temporary help with api 
#T166207
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
@@ -359,7 +359,7 @@
],
'api' => [
'db1071' => 1,
-   'db1082' => 1,
+   'db1087' => 1,
],
'watchlist' => [
'db1026' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iac74a0f8134ceb6e616a3cc4fe3c317aedecea2f
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 db1082"

2017-06-21 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/360614

to review the following change.


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

Revert "db-eqiad.php: Depool db1082"

This reverts commit e65831c5f41f397b6139e2536d36123576878ad9.

Change-Id: Ib16256fbd8a6f1fe789140971a63c2985718a487
---
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/14/360614/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index e0300c8..40a9c4b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -145,8 +145,8 @@
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
-#  'db1082' => 300, # A2 3.6TB 512GB, api #T166207
-   'db1087' => 300, # C2 3.6TB 512GB #temporary help with api 
#T166207
+   'db1082' => 300, # A2 3.6TB 512GB, api
+   'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
@@ -359,7 +359,7 @@
],
'api' => [
'db1071' => 1,
-   'db1087' => 1,
+   'db1082' => 1,
],
'watchlist' => [
'db1026' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib16256fbd8a6f1fe789140971a63c2985718a487
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: Depool db1071

2017-06-20 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360214 )

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

db-eqiad.php: Depool db1071

db1071 needs an alter table
lower db1082's weight while db1071 is out

Bug: T166207
Change-Id: I4259d1fa8f38b045df41fa882bb975192276af72
---
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/14/360214/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index efa5635..0439fea 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,8 +144,8 @@
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
-   'db1071' => 50,  # D1 2.8TB 160GB, api
-   'db1082' => 300, # A2 3.6TB 512GB, api
+#  'db1071' => 50,  # D1 2.8TB 160GB, api #T166207
+   'db1082' => 50, # A2 3.6TB 512GB, api #low weight T166207
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
],
@@ -358,7 +358,7 @@
'db1070' => 1,
],
'api' => [
-   'db1071' => 1,
+#  'db1071' => 1,
'db1082' => 1,
],
'watchlist' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4259d1fa8f38b045df41fa882bb975192276af72
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 db1070"

2017-06-19 Thread Marostegui (Code Review)

Hello jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1070"

This reverts commit 6ae4548bce04f06bce238f591e61b86b689186a8.

Change-Id: Ia58761ff29b312ad0e474797e2313f3981335618
---
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/40/359940/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 496ee38..2939ee1 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -137,10 +137,10 @@
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
-#  'db1049' => 0,   # B1 2.8TB  64GB, old master #temporary vslow 
#T153743 
+#  'db1049' => 0,   # B1 2.8TB  64GB, old master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
+   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
@@ -349,10 +349,10 @@
],
's5' => [
'vslow' => [
-   'db1049' => 1,
+   'db1070' => 1,
],
'dump' => [
-   'db1049' => 1,
+   'db1070' => 1,
],
'api' => [
'db1071' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia58761ff29b312ad0e474797e2313f3981335618
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
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: Repool db1070

2017-06-19 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/359941 )

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

db-eqiad.php: Repool db1070

db1070 is now ready to go back in service after exporting all its tables
to db1095

Change-Id: I7d20deac7ac0d6e8204b1c23ace0a530e7255487
---
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/41/359941/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a3677b8..efa5635 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -140,10 +140,10 @@
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
-   'db1049' => 1,   # B1 2.8TB  64GB, old master #temporary vslow 
#T153743
+#  'db1049' => 1,   # B1 2.8TB  64GB, old master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
+   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
@@ -352,10 +352,10 @@
],
's5' => [
'vslow' => [
-   'db1049' => 1,
+   'db1070' => 1,
],
'dump' => [
-   'db1049' => 1,
+   'db1070' => 1,
],
'api' => [
'db1071' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I7d20deac7ac0d6e8204b1c23ace0a530e7255487
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: wikitech servers to use core grants

2017-06-19 Thread Marostegui (Code Review)

Marostegui has submitted this change and it was merged. ( 
https://gerrit.wikimedia.org/r/359152 )

Change subject: mariadb: wikitech servers to use core grants
..


mariadb: wikitech servers to use core grants

silver and labstest2001 servers should now use all the privileges from
core

Delete the wikitech.sql.erb file as it is not used anywhere else

Bug: T167961
Change-Id: I339c8e4a8ac84df8be3e071aae23472991403540
---
M modules/role/manifests/mariadb/wikitech.pp
D modules/role/templates/mariadb/grants/wikitech.sql.erb
2 files changed, 1 insertion(+), 29 deletions(-)

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



diff --git a/modules/role/manifests/mariadb/wikitech.pp 
b/modules/role/manifests/mariadb/wikitech.pp
index a75fad9..b1ee818 100644
--- a/modules/role/manifests/mariadb/wikitech.pp
+++ b/modules/role/manifests/mariadb/wikitech.pp
@@ -6,7 +6,7 @@
 }
 
 include ::standard
-include role::mariadb::grants::wikitech
+include role::mariadb::grants::core
 include role::mariadb::monitor
 include passwords::misc::scripts
 class { 'role::mariadb::groups':
diff --git a/modules/role/templates/mariadb/grants/wikitech.sql.erb 
b/modules/role/templates/mariadb/grants/wikitech.sql.erb
deleted file mode 100644
index fd05131..000
--- a/modules/role/templates/mariadb/grants/wikitech.sql.erb
+++ /dev/null
@@ -1,28 +0,0 @@
--- queries from tin
-
-GRANT ALL PRIVILEGES
-ON `labswiki`.* TO 'wikiadmin'@'10.64.0.196'
-IDENTIFIED BY '<%= @wikiadmin_pass %>';
-
--- queries from naos
-
-GRANT ALL PRIVILEGES
-ON `labswiki`.* TO 'wikiadmin'@'10.192.32.22'
-IDENTIFIED BY '<%= @wikiadmin_pass %>';
-
--- queries from terbium
-
-GRANT ALL PRIVILEGES
-ON `labswiki`.* TO 'wikiadmin'@'10.64.32.13'
-IDENTIFIED BY '<%= @wikiadmin_pass %>';
-
--- queries from wasat
-
-GRANT ALL PRIVILEGES
-ON `labswiki`.* TO 'wikiadmin'@'10.192.48.45'
-IDENTIFIED BY '<%= @wikiadmin_pass %>';
-
--- queries from horizon.wikimedia.org
-GRANT select
-ON `labswiki`.* TO 'oathreader'@'208.80.153.248'
-IDENTIFIED BY '<%= @oathreader_pass %>';

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I339c8e4a8ac84df8be3e071aae23472991403540
Gerrit-PatchSet: 3
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Andrew Bogott 
Gerrit-Reviewer: BryanDavis 
Gerrit-Reviewer: Chasemp 
Gerrit-Reviewer: Giuseppe Lavagetto 
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: Make db1060 s2 sanitarium2 master

2017-06-20 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360329 )

Change subject: db-eqiad.php: Make db1060 s2 sanitarium2 master
..

db-eqiad.php: Make db1060 s2 sanitarium2 master

I have thought about db1060 as future master for sanitarium2 instead of
any of the others old ones, because this one will not be decommissioned
as part of the old hosts decommission.

Open for ideas if any other host looks more suitable for the role

Bug: T153743

Change-Id: I672ac53ebe4c9ede82ca5f5f943e0bd4b62aefa5
---
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/29/360329/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0439fea..396a907 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -113,7 +113,7 @@
'db1018' => 0,   # B1 1.4TB  64GB, old master 2 #temporary vslow
 #  'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump #T166205
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1060' => 1,   # C2 2.8TB  96GB, api
+   'db1060' => 1,   # C2 2.8TB  96GB, api #master for sanitarium 
#T153743
'db1074' => 300, # A2 3.6TB 512GB, api
'db1076' => 500, # B1 3.6TB 512GB
'db1090' => 500, # C3 3.6TB 512GB

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I672ac53ebe4c9ede82ca5f5f943e0bd4b62aefa5
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 db1071"

2017-06-20 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/360342

to review the following change.


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

Revert "db-eqiad.php: Depool db1071"

This reverts commit 06c46851ad4fbb8598371488e8c6fb41e462355c.

Change-Id: Ie74f206295b491c8dc6c84aad9fb1621779989d9
---
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/42/360342/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0439fea..efa5635 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,8 +144,8 @@
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
-#  'db1071' => 50,  # D1 2.8TB 160GB, api #T166207
-   'db1082' => 50, # A2 3.6TB 512GB, api #low weight T166207
+   'db1071' => 50,  # D1 2.8TB 160GB, api
+   'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
],
@@ -358,7 +358,7 @@
'db1070' => 1,
],
'api' => [
-#  'db1071' => 1,
+   'db1071' => 1,
'db1082' => 1,
],
'watchlist' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie74f206295b491c8dc6c84aad9fb1621779989d9
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: Depool db1087

2017-06-20 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360347 )

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

db-eqiad.php: Depool db1087

db1087 needs alter table

Bug: T166207
Change-Id: I48d8507cd16fb8f0828d8b6602687ddd43217466
---
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/47/360347/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index efa5635..e7dc414 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
-   'db1087' => 500, # C2 3.6TB 512GB
+#  'db1087' => 500, # C2 3.6TB 512GB #T166207
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I48d8507cd16fb8f0828d8b6602687ddd43217466
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 db1070"

2017-06-21 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/360644

to review the following change.


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

Revert "db-eqiad.php: Depool db1070"

This reverts commit f34e104e4a238b42ceea1ac6b5b5a23b2d69e0da.

Change-Id: I8572a2d6bd32ee99553b43644acefbc86d6b6bcd
---
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/44/360644/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index bca90b1..40a9c4b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -140,10 +140,10 @@
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
-   'db1049' => 1,   # B1 2.8TB  64GB, old master #temporary vslow 
T166207
+#  'db1049' => 1,   # B1 2.8TB  64GB, old master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T166207
+   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
@@ -352,10 +352,10 @@
],
's5' => [
'vslow' => [
-   'db1049' => 1,
+   'db1070' => 1,
],
'dump' => [
-   'db1049' => 1,
+   'db1070' => 1,
],
'api' => [
'db1071' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8572a2d6bd32ee99553b43644acefbc86d6b6bcd
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: Depool db1045

2017-06-21 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360645 )

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

db-eqiad.php: Depool db1045

db1045 needs an alter table

Bug: T166207
Change-Id: Iff888e5597bc49827ad5ae366fc3a59eeb40a1c2
---
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/45/360645/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 40a9c4b..c2844f0 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -142,7 +142,7 @@
'db1063' => 0,   # C5 2.8TB 128GB, master
 #  'db1049' => 1,   # B1 2.8TB  64GB, old master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T166207
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
@@ -363,23 +363,23 @@
],
'watchlist' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'recentchanges' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'recentchangeslinked' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'contributions' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'logpager' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
],
's6' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iff888e5597bc49827ad5ae366fc3a59eeb40a1c2
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 db1045"

2017-06-22 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/360798

to review the following change.


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

Revert "db-eqiad.php: Depool db1045"

This reverts commit 2d4810f25bf8030904770fb3c3c8ca33fbcfd7ad.

Change-Id: I5a8af27d2a764a7941ff7f8db5ef8f9f1d2fcf6e
---
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/98/360798/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c2844f0..40a9c4b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -142,7 +142,7 @@
'db1063' => 0,   # C5 2.8TB 128GB, master
 #  'db1049' => 1,   # B1 2.8TB  64GB, old master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T166207
+   'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
'db1082' => 300, # A2 3.6TB 512GB, api
@@ -363,23 +363,23 @@
],
'watchlist' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'recentchanges' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'recentchangeslinked' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'contributions' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'logpager' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
],
's6' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I5a8af27d2a764a7941ff7f8db5ef8f9f1d2fcf6e
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: Depool db1026

2017-06-22 Thread Marostegui (Code Review)

Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/360799 )

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

db-eqiad.php: Depool db1026

db1026 needs an alter table

Bug: T166207
Change-Id: I0a58501ff995f4fc18f1ef04ae935104f08325b6
---
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/99/360799/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 40a9c4b..b8e1ce5 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -141,7 +141,7 @@
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
 #  'db1049' => 1,   # B1 2.8TB  64GB, old master
-   'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T166207
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
@@ -362,23 +362,23 @@
'db1082' => 1,
],
'watchlist' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'recentchanges' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'recentchangeslinked' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'contributions' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'logpager' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0a58501ff995f4fc18f1ef04ae935104f08325b6
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 db1026"

2017-06-22 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/361025

to review the following change.


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

Revert "db-eqiad.php: Depool db1026"

This reverts commit 660006a01684595022c2dc820d1131c31e8bb128.

Change-Id: Ibc0491d2cbe74a3998149625a52ee5415dc4c534
---
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/25/361025/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index b8e1ce5..40a9c4b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -141,7 +141,7 @@
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
 #  'db1049' => 1,   # B1 2.8TB  64GB, old master
-#  'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T166207
+   'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, api
@@ -362,23 +362,23 @@
'db1082' => 1,
],
'watchlist' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'recentchanges' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'recentchangeslinked' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'contributions' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'logpager' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibc0491d2cbe74a3998149625a52ee5415dc4c534
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

< 3 4 5 6 7 8 9 10 11 12 >

701 - 800 of 1966 matches

Mail list logo