from:"Marostegui \(Code Review\)"

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

2017-08-30 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Increase db1053 weight
..

db-eqiad.php: Increase db1053 weight

Bug: T168661
Change-Id: Ibc028711b3b582aed989e750c6672580b82b6dc3
---
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/374804/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index d23f9ef..116254f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -350,7 +350,7 @@
'db1056' => 1,
],
'recentchangeslinked' => [
-   # 'db1053' => 1,
+   'db1053' => 1,
'db1056' => 1,
],
'contributions' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibc028711b3b582aed989e750c6672580b82b6dc3
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 db1055 with full weight

2017-08-30 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Repool db1055 with full weight
..

db-eqiad.php: Repool db1055 with full weight

Bug: T174265
Change-Id: I2a41d317776e6ec942571676f221420215412085
---
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/87/374787/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 954c677..dcaf0d6 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -266,7 +266,7 @@
],
'logpager' => [
'db1051' => 1,
-   # 'db1055' => 1,
+   'db1055' => 1,
],
'dump' => [
'db1065' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2a41d317776e6ec942571676f221420215412085
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: Update db1053 socket location

2017-08-30 Thread Marostegui (Code Review)

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

Change subject: mariadb: Update db1053 socket location
..


mariadb: Update db1053 socket location

Given that db1053 needs to get its mariadb upgraded, update its socket
location.

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

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



diff --git a/hieradata/hosts/db1053.yaml b/hieradata/hosts/db1053.yaml
index 958da0b..7db8adb 100644
--- a/hieradata/hosts/db1053.yaml
+++ b/hieradata/hosts/db1053.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's4'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I78402ae3fc867762b1c482e7419ac7c082311700
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]: db-eqiad.php: Depool db1053

2017-08-30 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1053

db1053 needs its MariaDB upgraded to 10.0.32

Bug: T168661
Change-Id: Ic1685a9f90ae54d7dd32077d0067789cb58a48aa
---
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/92/374792/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index dcaf0d6..1d331f4 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,7 @@
],
's4' => [
'db1068' => 0,   # D1 2.8TB 160GB, master
-   'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+   # 'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager # T168661
'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
@@ -342,23 +342,23 @@
'db1081' => 2,
],
'watchlist' => [
-   'db1053' => 1,
+   # 'db1053' => 1,
'db1056' => 1,
],
'recentchanges' => [
-   'db1053' => 1,
+   # 'db1053' => 1,
'db1056' => 1,
],
'recentchangeslinked' => [
-   'db1053' => 1,
+   # 'db1053' => 1,
'db1056' => 1,
],
'contributions' => [
-   'db1053' => 1,
+   # 'db1053' => 1,
'db1056' => 1,
],
'logpager' => [
-   'db1053' => 1,
+   # 'db1053' => 1,
'db1056' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic1685a9f90ae54d7dd32077d0067789cb58a48aa
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 db1053 with low weight

2017-08-30 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Repool db1053 with low weight

After its MariaDB upgrade, repool it with low weight

Bug: T168661
Change-Id: I82e385b92724bee42d2c7ebb1a17cf85058937fc
---
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/96/374796/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 1d331f4..baa0d89 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,7 @@
],
's4' => [
'db1068' => 0,   # D1 2.8TB 160GB, master
-   # 'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager # T168661
+   'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1059' => 1,   # C2 2.8TB  96GB, api
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium
@@ -342,7 +342,7 @@
'db1081' => 2,
],
'watchlist' => [
-   # 'db1053' => 1,
+   'db1053' => 1,
'db1056' => 1,
],
'recentchanges' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I82e385b92724bee42d2c7ebb1a17cf85058937fc
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 weight for db1053

2017-08-30 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Increase weight for db1053
..

db-eqiad.php: Increase weight for db1053

Bug: T168661
Change-Id: I0898020a19b3b12eb9538c8563e9ac484512838d
---
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/09/374809/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 116254f..e94ae29 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -354,7 +354,7 @@
'db1056' => 1,
],
'contributions' => [
-   # 'db1053' => 1,
+   'db1053' => 1,
'db1056' => 1,
],
'logpager' => [

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

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

2017-09-01 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1081

db1081 needs mariadb upgraded, repool db1097 for api temporarily

Bug: T168661
Change-Id: I2bd31cb6dee43ed14ea4a6370dac9fc2ed848ef4
---
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/58/375358/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index dcaf0d6..8d4566f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -137,10 +137,10 @@
'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
+   # 'db1081' => 300, # A2 3.6TB 512GB, api # T168661
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
-   'db1097' => 0,   # D1 3.6TB 512GB, old master
+   'db1097' => 100,   # D1 3.6TB 512GB, old master #temporary api 
# T168661
],
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
@@ -339,7 +339,7 @@
],
'api' => [
'db1059' => 1,
-   'db1081' => 2,
+   'db1097' => 2,
],
'watchlist' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2bd31cb6dee43ed14ea4a6370dac9fc2ed848ef4
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: Update db1081 socket location

2017-09-01 Thread Marostegui (Code Review)

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

Change subject: mariadb: Update db1081 socket location
..

mariadb: Update db1081 socket location

db1081 needs to get its mariadb upgraded, so updating its socket path
too

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


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/59/375359/1

diff --git a/hieradata/hosts/db1081.yaml b/hieradata/hosts/db1081.yaml
index 958da0b..7db8adb 100644
--- a/hieradata/hosts/db1081.yaml
+++ b/hieradata/hosts/db1081.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's4'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2e3512bbe55cfd624853c0f8aa954c4cf692516c
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: Update db1081 socket location

2017-09-01 Thread Marostegui (Code Review)

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

Change subject: mariadb: Update db1081 socket location
..


mariadb: Update db1081 socket location

db1081 needs to get its mariadb upgraded, so updating its socket path
too

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

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



diff --git a/hieradata/hosts/db1081.yaml b/hieradata/hosts/db1081.yaml
index 958da0b..7db8adb 100644
--- a/hieradata/hosts/db1081.yaml
+++ b/hieradata/hosts/db1081.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's4'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I2e3512bbe55cfd624853c0f8aa954c4cf692516c
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]: db-eqiad.php: Repool db1081 with low weight

2017-09-01 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Repool db1081 with low weight

Bug: T168661
Change-Id: I05aba85aad2631b6e63a47c35653875a75777149
---
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/62/375362/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8d4566f..0dba37a 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -137,7 +137,7 @@
'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 # T168661
+   'db1081' => 100, # A2 3.6TB 512GB, api # T168661
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
'db1097' => 100,   # D1 3.6TB 512GB, old master #temporary api 
# T168661

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

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

2017-08-31 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1056

db1056 needs a MariaDB upgrade

Bug: T168661
Change-Id: Iaed5d652e12a377e3c346e5694f3fae8f048b37c
---
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/26/374926/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index dcaf0d6..0d72493 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -134,7 +134,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 T168661
'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
@@ -343,23 +343,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/374926
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iaed5d652e12a377e3c346e5694f3fae8f048b37c
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: Update db1056 socket location

2017-08-31 Thread Marostegui (Code Review)

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

Change subject: mariadb: Update db1056 socket location
..

mariadb: Update db1056 socket location

As its mariadb is going to be upgraded, update the path to its socket

Change-Id: Icd6bdeed295d5258e7b44f2e84f84403b150a876
---
M hieradata/hosts/db1056.yaml
1 file changed, 0 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/33/374933/1

diff --git a/hieradata/hosts/db1056.yaml b/hieradata/hosts/db1056.yaml
index 958da0b..7db8adb 100644
--- a/hieradata/hosts/db1056.yaml
+++ b/hieradata/hosts/db1056.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's4'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Icd6bdeed295d5258e7b44f2e84f84403b150a876
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: Update db1056 socket location

2017-08-31 Thread Marostegui (Code Review)

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

Change subject: mariadb: Update db1056 socket location
..


mariadb: Update db1056 socket location

As its mariadb is going to be upgraded, update the path to its socket

Change-Id: Icd6bdeed295d5258e7b44f2e84f84403b150a876
---
M hieradata/hosts/db1056.yaml
1 file changed, 0 insertions(+), 1 deletion(-)

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



diff --git a/hieradata/hosts/db1056.yaml b/hieradata/hosts/db1056.yaml
index 958da0b..7db8adb 100644
--- a/hieradata/hosts/db1056.yaml
+++ b/hieradata/hosts/db1056.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's4'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Icd6bdeed295d5258e7b44f2e84f84403b150a876
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]: db-eqiad.php: Repool db1056 with low weight

2017-08-31 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Repool db1056 with low weight

MariaDB has been upgraded, slowly repool it

Bug: T168661
Change-Id: Iee9be27933b77290c979ed5623a0b305276cb0c2
---
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/45/374945/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0d72493..f265afa 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -134,7 +134,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 T168661
+   '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
@@ -343,7 +343,7 @@
],
'watchlist' => [
'db1053' => 1,
-   # 'db1056' => 1,
+   'db1056' => 1,
],
'recentchanges' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iee9be27933b77290c979ed5623a0b305276cb0c2
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 weight on db1056

2017-08-31 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Increase weight on db1056
..

db-eqiad.php: Increase weight on db1056

Bug: T168661
Change-Id: I84bb31af54b80eb4d3593e836ee06405c14cadd5
---
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/48/374948/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f265afa..8b8aa6b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -347,7 +347,7 @@
],
'recentchanges' => [
'db1053' => 1,
-   # 'db1056' => 1,
+   'db1056' => 1,
],
'recentchangeslinked' => [
'db1053' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I84bb31af54b80eb4d3593e836ee06405c14cadd5
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: Provision db2079 into s5

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: mariadb: Provision db2079 into s5
..


mariadb: Provision db2079 into s5

db2079 will serve in s5 and later s8

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

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



diff --git a/hieradata/hosts/db2079.yaml b/hieradata/hosts/db2079.yaml
new file mode 100644
index 000..0ea867a
--- /dev/null
+++ b/hieradata/hosts/db2079.yaml
@@ -0,0 +1,2 @@
+mariadb::shard: 's5'
+profile::base::notifications_enabled: '0'
diff --git a/manifests/site.pp b/manifests/site.pp
index 47df907..954b2ba 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -467,7 +467,7 @@
 role(mariadb::core)
 }
 
-node /^db20(38|45|52|59|66|75)\.codfw\.wmnet/ {
+node /^db20(38|45|52|59|66|75|79)\.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 4c71560..3323cf5 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -74,6 +74,7 @@
   - db2059:9104
   - db2066:9104
   - db2075:9104
+  - db2079:9104
 - labels:
 shard: s5
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Iea42b692d22956958e2a9e5243708f0f9847c1f4
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 db2075

2017-10-09 Thread Marostegui (Code Review)

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

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

db-codfw.php: Depool db2075

db2075 is going to be used to clone db2079

Bug: T170662
Change-Id: Id5f7b35fcd75c33a9232ed4cff83833ee374590f
---
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/68/383068/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 4c333b1..280d5b9 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -145,7 +145,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 # Compressed InnoDB
+   # 'db2075' => 400, # A1 3.3TB 512GB # Compressed InnoDB #T170662
],
's6' => [
'db2028' => 0,   # B6  2.9TB  96GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id5f7b35fcd75c33a9232ed4cff83833ee374590f
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]: s5.hosts: Add db2079

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: s5.hosts: Add db2079
..

s5.hosts: Add db2079

db2079 is going to be cloned from db2075 and will serve on s5 and later
on s8.

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


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/69/383069/1

diff --git a/dbtools/s5.hosts b/dbtools/s5.hosts
index 37b86bc..6f9da5c 100644
--- a/dbtools/s5.hosts
+++ b/dbtools/s5.hosts
@@ -1,4 +1,5 @@
 dbstore2001.codfw.wmnet3315
+db2079.codfw.wmnet 3306
 db2075.codfw.wmnet 3306
 db2038.codfw.wmnet 3306
 db2045.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I84e611e4c2c68637b91d26e1a7492fd6ffd2a6a8
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-eqiad, db-codfw.php: Add db2079 the config

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: db-eqiad,db-codfw.php: Add db2079 the config
..

db-eqiad,db-codfw.php: Add db2079 the config

db2079 is being cloned from db2075 and will serve in s5 and later in s8.
Add it depooled to the config for now.

Bug: T170662
Change-Id: I10df8ed96bb9f92ee33801b13c20c20fcce4346e
---
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/70/383070/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 280d5b9..8172e69 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -146,6 +146,7 @@
'db2059' => 100, # D6 3.3TB 160GB, api
'db2066' => 400, # D6 3.3TB 160GB
# 'db2075' => 400, # A1 3.3TB 512GB # Compressed InnoDB #T170662
+   # 'db2079' => 400, # A5 3.3TB 512GB # Compressed InnoDB #T170662
],
's6' => [
'db2028' => 0,   # B6  2.9TB  96GB, master
@@ -581,6 +582,7 @@
'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
+   'db2079' => '10.192.0.6', # 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 91752c2..74c388d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -592,6 +592,7 @@
'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
+   'db2079' => '10.192.0.6', # 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/383070
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I10df8ed96bb9f92ee33801b13c20c20fcce4346e
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]: db1080.yaml: Update socket path

2017-10-08 Thread Marostegui (Code Review)

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

Change subject: db1080.yaml: Update socket path
..

db1080.yaml: Update socket path

Change-Id: Ib33aabea66634524ec780d4c2258749355179550
---
M hieradata/hosts/db1080.yaml
1 file changed, 0 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/56/383056/1

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

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

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

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

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

2017-10-08 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1091

Optimize pagelinks and templatelinks table

Bug: T174509
Change-Id: I0503de6823f36c451d670c8ce99f386265b004b7
---
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/58/383058/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 065336f..54e55ea 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -137,7 +137,7 @@
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium
'db1081' => 300, # A2 3.6TB 512GB, api
'db1084' => 500, # B1 3.6TB 512GB
-   'db1091' => 500, # D2 3.6TB 512GB
+   # 'db1091' => 500, # D2 3.6TB 512GB #T174509
'db1097' => 1,   # D1 3.6TB 512GB, api, old master
],
's5' => [

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

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

2017-10-08 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1083

Optimize pagelinks and templatelinks

Bug: T174509
Change-Id: I9b76d1e282b44540522365c823e0b86418052f04
---
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/55/383055/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 072857a..72d18cf 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -110,7 +110,7 @@
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 300, # A2 3.6TB 512GB, api #T172679#3650005
-   'db1083' => 500, # B1 3.6TB 512GB
+   # 'db1083' => 500, # B1 3.6TB 512GB #T174509
'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9b76d1e282b44540522365c823e0b86418052f04
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]: db1083.yaml: Update socket path

2017-10-08 Thread Marostegui (Code Review)

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

Change subject: db1083.yaml: Update socket path
..


db1083.yaml: Update socket path

Change-Id: Ib33aabea66634524ec780d4c2258749355179550
---
M hieradata/hosts/db1083.yaml
1 file changed, 0 insertions(+), 1 deletion(-)

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



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

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ib33aabea66634524ec780d4c2258749355179550
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.php: Depool db1090

2017-10-08 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1090

Going to optimize pagelinks and templatelinks

Bug: T174509
Change-Id: I0e5b20c1a16e99ca71a907f7561d3048296c3d87
---
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/383057/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 72d18cf..065336f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -119,7 +119,7 @@
'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
+   # 'db1090' => 500, # C3 3.6TB 512GB #T174509
'db1101' => 1,   # C2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager, old master 2
],
/* s3 */ 'DEFAULT' => [

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

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

2017-10-09 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1096

Going to optimize pagelinks and templatelinks

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 54e55ea..91752c2 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -147,7 +147,7 @@
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
-   'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
+   # 'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager #T174509
'db1099' => 1,   # B2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
# 'db1100' => 1,   # C2 3.6TB 512GB, old master, crashed
# 'db1104' => 100,  # B3 3.6TB 512GB # Cloning db1106
@@ -372,23 +372,23 @@
'db1082' => 1,
],
'watchlist' => [
-   'db1096' => 1,
+   # 'db1096' => 1,
'db1099' => 1,
],
'recentchanges' => [
-   'db1096' => 1,
+   # 'db1096' => 1,
'db1099' => 1,
],
'recentchangeslinked' => [
-   'db1096' => 1,
+   # 'db1096' => 1,
'db1099' => 1,
],
'contributions' => [
-   'db1096' => 1,
+   # 'db1096' => 1,
'db1099' => 1,
],
'logpager' => [
-   'db1096' => 1,
+   # 'db1096' => 1,
'db1099' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic1868dab85deb09b4e9822fc48365c74e33d9375
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: Provision db2079 into s5

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: mariadb: Provision db2079 into s5
..

mariadb: Provision db2079 into s5

db2079 will serve in s5 and later s8

Bug: T170662
Change-Id: Iea42b692d22956958e2a9e5243708f0f9847c1f4
---
A hieradata/hosts/db2079.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/62/383062/1

diff --git a/hieradata/hosts/db2079.yaml b/hieradata/hosts/db2079.yaml
new file mode 100644
index 000..0d8bce2
--- /dev/null
+++ b/hieradata/hosts/db2079.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's5'
diff --git a/manifests/site.pp b/manifests/site.pp
index 47df907..954b2ba 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -467,7 +467,7 @@
 role(mariadb::core)
 }
 
-node /^db20(38|45|52|59|66|75)\.codfw\.wmnet/ {
+node /^db20(38|45|52|59|66|75|79)\.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 4c71560..3323cf5 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -74,6 +74,7 @@
   - db2059:9104
   - db2066:9104
   - db2075:9104
+  - db2079:9104
 - labels:
 shard: s5
 role: master

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

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

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

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

2017-10-09 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1080

Going to optimize templatelinks and pagelinks

Bug: T174509
Change-Id: I972fc944f7cc757fc41f1b602d7c63f55ec8f49b
---
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/05/383305/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 1264ddf..2b73727 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -106,9 +106,9 @@
'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
-   'db1066' => 50,  # D1 2.8TB 160GB, api
-   'db1073' => 50,  # B3 2.8TB 160GB, api
-   'db1080' => 300, # A2 3.6TB 512GB, api #T172679#3650005
+   'db1066' => 1,  # D1 2.8TB 160GB, api
+   'db1073' => 1,  # B3 2.8TB 160GB, api
+   # 'db1080' => 300, # A2 3.6TB 512GB, api #T172679#3650005 
#T174509
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
@@ -273,7 +273,7 @@
'db1065' => 1,
],
'api' => [
-   'db1080' => 1,
+   # 'db1080' => 1,
'db1073' => 1,
'db1066' => 1,
],

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

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

2017-10-09 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1076

Going to optimize pagelinks and templatelinks

Bug: T174509
Change-Id: Ia50b404846c9199eafd632ceb6a3f001bac489bf
---
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/06/383306/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 2b73727..2472f5d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -117,7 +117,7 @@
'db1021' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1060' => 1,   # C2 2.8TB  96GB, api #master for sanitarium 
#T153743
'db1074' => 300, # A2 3.6TB 512GB, api
-   'db1076' => 500, # B1 3.6TB 512GB
+   # 'db1076' => 500, # B1 3.6TB 512GB #T174509
'db1090' => 500, # C3 3.6TB 512GB
'db1101' => 1,   # C2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager, old master 2
],

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

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

2017-10-09 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1071

Going to optimize pagelinks and templatelinks

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 2472f5d..5af3c64 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -143,13 +143,13 @@
's5' => [
'db1063' => 0,   # C5 2.8TB 128GB, master
'db1070' => 1,   # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
-   'db1071' => 50,  # D1 2.8TB 160GB, api
+   # 'db1071' => 50,  # D1 2.8TB 160GB, api #T174509
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
'db1099' => 1,   # B2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
-   # 'db1100' => 1,   # C2 3.6TB 512GB, old master, crashed
+   'db1100' => 1,   # C2 3.6TB 512GB, old master #api #T174509
# 'db1104' => 100,  # B3 3.6TB 512GB # Cloning db1106
'db1105' => 100,  # C3 3.6TB 512GB #low weight after being 
provisioned
'db1106' => 100,  # D3 3.6TB 512GB #low weight after being 
provisioned
@@ -368,7 +368,7 @@
'db1070' => 1,
],
'api' => [
-   'db1071' => 1,
+   'db1100' => 1,
'db1082' => 1,
],
'watchlist' => [

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

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

2017-10-10 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1038

db1038 is going to be used to clone db1072, so repool db1044 temporarily
as vslow and dump

Bug: T172679
Change-Id: I160bc51fabb595dea3737de2901a3cb7970f1162
---
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/09/383309/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index e363c34..bc6751c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -123,8 +123,8 @@
],
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master
-   'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master
-   # 'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for 
db1095 - new sanitarium #T150802
+   # 'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master # 
T172679
+   'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802 # temporary vslow
# 'db1072' => 50,  # B2 2.8TB 160GB, #future vslow and dump - 
do not pool, talk to marostegui first
'db1077' => 400, # B1 3.6TB 512GB #temporary special slave - 
T172679
'db1078' => 500, # C3 3.6TB 512GB
@@ -307,10 +307,10 @@
],
/* s3 */ 'DEFAULT' => [
'vslow' => [
-   'db1038' => 1,
+   'db1044' => 1,
],
'dump' => [
-   'db1038' => 1,
+   'db1044' => 1,
],
'watchlist' => [
'db1077' => 1,

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

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

2017-10-09 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1079

Going to optimize pagelinks and templatelinks

Bug: T174509
Change-Id: Ib0b8d63ae2c64ce26daea93bce57d13250f7902f
---
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/08/383308/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5af3c64..e363c34 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -168,8 +168,8 @@
'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
# 'db1039' => 0,   # B2 1.4TB  64GB
'db1069' => 0,   # D1 2.8TB 160GB, vslow, dump, old master
-   'db1079' => 300, # A2 3.6TB 512GB, api #master for db1102 
(sanitarium 3)
-   'db1086' => 500, # B3 3.6TB 512GB, api
+   # 'db1079' => 300, # A2 3.6TB 512GB, api #master for db1102 
(sanitarium 3) #T174509
+   'db1086' => 200, # B3 3.6TB 512GB, api
'db1094' => 500, # D2 3.6TB 512GB
],
'silver' => [
@@ -426,7 +426,7 @@
'db1069' => 1,
],
'api' => [
-   'db1079' => 100,
+   # 'db1079' => 100,
'db1086' => 1,
],
'watchlist' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib0b8d63ae2c64ce26daea93bce57d13250f7902f
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: Move db1072 to s3

2017-10-10 Thread Marostegui (Code Review)

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

Change subject: mariadb: Move db1072 to s3
..


mariadb: Move db1072 to s3

db1072 will be cloned from db1038 and will replace it on the s3
vslow,dump service

Bug: T172679
Change-Id: I4c4d4300142249b95937a1c7f957e3f274dd7e27
---
M hieradata/hosts/db1072.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_eqiad.yaml
3 files changed, 4 insertions(+), 5 deletions(-)

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



diff --git a/hieradata/hosts/db1072.yaml b/hieradata/hosts/db1072.yaml
index b1bf6dc..654805a 100644
--- a/hieradata/hosts/db1072.yaml
+++ b/hieradata/hosts/db1072.yaml
@@ -1,2 +1 @@
-mariadb::shard: 's1'
-mariadb::socket: '/tmp/mysql.sock'
+mariadb::shard: 's3'
diff --git a/manifests/site.pp b/manifests/site.pp
index 0334313..7e297ba 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -329,7 +329,7 @@
 role(mariadb::core)
 }
 # eqiad replicas
-node /^db10(51|55|65|66|67|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|65|66|67|73|80|83|89)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
@@ -387,7 +387,7 @@
 role(mariadb::core)
 }
 
-node /^db1(038|044|077|078|103)\.eqiad\.wmnet/ {
+node /^db1(038|044|072|077|078|103)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index 44892d3..15cb1f9 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -6,7 +6,6 @@
   - db1055:9104
   - db1065:9104
   - db1066:9104
-  - db1072:9104
   - db1073:9104
   - db1080:9104
   - db1083:9104
@@ -40,6 +39,7 @@
   targets:
   - db1038:9104
   - db1044:9104
+  - db1072:9104
   - db1077:9104
   - db1078:9104
   - db1103:9104

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I4c4d4300142249b95937a1c7f957e3f274dd7e27
Gerrit-PatchSet: 3
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, s1.hosts: Move db1072 from s1 to s3

2017-10-10 Thread Marostegui (Code Review)

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

Change subject: s3.hosts,s1.hosts: Move db1072 from s1 to s3
..

s3.hosts,s1.hosts: Move db1072 from s1 to s3

db1072 will be cloned from db1038 and will be placed in s3 to serve
vslow and dump service.

Bug: T172679
Change-Id: I2acfe6899bce2dd4226389ad708385117cdf0ad5
---
M dbtools/s1.hosts
M dbtools/s3.hosts
2 files changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/10/383310/1

diff --git a/dbtools/s1.hosts b/dbtools/s1.hosts
index 87bfeb4..b661cb1 100644
--- a/dbtools/s1.hosts
+++ b/dbtools/s1.hosts
@@ -21,7 +21,6 @@
 db1083.eqiad.wmnet 3306
 db1089.eqiad.wmnet 3306
 db1073.eqiad.wmnet 3306
-db1072.eqiad.wmnet 3306
 db1066.eqiad.wmnet 3306
 db1065.eqiad.wmnet 3306
 db1055.eqiad.wmnet 3306
diff --git a/dbtools/s3.hosts b/dbtools/s3.hosts
index df0e797..2519de8 100644
--- a/dbtools/s3.hosts
+++ b/dbtools/s3.hosts
@@ -16,6 +16,7 @@
 db1095.eqiad.wmnet 3306
 db1038.eqiad.wmnet 3306
 db1044.eqiad.wmnet 3306
+db1072.eqiad.wmnet 3306
 db1077.eqiad.wmnet 3306
 db1078.eqiad.wmnet 3306
 db1103.eqiad.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2acfe6899bce2dd4226389ad708385117cdf0ad5
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: Provision db2080 on s5

2017-10-10 Thread Marostegui (Code Review)

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

Change subject: mariadb: Provision db2080 on s5
..

mariadb: Provision db2080 on s5

db2080 will be cloned from db2079 and will be placed in s5 and later on
s8

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


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/11/383311/1

diff --git a/hieradata/hosts/db2080.yaml b/hieradata/hosts/db2080.yaml
new file mode 100644
index 000..0ea867a
--- /dev/null
+++ b/hieradata/hosts/db2080.yaml
@@ -0,0 +1,2 @@
+mariadb::shard: 's5'
+profile::base::notifications_enabled: '0'
diff --git a/manifests/site.pp b/manifests/site.pp
index 7e297ba..b61ca36 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -467,7 +467,7 @@
 role(mariadb::core)
 }
 
-node /^db20(38|45|52|59|66|75|79)\.codfw\.wmnet/ {
+node /^db20(38|45|52|59|66|75|79|80)\.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 3323cf5..cf84683 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -75,6 +75,7 @@
   - db2066:9104
   - db2075:9104
   - db2079:9104
+  - db2080:9104
 - labels:
 shard: s5
 role: master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I5d877410363b9bb238cf809b580a8f7fca011024
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/software[master]: s5.hosts: Add db2080 to s5

2017-10-10 Thread Marostegui (Code Review)

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

Change subject: s5.hosts: Add db2080 to s5
..

s5.hosts: Add db2080 to s5

db2080 will serve on s5 and later on s8

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


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/12/383312/1

diff --git a/dbtools/s5.hosts b/dbtools/s5.hosts
index 6f9da5c..eacc119 100644
--- a/dbtools/s5.hosts
+++ b/dbtools/s5.hosts
@@ -1,4 +1,5 @@
 dbstore2001.codfw.wmnet3315
+db2080.codfw.wmnet 3306
 db2079.codfw.wmnet 3306
 db2075.codfw.wmnet 3306
 db2038.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I1a9e0ae75cd205f14b9cba87ba6881f71d07d7d3
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: Provision db2080 on s5

2017-10-10 Thread Marostegui (Code Review)

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

Change subject: mariadb: Provision db2080 on s5
..


mariadb: Provision db2080 on s5

db2080 will be cloned from db2079 and will be placed in s5 and later on
s8

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

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



diff --git a/hieradata/hosts/db2080.yaml b/hieradata/hosts/db2080.yaml
new file mode 100644
index 000..0ea867a
--- /dev/null
+++ b/hieradata/hosts/db2080.yaml
@@ -0,0 +1,2 @@
+mariadb::shard: 's5'
+profile::base::notifications_enabled: '0'
diff --git a/manifests/site.pp b/manifests/site.pp
index 7e297ba..b61ca36 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -467,7 +467,7 @@
 role(mariadb::core)
 }
 
-node /^db20(38|45|52|59|66|75|79)\.codfw\.wmnet/ {
+node /^db20(38|45|52|59|66|75|79|80)\.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 3323cf5..cf84683 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -75,6 +75,7 @@
   - db2066:9104
   - db2075:9104
   - db2079:9104
+  - db2080:9104
 - labels:
 shard: s5
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I5d877410363b9bb238cf809b580a8f7fca011024
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]: db-codfw.php: Add task to db2044

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: db-codfw.php: Add task to db2044
..

db-codfw.php: Add task to db2044

db2044 is broken so adding the task number so it can be quickly seen why
it is depooled

Change-Id: Id3ff5a509794138939ffd36eb13903e2ae490f08
---
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/16/380916/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 9a33d41..d8d920a 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -133,7 +133,7 @@
'db2051' => 0,   # B8 2.9TB 160GB, master
# 'db2019' => 0, # B6 2.9TB  96GB, old master
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
-   # 'db2044' => 50,  # C6 2.9TB 160GB, rc, log
+   # 'db2044' => 50,  # C6 2.9TB 160GB, rc, log #T174764
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 200, # D6 3.3TB 160GB, api
'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id3ff5a509794138939ffd36eb13903e2ae490f08
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 db2072 and db2071"

2017-09-27 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo,

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

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

to review the following change.


Change subject: Revert "db-codfw.php: Depool db2072 and db2071"
..

Revert "db-codfw.php: Depool db2072 and db2071"

This reverts commit 8261367a2551c38e7f2d73a376169f2b149df55a.

Change-Id: I2e8f21c6844587b4adcbe126144211dd44362660
---
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/20/380920/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 9c6cbc9..910749a 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -109,8 +109,8 @@
'db2062' => 50,  # B5 3.3TB 160GB, api # mariadb 10.1
'db2069' => 50,  # D6 3.3TB 160GB, api
'db2070' => 400, # C5 3.3TB 160GB
-   # 'db2071' => 50,  # A6 3.6TB 512GB, api T174509
-   # 'db2072' => 500, # B6 3.6TB 512GB, # mariadb 10.1 T174509
+   'db2071' => 50,  # A6 3.6TB 512GB, api
+   'db2072' => 500, # B6 3.6TB 512GB, # mariadb 10.1
],
's2' => [
'db2017' => 0,   # B6 2.9TB  96GB, master
@@ -269,7 +269,7 @@
'db2055' => 1,
'db2062' => 1,
'db2069' => 1,
-   # 'db2071' => 5,
+   'db2071' => 5,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2e8f21c6844587b4adcbe126144211dd44362660
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
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/mediawiki-config[master]: db-codfw: Depool db2070, db2069, db2042

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: db-codfw: Depool db2070, db2069, db2042
..

db-codfw: Depool db2070, db2069, db2042

Going to optimize pagelinks and templatelinks tables

Bug: T174509
Change-Id: I0d82675f50b506f56000e6cbfb29b7caa1c66fdd
---
M wmf-config/db-codfw.php
1 file changed, 10 insertions(+), 10 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 01da088..3eea06d 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -102,13 +102,13 @@
 'sectionLoads' => [
's1' => [
'db2048' => 0,   # C6 2.9TB 160GB, master
-   # 'db2016' => 0,   # B6 2.9TB  96GB, old master
+   # 'db2016' => 0,   # B6 2.9TB  96GB, old master #T174509
'db2034' => 50,  # A5 2.9TB 160GB, rc, log
-   'db2042' => 50,  # C6 2.9TB 160GB, rc, log
+   # 'db2042' => 50,  # C6 2.9TB 160GB, rc, log #T174509
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow, api
'db2062' => 50,  # B5 3.3TB 160GB, api # mariadb 10.1
-   'db2069' => 50,  # D6 3.3TB 160GB, api
-   'db2070' => 400, # C5 3.3TB 160GB
+   # 'db2069' => 50,  # D6 3.3TB 160GB, api #T174509
+   # 'db2070' => 400, # C5 3.3TB 160GB #T174509
'db2071' => 50,  # A6 3.6TB 512GB, api
'db2072' => 500, # B6 3.6TB 512GB, # mariadb 10.1
],
@@ -241,23 +241,23 @@
's1' => [
'watchlist' => [
'db2034' => 1,
-   'db2042' => 1,
+   # 'db2042' => 1,
],
'recentchanges' => [
'db2034' => 1,
-   'db2042' => 1,
+   # 'db2042' => 1,
],
'recentchangeslinked' => [
'db2034' => 1,
-   'db2042' => 1,
+   # 'db2042' => 1,
],
'contributions' => [
'db2034' => 1,
-   'db2042' => 1,
+   # 'db2042' => 1,
],
'logpager' => [
'db2034' => 1,
-   'db2042' => 1,
+   # 'db2042' => 1,
],
'dump' => [
'db2055' => 1,
@@ -268,7 +268,7 @@
'api' => [
'db2055' => 1,
'db2062' => 1,
-   'db2069' => 1,
+   # 'db2069' => 1,
'db2071' => 5,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0d82675f50b506f56000e6cbfb29b7caa1c66fdd
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 db2076, db2067, db2060

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: db-codfw.php: Depool db2076, db2067, db2060
..

db-codfw.php: Depool db2076, db2067, db2060

Going to optimize templatelinks and pagelinks tables

Bug: T174509
Change-Id: Ibd01090cae60c4c4d1451f5e47ec5e09be99b27f
---
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/22/380922/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 3eea06d..ba63b2f 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -150,11 +150,11 @@
'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 #temporary api
'db2053' => 100, # D6 2.9TB 160GB, dump (inactive), vslow
-   'db2060' => 100, # D6 3.3TB 160GB, api
-   'db2067' => 400, # D6 3.3TB 160GB
-   'db2076' => 400, # B1 3.3TB 512GB
+   # 'db2060' => 100, # D6 3.3TB 160GB, api #T174509
+   # 'db2067' => 400, # D6 3.3TB 160GB #T174509
+   # 'db2076' => 400, # B1 3.3TB 512GB #T174509
],
's7' => [
'db2029' => 0,   # B6 2.9TB  96GB, master
@@ -405,7 +405,7 @@
'db2053' => 1,
],
'api' => [
-   'db2060' => 1,
+   'db2046' => 1,
],
],
's7' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ibd01090cae60c4c4d1451f5e47ec5e09be99b27f
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 db2064 and db2063

2017-09-27 Thread Marostegui (Code Review)

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

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

db-codfw.php: Depool db2064 and db2063

Going to optimize templatelinks and pagelinks tables

Bug: T174509
Change-Id: I76fd2f4c67827db72fd160564257ab8d733d5463
---
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/24/380924/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index ba63b2f..69e81ee 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -118,8 +118,8 @@
'db2041' => 100, # C6 2.9TB 160GB, api
'db2049' => 400, # C6 2.9TB 160GB,
'db2056' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#innodb compressed
-   'db2063' => 100, # D6 3.3TB 160GB, api
-   'db2064' => 400, # D6 3.3TB 160GB
+   # 'db2063' => 100, # D6 3.3TB 160GB, api #T174509
+   # 'db2064' => 400, # D6 3.3TB 160GB #T174509
],
/* s3 */ 'DEFAULT' => [
'db2018' => 0,   # B6 2.9TB  96GB, master
@@ -296,7 +296,7 @@
],
'api' => [
'db2041' => 1,
-   'db2063' => 1,
+   # 'db2063' => 1,
],
],
/* s3 */ 'DEFAULT' => [

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

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

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: mariadb: Add db1103 to s3
..

mariadb: Add db1103 to s3

db1103 is going to be cloned from db1035.
db1035 is filling up and in order to be able to checksum its data, let's
copy it to db1103, pool is as a temporary special slave, so we can
checksum it with no rush and we can decommission db1036

Bug: T172679
Change-Id: Ia46301b1f3757eefd7f163273d1b8bb703809fc7
---
A hieradata/hosts/db1103.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_eqiad.yaml
3 files changed, 3 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/37/380937/1

diff --git a/hieradata/hosts/db1103.yaml b/hieradata/hosts/db1103.yaml
new file mode 100644
index 000..654805a
--- /dev/null
+++ b/hieradata/hosts/db1103.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's3'
diff --git a/manifests/site.pp b/manifests/site.pp
index b44e5b6..d5aa218 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -387,7 +387,7 @@
 role(mariadb::core)
 }
 
-node /^db10(35|38|44|77|78)\.eqiad\.wmnet/ {
+node /^db1(035|038|044|077|078|103)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index d0583ec..0fbd66e 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -44,6 +44,7 @@
   - db1044:9104
   - db1077:9104
   - db1078:9104
+  - db1103:9104
 - labels:
 shard: s3
 role: master

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

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

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

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-eqiad.php: Depool db1035 to clone it to db1103

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Depool db1035 to clone it to db1103
..

db-eqiad.php: Depool db1035 to clone it to db1103

db1103 will be cloned from db1035, so we can preserve db1035's data and
checksum it withour rush.

Get db1077 to serve as a special slave

Bug: T172679
Change-Id: Ia356a9e7c5e8e3a2412f711b4b46839dc3cb73b6
---
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/38/380938/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 72d4dbc..95ec251 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -126,9 +126,9 @@
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master
'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master
-   'db1035' => 50,  # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+   # 'db1035' => 50,  # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T172679
# 'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for 
db1095 - new sanitarium #T150802
-   'db1077' => 500, # B1 3.6TB 512GB
+   'db1077' => 400, # B1 3.6TB 512GB
'db1078' => 500, # C3 3.6TB 512GB
],
's4' => [
@@ -319,16 +319,16 @@
'db1077' => 1,
],
'recentchanges' => [
-   'db1035' => 1,
+   'db1077' => 1,
],
'recentchangeslinked' => [
-   'db1035' => 1,
+   'db1077' => 1,
],
'contributions' => [
-   'db1035' => 1,
+   'db1077' => 1,
],
'logpager' => [
-   'db1035' => 1,
+   'db1077' => 1,
],
],
's4' => [

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

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

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: mariadb: Add db1103 to s3
..


mariadb: Add db1103 to s3

db1103 is going to be cloned from db1035.
db1035 is filling up and in order to be able to checksum its data, let's
copy it to db1103, pool is as a temporary special slave, so we can
checksum it with no rush and we can decommission db1036

Bug: T172679
Change-Id: Ia46301b1f3757eefd7f163273d1b8bb703809fc7
---
A hieradata/hosts/db1103.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_eqiad.yaml
3 files changed, 3 insertions(+), 1 deletion(-)

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



diff --git a/hieradata/hosts/db1103.yaml b/hieradata/hosts/db1103.yaml
new file mode 100644
index 000..654805a
--- /dev/null
+++ b/hieradata/hosts/db1103.yaml
@@ -0,0 +1 @@
+mariadb::shard: 's3'
diff --git a/manifests/site.pp b/manifests/site.pp
index b44e5b6..d5aa218 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -387,7 +387,7 @@
 role(mariadb::core)
 }
 
-node /^db10(35|38|44|77|78)\.eqiad\.wmnet/ {
+node /^db1(035|038|044|077|078|103)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index d0583ec..0fbd66e 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -44,6 +44,7 @@
   - db1044:9104
   - db1077:9104
   - db1078:9104
+  - db1103:9104
 - labels:
 shard: s3
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ia46301b1f3757eefd7f163273d1b8bb703809fc7
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]: s3.hosts: Add db1103

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: s3.hosts: Add db1103
..

s3.hosts: Add db1103

db1103 is going to be cloned from db1035.
db1035 is filling up and in order to be able to checksum its data, let's
copy it to db1103, pool is as a temporary special slave, so we can
checksum it with no rush and we can decommission db1036

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


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/44/380944/1

diff --git a/dbtools/s3.hosts b/dbtools/s3.hosts
index fb5cc31..cc11178 100644
--- a/dbtools/s3.hosts
+++ b/dbtools/s3.hosts
@@ -19,4 +19,5 @@
 db1044.eqiad.wmnet 3306
 db1077.eqiad.wmnet 3306
 db1078.eqiad.wmnet 3306
+db1103.eqiad.wmnet 3306
 db1075.eqiad.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I35410530f38f208c8a4cc7c0ff8fe546ef03e642
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-eqiad, db-codfw.php: Add db1103 to the array

2017-09-27 Thread Marostegui (Code Review)

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

Change subject: db-eqiad,db-codfw.php: Add db1103 to the array
..

db-eqiad,db-codfw.php: Add db1103 to the array

db1103 will be a new host in s3. Adding it to the array of hosts while
its get cloned

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 69e81ee..050cccf 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -505,6 +505,7 @@
'db1099' => '10.64.16.84', # do not remove or comment out
'db1100' => '10.64.32.197', # do not remove or comment out
'db1101' => '10.64.32.198', # do not remove or comment out
+   'db1103' => '10.64.0.164', # do not remove or comment out
'db2001' => '10.192.0.4', # do not remove or comment out
'db2002' => '10.192.0.5', # do not remove or comment out
'db2003' => '10.192.0.6', # do not remove or comment out
diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 3d5f463..69e1969 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -519,6 +519,7 @@
'db1099' => '10.64.16.84', # do not remove or comment out
'db1100' => '10.64.32.197', # do not remove or comment out
'db1101' => '10.64.32.198', # do not remove or comment out
+   'db1103' => '10.64.0.164', # do not remove or comment out
'db2001' => '10.192.0.4', # do not remove or comment out
'db2002' => '10.192.0.5', # do not remove or comment out
'db2003' => '10.192.0.6', # do not remove or comment out

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic74634c6eacb00fd95031771312963593788bfad
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 db1092"

2017-10-09 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1092"

This reverts commit b5b6b3710d555f8568b4e7cd49175b1f1ba5b4e8.

Change-Id: I8e03c827c72018180fc39391e9ad72ad340132d8
---
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/02/383102/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0243c87..c9a1ee4 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'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 #T174509
+   'db1092' => 500, # D2 3.6TB 512GB
'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
'db1099' => 1,   # B2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
# 'db1100' => 1,   # C2 3.6TB 512GB, old master, crashed

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8e03c827c72018180fc39391e9ad72ad340132d8
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db1083"

2017-10-09 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1083"

This reverts commit 4ec8c6b0228daf55d24cd6d9f405b288b75003a6.

Change-Id: I28d534ddbe62bdaf7476e9847f9205e4b5bf4160
---
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/05/383105/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 72d18cf..072857a 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -110,7 +110,7 @@
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 300, # A2 3.6TB 512GB, api #T172679#3650005
-   # 'db1083' => 500, # B1 3.6TB 512GB #T174509
+   'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I28d534ddbe62bdaf7476e9847f9205e4b5bf4160
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db1092

2017-10-09 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1092

Optimize templatelinks and pagelinks tables

Bug: T174509
Change-Id: Ie3f796be6474dbeeddd7322930c7e5d6bb27e5b7
---
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/87/383087/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c9a1ee4..0243c87 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'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
+   # 'db1092' => 500, # D2 3.6TB 512GB #T174509
'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
'db1099' => 1,   # B2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
# 'db1100' => 1,   # C2 3.6TB 512GB, old master, crashed

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie3f796be6474dbeeddd7322930c7e5d6bb27e5b7
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]: db2079.yaml: Enable icinga notifications

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: db2079.yaml: Enable icinga notifications
..

db2079.yaml: Enable icinga notifications

db2079 has been successfully provisioned, let's enable its notifications

Bug: T170662
Change-Id: I0fd9e80fb47054a75d0cd5bffd84ba6693781d4e
---
M hieradata/hosts/db2079.yaml
1 file changed, 0 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/90/383090/1

diff --git a/hieradata/hosts/db2079.yaml b/hieradata/hosts/db2079.yaml
index 0ea867a..0d8bce2 100644
--- a/hieradata/hosts/db2079.yaml
+++ b/hieradata/hosts/db2079.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's5'
-profile::base::notifications_enabled: '0'

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0fd9e80fb47054a75d0cd5bffd84ba6693781d4e
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]: db2079.yaml: Enable icinga notifications

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: db2079.yaml: Enable icinga notifications
..


db2079.yaml: Enable icinga notifications

db2079 has been successfully provisioned, let's enable its notifications

Bug: T170662
Change-Id: I0fd9e80fb47054a75d0cd5bffd84ba6693781d4e
---
M hieradata/hosts/db2079.yaml
1 file changed, 0 insertions(+), 1 deletion(-)

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



diff --git a/hieradata/hosts/db2079.yaml b/hieradata/hosts/db2079.yaml
index 0ea867a..0d8bce2 100644
--- a/hieradata/hosts/db2079.yaml
+++ b/hieradata/hosts/db2079.yaml
@@ -1,2 +1 @@
 mariadb::shard: 's5'
-profile::base::notifications_enabled: '0'

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I0fd9e80fb47054a75d0cd5bffd84ba6693781d4e
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]: db-codfw.php: Repool db2075

2017-10-09 Thread Marostegui (Code Review)

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

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

db-codfw.php: Repool db2075

db2075's data has been copied to db2079. Repool it after it has caught
up

Bug: T170662
Change-Id: I3756d6e9584ae515cd39d54dc446383fdbf88fe6
---
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/89/383089/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 8172e69..701b1ae 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -145,7 +145,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 # Compressed InnoDB #T170662
+   'db2075' => 400, # A1 3.3TB 512GB # Compressed InnoDB
# 'db2079' => 400, # A5 3.3TB 512GB # Compressed InnoDB #T170662
],
's6' => [

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

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

2017-10-09 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1090"

This reverts commit 9a531f93192ada976576047c7db05e7c18219885.

Change-Id: Iea8d1d6bf7f7c85719f7bae047fe243f184e6952
---
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/01/383101/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 065336f..72d18cf 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -119,7 +119,7 @@
'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 #T174509
+   'db1090' => 500, # C3 3.6TB 512GB
'db1101' => 1,   # C2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager, old master 2
],
/* s3 */ 'DEFAULT' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iea8d1d6bf7f7c85719f7bae047fe243f184e6952
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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: Move db1066 from s1 api to s3 vslow

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Move db1066 from s1 api to s3 vslow
..

db-eqiad.php: Move db1066 from s1 api to s3 vslow

Following T172679#3650005 I am going to move db1066 from s1 API to s3
and convert it to vslow and dump service so we can get rid of db1038
which is short on disk space

Bug: T172679
Change-Id: I1ce2ee4b660a0611651a7909da396b32d55f0e2c
---
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/76/383076/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 74c388d..14a8290 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -106,7 +106,6 @@
'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 1,   # 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 #T172679#3650005
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 300, # A2 3.6TB 512GB, api #T172679#3650005
@@ -126,6 +125,7 @@
'db1075' => 0,   # A2 3.6TB 512GB, master
'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master
# 'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for 
db1095 - new sanitarium #T150802
+   # 'db1066' => 10,  # D1 2.8TB 160GB, future vslow, dump 
'db1077' => 400, # B1 3.6TB 512GB #temporary special slave - 
T172679
'db1078' => 500, # C3 3.6TB 512GB
'db1103' => 50,  # A3 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I1ce2ee4b660a0611651a7909da396b32d55f0e2c
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: Move db1066 from s1 to s3

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: mariadb: Move db1066 from s1 to s3
..

mariadb: Move db1066 from s1 to s3

db1066 is going to serve vslow service on s3 so we can decommission
db1038.
db1066 will be cloned from db1038

Bug: T172679
Change-Id: Ife10a160513be2f18367a761276b744882402099
---
M hieradata/hosts/db1066.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_eqiad.yaml
3 files changed, 4 insertions(+), 5 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/77/383077/1

diff --git a/hieradata/hosts/db1066.yaml b/hieradata/hosts/db1066.yaml
index b1bf6dc..654805a 100644
--- a/hieradata/hosts/db1066.yaml
+++ b/hieradata/hosts/db1066.yaml
@@ -1,2 +1 @@
-mariadb::shard: 's1'
-mariadb::socket: '/tmp/mysql.sock'
+mariadb::shard: 's3'
diff --git a/manifests/site.pp b/manifests/site.pp
index 954b2ba..fb55511 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -329,7 +329,7 @@
 role(mariadb::core)
 }
 # eqiad replicas
-node /^db10(51|55|65|66|67|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|65|67|72|73|80|83|89)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
@@ -387,7 +387,7 @@
 role(mariadb::core)
 }
 
-node /^db1(038|044|077|078|103)\.eqiad\.wmnet/ {
+node /^db1(038|044|066|077|078|103)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index 44892d3..51a479e 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -5,7 +5,6 @@
   - db1051:9104
   - db1055:9104
   - db1065:9104
-  - db1066:9104
   - db1072:9104
   - db1073:9104
   - db1080:9104
@@ -40,6 +39,7 @@
   targets:
   - db1038:9104
   - db1044:9104
+  - db1066:9104
   - db1077:9104
   - db1078:9104
   - db1103:9104

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ife10a160513be2f18367a761276b744882402099
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: Move db1072 to s3

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: mariadb: Move db1072 to s3
..

mariadb: Move db1072 to s3

db1072 will be cloned from db1038 and will replace it on the s3
vslow,dump service

Bug: T172679
Change-Id: I4c4d4300142249b95937a1c7f957e3f274dd7e27
---
M hieradata/hosts/db1072.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_eqiad.yaml
3 files changed, 4 insertions(+), 5 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/85/383085/1

diff --git a/hieradata/hosts/db1072.yaml b/hieradata/hosts/db1072.yaml
index b1bf6dc..654805a 100644
--- a/hieradata/hosts/db1072.yaml
+++ b/hieradata/hosts/db1072.yaml
@@ -1,2 +1 @@
-mariadb::shard: 's1'
-mariadb::socket: '/tmp/mysql.sock'
+mariadb::shard: 's3'
diff --git a/manifests/site.pp b/manifests/site.pp
index 954b2ba..629a24c 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -329,7 +329,7 @@
 role(mariadb::core)
 }
 # eqiad replicas
-node /^db10(51|55|65|66|67|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|65|66|67|73|80|83|89)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
@@ -387,7 +387,7 @@
 role(mariadb::core)
 }
 
-node /^db1(038|044|077|078|103)\.eqiad\.wmnet/ {
+node /^db1(038|044|072|077|078|103)\.eqiad\.wmnet/ {
 role(mariadb::core)
 }
 
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index 44892d3..15cb1f9 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -6,7 +6,6 @@
   - db1055:9104
   - db1065:9104
   - db1066:9104
-  - db1072:9104
   - db1073:9104
   - db1080:9104
   - db1083:9104
@@ -40,6 +39,7 @@
   targets:
   - db1038:9104
   - db1044:9104
+  - db1072:9104
   - db1077:9104
   - db1078:9104
   - db1103:9104

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

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

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

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

2017-10-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/383086

to review the following change.


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

Revert "db-eqiad.php: Depool db1096"

This reverts commit bd1376516f0eb2890da438611733a89dd06173ea.

Change-Id: If039b58789145e03af0dc4ca7e56b8611cc29e41
---
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/86/383086/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 91752c2..54e55ea 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -147,7 +147,7 @@
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
-   # 'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager #T174509
+   'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
'db1099' => 1,   # B2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
# 'db1100' => 1,   # C2 3.6TB 512GB, old master, crashed
# 'db1104' => 100,  # B3 3.6TB 512GB # Cloning db1106
@@ -372,23 +372,23 @@
'db1082' => 1,
],
'watchlist' => [
-   # 'db1096' => 1,
+   'db1096' => 1,
'db1099' => 1,
],
'recentchanges' => [
-   # 'db1096' => 1,
+   'db1096' => 1,
'db1099' => 1,
],
'recentchangeslinked' => [
-   # 'db1096' => 1,
+   'db1096' => 1,
'db1099' => 1,
],
'contributions' => [
-   # 'db1096' => 1,
+   'db1096' => 1,
'db1099' => 1,
],
'logpager' => [
-   # 'db1096' => 1,
+   'db1096' => 1,
'db1099' => 1,
],
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If039b58789145e03af0dc4ca7e56b8611cc29e41
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: Restore db1066 on s1, db1072 to s3

2017-10-09 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Restore db1066 on s1, db1072 to s3
..

db-eqiad.php: Restore db1066 on s1, db1072 to s3

Move db1066 back to s1 api
Move db1072 to s3 vslow service so we can depool db1038 which is short
on disk space

Bug: T172679
Change-Id: I17f4e05127a802b143cf3b0163de83dfe3e8f651
---
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/83/383083/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 37465cd..9b6d226b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -106,7 +106,7 @@
'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
-   'db1072' => 50,  # B2 2.8TB 160GB, api
+   'db1066' => 50,  # D1 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 300, # A2 3.6TB 512GB, api #T172679#3650005
# 'db1083' => 500, # B1 3.6TB 512GB #T174509
@@ -125,7 +125,7 @@
'db1075' => 0,   # A2 3.6TB 512GB, master
'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master
# 'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for 
db1095 - new sanitarium #T150802
-   # 'db1066' => 10,  # D1 2.8TB 160GB, future vslow, dump - DO 
NOT POOL, talk to marostegui first
+   # 'db1072' => 50,  # B2 2.8TB 160GB, #future vslow and dump - 
do not pool, talk to marostegui first
'db1077' => 400, # B1 3.6TB 512GB #temporary special slave - 
T172679
'db1078' => 500, # C3 3.6TB 512GB
'db1103' => 50,  # A3 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
@@ -274,8 +274,8 @@
],
'api' => [
'db1080' => 1,
-   'db1072' => 1,
'db1073' => 1,
+   'db1066' => 1,
],
],
's2' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I17f4e05127a802b143cf3b0163de83dfe3e8f651
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]: db1068: Update socket path

2017-10-10 Thread Marostegui (Code Review)

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

Change subject: db1068: Update socket path
..


db1068: Update socket path

db1068 (s4 master) will be stopped for a maintenance.
Update its socket path location

Bug: T168661
Change-Id: Ic36838849b9d1e8026bb94f394879d9a696114ea
---
M hieradata/hosts/db1068.yaml
1 file changed, 0 insertions(+), 1 deletion(-)

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



diff --git a/hieradata/hosts/db1068.yaml b/hieradata/hosts/db1068.yaml
index 196962b..a816436 100644
--- a/hieradata/hosts/db1068.yaml
+++ b/hieradata/hosts/db1068.yaml
@@ -1,4 +1,3 @@
 mariadb::shard: 's4'
 mariadb::mysql_role: 'master'
 mariadb::binlog_format: 'STATEMENT'
-mariadb::socket: '/tmp/mysql.sock'

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ic36838849b9d1e8026bb94f394879d9a696114ea
Gerrit-PatchSet: 5
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-eqiad.php: Depool db1082

2017-10-11 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1082

Pool db1106 to help with api while db1082 is out for optimizing
pagelinks and templatelinks

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0851e1c..73e7091 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1063' => 0,   # C5 2.8TB 128GB, master
'db1070' => 1,   # 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
+   # 'db1082' => 300, # A2 3.6TB 512GB, api #T174509
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
@@ -152,7 +152,7 @@
# 'db1100' => 1,   # C2 3.6TB 512GB, old master, crashed
# 'db1104' => 100,  # B3 3.6TB 512GB # Cloning db1106
'db1105' => 100,  # C3 3.6TB 512GB #low weight after being 
provisioned
-   'db1106' => 100,  # D3 3.6TB 512GB #low weight after being 
provisioned
+   'db1106' => 100,  # D3 3.6TB 512GB # temporary api #T174509
],
's6' => [
'db1061' => 0,   # C3 2.8TB 128GB, master
@@ -369,7 +369,7 @@
],
'api' => [
'db1071' => 1,
-   'db1082' => 1,
+   'db1106' => 1,
],
'watchlist' => [
'db1096' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Icb6a86a60d90321002eadb2caa4a720841ca68b9
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: Set commonswiki on read only"

2017-10-11 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


Change subject: Revert "db-eqiad.php: Set commonswiki on read only"
..

Revert "db-eqiad.php: Set commonswiki on read only"

This reverts commit b9f457697cdb6fe4ddd08949c59c1ce6708bb75e.

Change-Id: I8e5179cd5057c85cc686dbc407ab77aad27c9b22
---
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/03/383503/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c7bc917..0851e1c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -682,7 +682,7 @@
# 's1'  => 'This request is served by a passive datacenter. If you 
see this something is really wrong.',
# 's2'  => 'This request is served by a passive datacenter. If you 
see this something is really wrong.',
# 'DEFAULT' => 'This request is served by a passive datacenter. If you 
see this something is really wrong.', # s3
-'s4'  => 'There is a maintenance scheduled from 6AM UTC until 6:30 
UTC Wednesday 11th Oct: 
https://commons.wikimedia.org/wiki/Commons:Village_pump#Read-only_Commons_in_preparation_for_3D_file_support_-_11_October',
+   # 's4'  => 'This request is served by a passive datacenter. If you 
see this something is really wrong.',
# 's5'  => 'This request is served by a passive datacenter. If you 
see this something is really wrong.',
# 's6'  => 'This request is served by a passive datacenter. If you 
see this something is really wrong.',
# 's7'  => 'This request is served by a passive datacenter. If you 
see this something is really wrong.',

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I8e5179cd5057c85cc686dbc407ab77aad27c9b22
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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]: core_multiinstance.my.cnf: Fixed typo

2017-10-18 Thread Marostegui (Code Review)

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

Change subject: core_multiinstance.my.cnf: Fixed typo
..

core_multiinstance.my.cnf: Fixed typo

Change-Id: Ie0a7de51263dfe8e5729c42a185398cd7e502071
---
M modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/46/384946/1

diff --git 
a/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb 
b/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
index 7ab4433..6e166ce 100644
--- 
a/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
+++ 
b/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
@@ -70,7 +70,7 @@
 <% end -%>
 slave-transaction-retries  = 4294967295
 
- table limits
+# table limits
 tmp-table-size = 64M
 max-heap-table-size= 64M
 table-open-cache   = 5

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie0a7de51263dfe8e5729c42a185398cd7e502071
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]: core_multiinstance.my.cnf: Fixed typo

2017-10-18 Thread Marostegui (Code Review)

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

Change subject: core_multiinstance.my.cnf: Fixed typo
..


core_multiinstance.my.cnf: Fixed typo

Change-Id: Ie0a7de51263dfe8e5729c42a185398cd7e502071
---
M modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
1 file changed, 1 insertion(+), 1 deletion(-)

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



diff --git 
a/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb 
b/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
index 7ab4433..6e166ce 100644
--- 
a/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
+++ 
b/modules/profile/templates/mariadb/mysqld_config/core_multiinstance.my.cnf.erb
@@ -70,7 +70,7 @@
 <% end -%>
 slave-transaction-retries  = 4294967295
 
- table limits
+# table limits
 tmp-table-size = 64M
 max-heap-table-size= 64M
 table-open-cache   = 5

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ie0a7de51263dfe8e5729c42a185398cd7e502071
Gerrit-PatchSet: 2
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]: mysql-core_codfw.yaml: Add db2084 to s4 and s5

2017-10-18 Thread Marostegui (Code Review)

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

Change subject: mysql-core_codfw.yaml: Add db2084 to s4 and s5
..

mysql-core_codfw.yaml: Add db2084 to s4 and s5

db2084 will replicate from s4 and s5

Bug: T178359
Change-Id: I963c5fc293c2c4943ce4749faab98bfbce2945b7
---
M modules/role/files/prometheus/mysql-core_codfw.yaml
1 file changed, 2 insertions(+), 1 deletion(-)


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

diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index 3b4eea3..6a97a38 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -58,6 +58,7 @@
   - db2058:9104
   - db2065:9104
   - db2073:9104
+  - db2084:13314
 - labels:
 shard: s4
 role: master
@@ -79,7 +80,7 @@
   - db2081:9104
   - db2082:9104
   - db2083:9104
-  - db2084:9104
+  - db2084:13315
   - db2086:9104
 - labels:
 shard: s5

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

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

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

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

2017-10-18 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1098"

This reverts commit 2098673fe9f15e09ce34c328b6db51ea62e0b625.

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 2137288..10c4251 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -159,8 +159,8 @@
'db1030' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1085' => 300, # B3 3.6TB 512GB, api #master for db1102 
(sanitarium 3) - T153743
'db1088' => 500, # C2 3.6TB 512GB
-   'db1093' => 300, # D2 3.6TB 512GB #temporary recentchanges
-   # 'db1098' => 1,   # B5 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager #T174509
+   'db1093' => 500, # D2 3.6TB 512GB
+   'db1098' => 1,   # B5 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
],
's7' => [
'db1062' => 0,   # D4 2.8TB 128GB, master
@@ -402,19 +402,19 @@
'db1085' => 1,
],
'watchlist' => [
-   'db1093' => 1,
+   'db1098' => 1,
],
'recentchanges' => [
-   'db1093' => 1,
+   'db1098' => 1,
],
'recentchangeslinked' => [
-   'db1093' => 1,
+   'db1098' => 1,
],
'contributions' => [
-   'db1093' => 1,
+   'db1098' => 1,
],
'logpager' => [
-   'db1093' => 1,
+   'db1098' => 1,
],
],
's7' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I18611d1ac1a9e39cbc08a33c268bf818441f178c
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db1056

2017-10-18 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1056

Going to optimize pagelinks and templatelinks

Bug: T174509
Change-Id: I63d959e4d073c0963959fb651452326f3f8b8b2a
---
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/39/384939/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 3912f9e..5daed79 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,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 #T174509
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium
'db1081' => 300, # A2 3.6TB 512GB, api
'db1084' => 500, # B1 3.6TB 512GB
@@ -340,23 +340,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/384939
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I63d959e4d073c0963959fb651452326f3f8b8b2a
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-core_codfw.yaml: Add db2084 to s4 and s5

2017-10-18 Thread Marostegui (Code Review)

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

Change subject: mysql-core_codfw.yaml: Add db2084 to s4 and s5
..


mysql-core_codfw.yaml: Add db2084 to s4 and s5

db2084 will replicate from s4 and s5

Bug: T178359
Change-Id: I963c5fc293c2c4943ce4749faab98bfbce2945b7
---
M modules/role/files/prometheus/mysql-core_codfw.yaml
1 file changed, 2 insertions(+), 1 deletion(-)

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



diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index 3b4eea3..6a97a38 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -58,6 +58,7 @@
   - db2058:9104
   - db2065:9104
   - db2073:9104
+  - db2084:13314
 - labels:
 shard: s4
 role: master
@@ -79,7 +80,7 @@
   - db2081:9104
   - db2082:9104
   - db2083:9104
-  - db2084:9104
+  - db2084:13315
   - db2086:9104
 - labels:
 shard: s5

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I963c5fc293c2c4943ce4749faab98bfbce2945b7
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: Change db2084 port to 3315

2017-10-18 Thread Marostegui (Code Review)

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

Change subject: s5.hosts: Change db2084 port to 3315
..

s5.hosts: Change db2084 port to 3315

db2084 is a multi-instance.
It is now replicating s5 on 3315

Bug: T178359
Change-Id: I973510d87307ecb78371503e7f3251837130983c
---
M dbtools/s5.hosts
1 file changed, 1 insertion(+), 1 deletion(-)


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

diff --git a/dbtools/s5.hosts b/dbtools/s5.hosts
index 25e7932..91fe01f 100644
--- a/dbtools/s5.hosts
+++ b/dbtools/s5.hosts
@@ -1,6 +1,6 @@
 dbstore2001.codfw.wmnet3315
 db2086.codfw.wmnet 3306
-db2084.codfw.wmnet 3306
+db2084.codfw.wmnet 3315
 db2083.codfw.wmnet 3306
 db2082.codfw.wmnet 3306
 db2081.codfw.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I973510d87307ecb78371503e7f3251837130983c
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 db1034"

2017-10-18 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1034"

This reverts commit 3ed953c2a14e8c8813cd1be05881964fe3e8076c.

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 4748737..a6704d2 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -164,8 +164,8 @@
],
's7' => [
'db1062' => 0,   # D4 2.8TB 128GB, master
-   # 'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T174509
-   'db1039' => 1,   # B2 1.4TB  64GB #temporary recentchanges 
#T174509
+   'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+   # 'db1039' => 0,   # B2 1.4TB  64GB
'db1069' => 0,   # D1 2.8TB 160GB, vslow, dump, old master
'db1079' => 300, # A2 3.6TB 512GB, api #master for db1102 
(sanitarium 3)
'db1086' => 500, # B3 3.6TB 512GB, api
@@ -429,19 +429,19 @@
'db1086' => 1,
],
'watchlist' => [
-   'db1039' => 1,
+   'db1034' => 1,
],
'recentchanges' => [
-   'db1039' => 1,
+   'db1034' => 1,
],
'recentchangeslinked' => [
-   'db1039' => 1,
+   'db1034' => 1,
],
'contributions' => [
-   'db1039' => 1,
+   'db1034' => 1,
],
'logpager' => [
-   'db1039' => 1,
+   'db1034' => 1,
],
],
 ],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I5745ec46cadcada9e4ea831d9dce6d749696f49c
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db1055"

2017-10-18 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1055"

This reverts commit bc9bcba0d0dab1548e9b52f03a743ae32ad2f922.

Change-Id: Idc57a202ba1823149aecf3960e31610ff6435995
---
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/33/385133/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index ccb6272..2137288 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -104,7 +104,7 @@
'db1052' => 0,   # B3 2.8TB  96GB, master
'db1067' => 0,   # D1 2.8TB 160GB, old master
'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-   # 'db1055' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T174509
+   'db1055' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
@@ -247,23 +247,23 @@
's1' => [
'watchlist' => [
'db1051' => 1,
-   # 'db1055' => 1,
+   'db1055' => 1,
],
'recentchanges' => [
'db1051' => 1,
-   # 'db1055' => 1,
+   'db1055' => 1,
],
'recentchangeslinked' => [
'db1051' => 1,
-   # 'db1055' => 1,
+   'db1055' => 1,
],
'contributions' => [
'db1051' => 1,
-   # 'db1055' => 1,
+   'db1055' => 1,
],
'logpager' => [
'db1051' => 1,
-   # 'db1055' => 1,
+   'db1055' => 1,
],
'dump' => [
'db1065' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Idc57a202ba1823149aecf3960e31610ff6435995
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db1051

2017-10-18 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1051

Going to optimize pagelinks and templatelinks

Bug: T174509
Change-Id: Id9106ebd70b1c866af0327043576f04ebcf36b89
---
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/34/385134/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 38e1d6b..faa6f49 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -103,7 +103,7 @@
's1' => [
'db1052' => 0,   # B3 2.8TB  96GB, master
'db1067' => 0,   # D1 2.8TB 160GB, old master
-   'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+   # 'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T174509
'db1055' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
@@ -246,23 +246,23 @@
 'groupLoadsBySection' => [
's1' => [
'watchlist' => [
-   'db1051' => 1,
+   # 'db1051' => 1,
'db1055' => 1,
],
'recentchanges' => [
-   'db1051' => 1,
+   # 'db1051' => 1,
'db1055' => 1,
],
'recentchangeslinked' => [
-   'db1051' => 1,
+   # 'db1051' => 1,
'db1055' => 1,
],
'contributions' => [
-   'db1051' => 1,
+   # 'db1051' => 1,
'db1055' => 1,
],
'logpager' => [
-   'db1051' => 1,
+   # 'db1051' => 1,
'db1055' => 1,
],
'dump' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Id9106ebd70b1c866af0327043576f04ebcf36b89
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 db1056"

2017-10-18 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1056"

This reverts commit 12017845806fd14aed2fb20ff2c49924868cfc7a.

Change-Id: Ifa369140d80be53b3c170564bd81b0bf4973
---
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/32/385132/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5daed79..3912f9e 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,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 #T174509
+   'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium
'db1081' => 300, # A2 3.6TB 512GB, api
'db1084' => 500, # B1 3.6TB 512GB
@@ -340,23 +340,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/385132
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifa369140d80be53b3c170564bd81b0bf4973
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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]: Draft: Setting a multi-instance host

2017-10-19 Thread Marostegui (Code Review)

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

Change subject: Draft: Setting a multi-instance host
..

Draft: Setting a multi-instance host

We are going to introduce the concept of multi-instance hosts in core.
Basically a host that will have two (or more) instances running on
different ports.

We would like know how to add it to mediawiki-config, and to confirm
that mediawiki-config supports "HOST:PORT" syntax

I have added a bunch of reviewers that I think that might help, but feel
free to remove yourself if you are not sure you can.

Bug: T178553
Change-Id: I0dc93e0feb5c11690c38dc74ee3e469944427f1d
---
M wmf-config/db-codfw.php
1 file changed, 12 insertions(+), 1 deletion(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index f21dfa7..39715d5 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -137,6 +137,7 @@
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 200, # D6 3.3TB 160GB, api
'db2073' => 400, # C6 3.3TB 512GB # Compressed InnoDB
+   'db2084:3314' => 1, # D6 3.3TB 512GB # Compressed InnoDB
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
@@ -146,12 +147,12 @@
'db2059' => 100, # D6 3.3TB 160GB, api
'db2066' => 400, # D6 3.3TB 160GB
'db2075' => 400, # A1 3.3TB 512GB # Compressed InnoDB
+   'db2084:3315' => 1, # D6 3.3TB 512GB # Compressed InnoDB
# 'db2079' => 400, # A5 3.3TB 512GB # Compressed InnoDB #T170662
# 'db2080' => 400, # C5 3.3TB 512GB # Compressed InnoDB #T170662
# 'db2081' => 400, # A6 3.3TB 512GB # Compressed InnoDB #T170662
# 'db2082' => 400, # B6 3.3TB 512GB # Compressed InnoDB #T170662
# 'db2083' => 400, # C6 3.3TB 512GB # Compressed InnoDB #T170662
-   # 'db2084' => 400, # D6 3.3TB 512GB # Compressed InnoDB #T170662
# 'db2086' => 400, # B1 3.3TB 512GB # Compressed InnoDB #T170662
],
's6' => [
@@ -336,22 +337,27 @@
'watchlist' => [
'db2037' => 1,
'db2044' => 1,
+   'db2084:3314' => 1,
],
'recentchanges' => [
'db2037' => 1,
'db2044' => 1,
+   'db2084:3314' => 1,
],
'recentchangeslinked' => [
'db2037' => 1,
'db2044' => 1,
+   'db2084:3314' => 1,
],
'contributions' => [
'db2037' => 1,
'db2044' => 1,
+   'db2084:3314' => 1,
],
'logpager' => [
'db2037' => 1,
'db2044' => 1,
+   'db2084:3314' => 1,
],
'dump' => [
'db2058' => 1,
@@ -366,18 +372,23 @@
's5' => [
'watchlist' => [
'db2038' => 1,
+   'db2084:3315' => 1,
],
'recentchanges' => [
'db2038' => 1,
+   'db2084:3315' => 1,
],
'recentchangeslinked' => [
'db2038' => 1,
+   'db2084:3315' => 1,
],
'contributions' => [
'db2038' => 1,
+   'db2084:3315' => 1,
],
'logpager' => [
'db2038' => 1,
+   'db2084:3315' => 1,
],
'dump' => [
'db2052' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0dc93e0feb5c11690c38dc74ee3e469944427f1d
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 db2092 to s1 and s3 as rc

2017-10-19 Thread Marostegui (Code Review)

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

Change subject: mariadb: Add db2092 to s1 and s3 as rc
..

mariadb: Add db2092 to s1 and s3 as rc

db2092 will be a multi-instance host for recentchanges service.
It will serve s1 and s3

Bug: T178359
Bug: T170662
Change-Id: I1a4d35d84a8a2c9f026921005ef92cbf2b911d31
---
A hieradata/hosts/db2092.yaml
M manifests/site.pp
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
M modules/role/files/prometheus/mysql-core_codfw.yaml
4 files changed, 14 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/35/385135/1

diff --git a/hieradata/hosts/db2092.yaml b/hieradata/hosts/db2092.yaml
new file mode 100644
index 000..dc7d3f5
--- /dev/null
+++ b/hieradata/hosts/db2092.yaml
@@ -0,0 +1,5 @@
+# Buffer pool sizes/instance enabled
+profile::mariadb::core_multiinstance::num_instances: 2
+profile::mariadb::core_multiinstance::s1: '185G'
+profile::mariadb::core_multiinstance::s3: '185G'
+profile::base::notifications_enabled: '0'
diff --git a/manifests/site.pp b/manifests/site.pp
index e9a3bd0..eb5d35a 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -343,6 +343,10 @@
 role(mariadb::core)
 }
 
+node 'db2092.codfw.wmnet' {
+role(mariadb::core_multiinstance)
+}
+
 # s2 (large wikis) core production dbs on eqiad
 # eqiad master
 node 'db1054.eqiad.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 c86e125..887167d 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1685,7 +1685,9 @@
 
 host db2092 {
 hardware ethernet 18:66:DA:F8:F5:74;
-fixed-address db2092.codfw.wmnet;
+}   fixed-address db2092.codfw.wmnet;
+option pxelinux.pathprefix "stretch-installer/";
+filename "stretch-installer/debian-installer/amd64/pxelinux.0";
 }
 
 host dbproxy1001 {
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index 6a97a38..c3d2cb8 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -11,6 +11,7 @@
   - db2070:9104
   - db2071:9104
   - db2072:9104
+  - db2092:13311
 - labels:
 shard: s1
 role: master
@@ -42,6 +43,7 @@
   - db2050:9104
   - db2057:9104
   - db2074:9104
+  - db2092:13313
 - labels:
 shard: s3
 role: master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I1a4d35d84a8a2c9f026921005ef92cbf2b911d31
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]: install_server: Fix typo

2017-10-19 Thread Marostegui (Code Review)

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

Change subject: install_server: Fix typo
..

install_server: Fix typo

Change-Id: If1787b8975a3589743071840e958114ed41bed23
---
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/38/385138/1

diff --git a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200 
b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
index 887167d..9a82279 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1685,7 +1685,7 @@
 
 host db2092 {
 hardware ethernet 18:66:DA:F8:F5:74;
-}   fixed-address db2092.codfw.wmnet;
+fixed-address db2092.codfw.wmnet;
 option pxelinux.pathprefix "stretch-installer/";
 filename "stretch-installer/debian-installer/amd64/pxelinux.0";
 }

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If1787b8975a3589743071840e958114ed41bed23
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]: install_server: Fix typo

2017-10-19 Thread Marostegui (Code Review)

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

Change subject: install_server: Fix typo
..


install_server: Fix typo

Change-Id: If1787b8975a3589743071840e958114ed41bed23
---
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
1 file changed, 1 insertion(+), 1 deletion(-)

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



diff --git a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200 
b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
index 887167d..9a82279 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1685,7 +1685,7 @@
 
 host db2092 {
 hardware ethernet 18:66:DA:F8:F5:74;
-}   fixed-address db2092.codfw.wmnet;
+fixed-address db2092.codfw.wmnet;
 option pxelinux.pathprefix "stretch-installer/";
 filename "stretch-installer/debian-installer/amd64/pxelinux.0";
 }

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

Gerrit-MessageType: merged
Gerrit-Change-Id: If1787b8975a3589743071840e958114ed41bed23
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/puppet[production]: mariadb: Add db2092 to s1 and s3 as rc

2017-10-19 Thread Marostegui (Code Review)

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

Change subject: mariadb: Add db2092 to s1 and s3 as rc
..


mariadb: Add db2092 to s1 and s3 as rc

db2092 will be a multi-instance host for recentchanges service.
It will serve s1 and s3

Bug: T178359
Bug: T170662
Change-Id: I1a4d35d84a8a2c9f026921005ef92cbf2b911d31
---
A hieradata/hosts/db2092.yaml
M manifests/site.pp
M modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
M modules/role/files/prometheus/mysql-core_codfw.yaml
4 files changed, 14 insertions(+), 1 deletion(-)

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



diff --git a/hieradata/hosts/db2092.yaml b/hieradata/hosts/db2092.yaml
new file mode 100644
index 000..dc7d3f5
--- /dev/null
+++ b/hieradata/hosts/db2092.yaml
@@ -0,0 +1,5 @@
+# Buffer pool sizes/instance enabled
+profile::mariadb::core_multiinstance::num_instances: 2
+profile::mariadb::core_multiinstance::s1: '185G'
+profile::mariadb::core_multiinstance::s3: '185G'
+profile::base::notifications_enabled: '0'
diff --git a/manifests/site.pp b/manifests/site.pp
index e9a3bd0..eb5d35a 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -343,6 +343,10 @@
 role(mariadb::core)
 }
 
+node 'db2092.codfw.wmnet' {
+role(mariadb::core_multiinstance)
+}
+
 # s2 (large wikis) core production dbs on eqiad
 # eqiad master
 node 'db1054.eqiad.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 c86e125..887167d 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1685,7 +1685,9 @@
 
 host db2092 {
 hardware ethernet 18:66:DA:F8:F5:74;
-fixed-address db2092.codfw.wmnet;
+}   fixed-address db2092.codfw.wmnet;
+option pxelinux.pathprefix "stretch-installer/";
+filename "stretch-installer/debian-installer/amd64/pxelinux.0";
 }
 
 host dbproxy1001 {
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index 6a97a38..c3d2cb8 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -11,6 +11,7 @@
   - db2070:9104
   - db2071:9104
   - db2072:9104
+  - db2092:13311
 - labels:
 shard: s1
 role: master
@@ -42,6 +43,7 @@
   - db2050:9104
   - db2057:9104
   - db2074:9104
+  - db2092:13313
 - labels:
 shard: s3
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I1a4d35d84a8a2c9f026921005ef92cbf2b911d31
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]: s1, s3.hosts: Add db2092 to s1 and s3

2017-10-19 Thread Marostegui (Code Review)

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

Change subject: s1,s3.hosts: Add db2092 to s1 and s3
..

s1,s3.hosts: Add db2092 to s1 and s3

db2092 will be a multi-instance host serving in s1 and s3

Bug: T178359
Change-Id: Iad62c62468b2d29097b2497e594b169abdaf9a09
---
M dbtools/s1.hosts
M dbtools/s3.hosts
2 files changed, 2 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/37/385137/1

diff --git a/dbtools/s1.hosts b/dbtools/s1.hosts
index b661cb1..0657498 100644
--- a/dbtools/s1.hosts
+++ b/dbtools/s1.hosts
@@ -7,6 +7,7 @@
 db2070.codfw.wmnet 3306
 db2071.codfw.wmnet 3306
 db2072.codfw.wmnet 3306
+db2092.codfw.wmnet 3316
 dbstore2002.codfw.wmnet3311
 db2048.codfw.wmnet 3306
 labsdb1003.eqiad.wmnet 3306
diff --git a/dbtools/s3.hosts b/dbtools/s3.hosts
index 2519de8..91ff6b4 100644
--- a/dbtools/s3.hosts
+++ b/dbtools/s3.hosts
@@ -5,6 +5,7 @@
 db2043.codfw.wmnet 3306
 db2050.codfw.wmnet 3306
 db2057.codfw.wmnet 3306
+db2092.codfw.wmnet 3313
 db2018.codfw.wmnet 3306
 labsdb1001.eqiad.wmnet 3306
 labsdb1003.eqiad.wmnet 3306

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iad62c62468b2d29097b2497e594b169abdaf9a09
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-eqiad.php: Depool db1072

2017-10-19 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1072

db1072's data is going to be checksummed with db1103 (which contains
db1044's data)
Pool db1038 to serve vslow and dump service

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index faa6f49..fa5eaef 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -123,12 +123,12 @@
],
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master
-   # 'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master # 
T172679
+   'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master # 
T172679
'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
-   'db1072' => 0,  # B2 2.8TB 160GB, vslow, dump, old master
+   # 'db1072' => 0,  # B2 2.8TB 160GB, vslow, dump, old master 
#T164488
'db1077' => 400, # B1 3.6TB 512GB #temporary special slave - 
T172679
'db1078' => 500, # C3 3.6TB 512GB
-   # 'db1103' => 0,  # A3 3.6TB 512GB, # not needed on s3 - has 
db1035's data that we have to checksum
+   # 'db1103' => 0,  # A3 3.6TB 512GB, # not needed on s3 - has 
db1044's data that we have to checksum
],
's4' => [
'db1068' => 0,   # D1 2.8TB 160GB, master
@@ -306,10 +306,10 @@
],
/* s3 */ 'DEFAULT' => [
'vslow' => [
-   'db1072' => 1,
+   'db1038' => 1,
],
'dump' => [
-   'db1072' => 1,
+   'db1038' => 1,
],
'watchlist' => [
'db1077' => 1,

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

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

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

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

2017-10-19 Thread Marostegui (Code Review)

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

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

db-codfw.php: Depool db2034 and db2036

db2034 and db2036 are going to be used to clone db2092

Bug: T178359
Change-Id: I648672c480ba4832a8a393243e0b14962285e1c1
---
M wmf-config/db-codfw.php
1 file changed, 13 insertions(+), 13 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index e232da7..f21dfa7 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -103,7 +103,7 @@
's1' => [
'db2048' => 0,   # C6 2.9TB 160GB, master
# 'db2016' => 0,   # B6 2.9TB  96GB, old master
-   'db2034' => 50,  # A5 2.9TB 160GB, rc, log
+   # 'db2034' => 50,  # A5 2.9TB 160GB, rc, log #T178359
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow, api
'db2062' => 50,  # B5 3.3TB 160GB, api # mariadb 10.1
@@ -123,10 +123,10 @@
],
/* s3 */ 'DEFAULT' => [
'db2018' => 0,   # B6 2.9TB  96GB, master
-   'db2036' => 50,  # C6 2.9TB 160GB, rc, log
+   # 'db2036' => 50,  # C6 2.9TB 160GB, rc, log #T178359
'db2043' => 50,  # C6 2.9TB 160GB, dump (inactive), vslow
'db2050' => 150, # C6 2.9TB 160GB, api
-   'db2057' => 400, # D6 3.3TB 160GB
+   'db2057' => 200, # D6 3.3TB 160GB #temporary rc #T178359
'db2074' => 400, # D6 3.3TB 512GB # InnoDB compressed
],
's4' => [
@@ -247,23 +247,23 @@
 'groupLoadsBySection' => [
's1' => [
'watchlist' => [
-   'db2034' => 1,
+   # 'db2034' => 1,
'db2042' => 1,
],
'recentchanges' => [
-   'db2034' => 1,
+   # 'db2034' => 1,
'db2042' => 1,
],
'recentchangeslinked' => [
-   'db2034' => 1,
+   # 'db2034' => 1,
'db2042' => 1,
],
'contributions' => [
-   'db2034' => 1,
+   # 'db2034' => 1,
'db2042' => 1,
],
'logpager' => [
-   'db2034' => 1,
+   # 'db2034' => 1,
'db2042' => 1,
],
'dump' => [
@@ -308,19 +308,19 @@
],
/* s3 */ 'DEFAULT' => [
'watchlist' => [
-   'db2036' => 1,
+   'db2057' => 1,
],
'recentchanges' => [
-   'db2036' => 1,
+   'db2057' => 1,
],
'recentchangeslinked' => [
-   'db2036' => 1,
+   'db2057' => 1,
],
'contributions' => [
-   'db2036' => 1,
+   'db2057' => 1,
],
'logpager' => [
-   'db2036' => 1,
+   'db2057' => 1,
],
'dump' => [
'db2043' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I648672c480ba4832a8a393243e0b14962285e1c1
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 db2034 and db2036"

2017-10-19 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


Change subject: Revert "db-codfw.php: Depool db2034 and db2036"
..

Revert "db-codfw.php: Depool db2034 and db2036"

This reverts commit 29221abcc3a6cda4b03bc498245ea72e2aea7201.

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index f21dfa7..e232da7 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -103,7 +103,7 @@
's1' => [
'db2048' => 0,   # C6 2.9TB 160GB, master
# 'db2016' => 0,   # B6 2.9TB  96GB, old master
-   # 'db2034' => 50,  # A5 2.9TB 160GB, rc, log #T178359
+   'db2034' => 50,  # A5 2.9TB 160GB, rc, log
'db2042' => 50,  # C6 2.9TB 160GB, rc, log
'db2055' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow, api
'db2062' => 50,  # B5 3.3TB 160GB, api # mariadb 10.1
@@ -123,10 +123,10 @@
],
/* s3 */ 'DEFAULT' => [
'db2018' => 0,   # B6 2.9TB  96GB, master
-   # 'db2036' => 50,  # C6 2.9TB 160GB, rc, log #T178359
+   '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' => 200, # D6 3.3TB 160GB #temporary rc #T178359
+   'db2057' => 400, # D6 3.3TB 160GB
'db2074' => 400, # D6 3.3TB 512GB # InnoDB compressed
],
's4' => [
@@ -247,23 +247,23 @@
 'groupLoadsBySection' => [
's1' => [
'watchlist' => [
-   # 'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'recentchanges' => [
-   # 'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'recentchangeslinked' => [
-   # 'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'contributions' => [
-   # 'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'logpager' => [
-   # 'db2034' => 1,
+   'db2034' => 1,
'db2042' => 1,
],
'dump' => [
@@ -308,19 +308,19 @@
],
/* s3 */ 'DEFAULT' => [
'watchlist' => [
-   'db2057' => 1,
+   'db2036' => 1,
],
'recentchanges' => [
-   'db2057' => 1,
+   'db2036' => 1,
],
'recentchangeslinked' => [
-   'db2057' => 1,
+   'db2036' => 1,
],
'contributions' => [
-   'db2057' => 1,
+   'db2036' => 1,
],
'logpager' => [
-   'db2057' => 1,
+   'db2036' => 1,
],
'dump' => [
'db2043' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I13961907b2439000d5d8ae889f8f1270a0645e34
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db2084 to s4

2017-10-18 Thread Marostegui (Code Review)

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

Change subject: s4.hosts: Add db2084 to s4
..

s4.hosts: Add db2084 to s4

db2084 is a multi-instance hosts that replicates s4 on port 3314

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


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/71/384971/1

diff --git a/dbtools/s4.hosts b/dbtools/s4.hosts
index 09cd338..a94572c 100644
--- a/dbtools/s4.hosts
+++ b/dbtools/s4.hosts
@@ -1,4 +1,5 @@
 dbstore2002.codfw.wmnet3314
+db2084.codfw.wmnet 3314
 db2073.codfw.wmnet 3306
 db2065.codfw.wmnet 3306
 db2058.codfw.wmnet 3306

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

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

2017-10-17 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1067"

This reverts commit b43c7085cf07802e58a2a1f7a4f1d2a0b6a2b601.

Change-Id: I2e650341400bafe524a129b5b942a3146cdf2ac3
---
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/21/384921/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 15ed4e5..4748737 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -102,7 +102,7 @@
 'sectionLoads' => [
's1' => [
'db1052' => 0,   # B3 2.8TB  96GB, master
-   # 'db1067' => 0,   # D1 2.8TB 160GB, old master #T174509
+   'db1067' => 0,   # D1 2.8TB 160GB, old master
'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 1,   # 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/384921
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I2e650341400bafe524a129b5b942a3146cdf2ac3
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db1098

2017-10-17 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1098

Going to optimize pagelinks and templatelinks

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 10c4251..2137288 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -159,8 +159,8 @@
'db1030' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1085' => 300, # B3 3.6TB 512GB, api #master for db1102 
(sanitarium 3) - T153743
'db1088' => 500, # C2 3.6TB 512GB
-   'db1093' => 500, # D2 3.6TB 512GB
-   'db1098' => 1,   # B5 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
+   'db1093' => 300, # D2 3.6TB 512GB #temporary recentchanges
+   # 'db1098' => 1,   # B5 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager #T174509
],
's7' => [
'db1062' => 0,   # D4 2.8TB 128GB, master
@@ -402,19 +402,19 @@
'db1085' => 1,
],
'watchlist' => [
-   'db1098' => 1,
+   'db1093' => 1,
],
'recentchanges' => [
-   'db1098' => 1,
+   'db1093' => 1,
],
'recentchangeslinked' => [
-   'db1098' => 1,
+   'db1093' => 1,
],
'contributions' => [
-   'db1098' => 1,
+   'db1093' => 1,
],
'logpager' => [
-   'db1098' => 1,
+   'db1093' => 1,
],
],
's7' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6c789ea9451b8e244dd0bbdf17dd9f3bf39f52a9
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]: install_server: Reinstall db2084 with stretch

2017-10-17 Thread Marostegui (Code Review)

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

Change subject: install_server: Reinstall db2084 with stretch
..


install_server: Reinstall db2084 with stretch

In order to test 10.1+multi-instance on core servers, I want to
reinstall db2084 to be stretch

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

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



diff --git a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200 
b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
index 071b1d1..491d374 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1620,6 +1620,8 @@
 host db2084 {
 hardware ethernet 18:66:DA:F8:E0:A4;
 fixed-address db2084.codfw.wmnet;
+option pxelinux.pathprefix "stretch-installer/";
+filename "stretch-installer/debian-installer/amd64/pxelinux.0";
 }
 
 host db2085 {

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

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

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

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

2017-10-17 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1055

Going to optimize pagelinks and templatelinks

Bug: T174509
Change-Id: I12ef010daee4bb8982bb073051b37b2dacd18de0
---
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/23/384923/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 2137288..ccb6272 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -104,7 +104,7 @@
'db1052' => 0,   # B3 2.8TB  96GB, master
'db1067' => 0,   # D1 2.8TB 160GB, old master
'db1051' => 1,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-   'db1055' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+   # 'db1055' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T174509
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
@@ -247,23 +247,23 @@
's1' => [
'watchlist' => [
'db1051' => 1,
-   'db1055' => 1,
+   # 'db1055' => 1,
],
'recentchanges' => [
'db1051' => 1,
-   'db1055' => 1,
+   # 'db1055' => 1,
],
'recentchangeslinked' => [
'db1051' => 1,
-   'db1055' => 1,
+   # 'db1055' => 1,
],
'contributions' => [
'db1051' => 1,
-   'db1055' => 1,
+   # 'db1055' => 1,
],
'logpager' => [
'db1051' => 1,
-   'db1055' => 1,
+   # 'db1055' => 1,
],
'dump' => [
'db1065' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I12ef010daee4bb8982bb073051b37b2dacd18de0
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 db1072 to fix data drifts"

2017-10-17 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


Change subject: Revert "db-eqiad.php: Depool db1072 to fix data drifts"
..

Revert "db-eqiad.php: Depool db1072 to fix data drifts"

This reverts commit 792b4eee1d7cefec4b9bed545c7557aba7371362.

Change-Id: I4c3f08d64e1416e343292e68aaa05a1755ecbfe3
---
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/24/384924/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 4b59c57..3e80b48 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -124,8 +124,8 @@
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master
# 'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master # 
T172679
-   'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802 #temporary vslow #T164488
-   # 'db1072' => 0,  # B2 2.8TB 160GB, vslow, dump, old master 
#T164488
+   'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
+   'db1072' => 0,  # B2 2.8TB 160GB, vslow, dump, old master
'db1077' => 400, # B1 3.6TB 512GB #temporary special slave - 
T172679
'db1078' => 500, # C3 3.6TB 512GB
# 'db1103' => 0,  # A3 3.6TB 512GB, # not needed on s3 - has 
db1035's data that we have to checksum
@@ -307,10 +307,10 @@
],
/* s3 */ 'DEFAULT' => [
'vslow' => [
-   'db1044' => 1,
+   'db1072' => 1,
],
'dump' => [
-   'db1044' => 1,
+   'db1072' => 1,
],
'watchlist' => [
'db1077' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4c3f08d64e1416e343292e68aaa05a1755ecbfe3
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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 db2037 and db2038

2017-10-23 Thread Marostegui (Code Review)

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

Change subject: db-codfw.php: Depool db2037 and db2038
..

db-codfw.php: Depool db2037 and db2038

Going to use them to populate db2084

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index e232da7..75d8e7f 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -132,7 +132,7 @@
's4' => [
'db2051' => 0,   # B8 2.9TB 160GB, master
# 'db2019' => 0, # B6 2.9TB  96GB, old master
-   'db2037' => 50,  # C6 2.9TB 160GB, rc, log
+   # 'db2037' => 50,  # C6 2.9TB 160GB, rc, log #T178359
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 200, # D6 3.3TB 160GB, api
@@ -140,8 +140,8 @@
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
-   'db2038' => 50,  # C6 2.9TB 160GB, rc, log
-   'db2045' => 400, # C6 2.9TB 160GB
+   # 'db2038' => 50,  # C6 2.9TB 160GB, rc, log #T178359
+   'db2045' => 400, # C6 2.9TB 160GB #temporary rc
'db2052' => 50,  # D6 2.9TB 160GB, dump (inactive), vslow
'db2059' => 100, # D6 3.3TB 160GB, api
'db2066' => 400, # D6 3.3TB 160GB
@@ -334,23 +334,23 @@
],
's4' => [
'watchlist' => [
-   'db2037' => 1,
+   # 'db2037' => 1,
'db2044' => 1,
],
'recentchanges' => [
-   'db2037' => 1,
+   # 'db2037' => 1,
'db2044' => 1,
],
'recentchangeslinked' => [
-   'db2037' => 1,
+   # 'db2037' => 1,
'db2044' => 1,
],
'contributions' => [
-   'db2037' => 1,
+   # 'db2037' => 1,
'db2044' => 1,
],
'logpager' => [
-   'db2037' => 1,
+   # 'db2037' => 1,
'db2044' => 1,
],
'dump' => [
@@ -365,19 +365,19 @@
],
's5' => [
'watchlist' => [
-   'db2038' => 1,
+   'db2045' => 1,
],
'recentchanges' => [
-   'db2038' => 1,
+   'db2045' => 1,
],
'recentchangeslinked' => [
-   'db2038' => 1,
+   'db2045' => 1,
],
'contributions' => [
-   'db2038' => 1,
+   'db2045' => 1,
],
'logpager' => [
-   'db2038' => 1,
+   'db2045' => 1,
],
'dump' => [
'db2052' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If7dc5364d49e4ee4d12f0aaa74e08e7b2f2f
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]: db1082.yaml: Update socket path

2017-10-23 Thread Marostegui (Code Review)

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

Change subject: db1082.yaml: Update socket path
..

db1082.yaml: Update socket path

db1082 needs to go down for HW maintenance, take the opportunity to
update its socket location

Bug: T178460
Change-Id: Ie298108bad27882a575160420f9f4ea2dbfe9a79
---
M hieradata/hosts/db1082.yaml
1 file changed, 0 insertions(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/71/385971/1

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

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie298108bad27882a575160420f9f4ea2dbfe9a79
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]: db1082.yaml: Update socket path

2017-10-23 Thread Marostegui (Code Review)

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

Change subject: db1082.yaml: Update socket path
..


db1082.yaml: Update socket path

db1082 needs to go down for HW maintenance, take the opportunity to
update its socket location

Bug: T178460
Change-Id: Ie298108bad27882a575160420f9f4ea2dbfe9a79
---
M hieradata/hosts/db1082.yaml
1 file changed, 0 insertions(+), 1 deletion(-)

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



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

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ie298108bad27882a575160420f9f4ea2dbfe9a79
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: Repool db2037

2017-10-23 Thread Marostegui (Code Review)

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

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

db-codfw.php: Repool db2037

Change-Id: If09c48077107fe1fb94454feff4613d037a476f8
---
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/72/385972/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 75d8e7f..089dd33 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -132,7 +132,7 @@
's4' => [
'db2051' => 0,   # B8 2.9TB 160GB, master
# 'db2019' => 0, # B6 2.9TB  96GB, old master
-   # 'db2037' => 50,  # C6 2.9TB 160GB, rc, log #T178359
+   '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
@@ -334,23 +334,23 @@
],
's4' => [
'watchlist' => [
-   # 'db2037' => 1,
+   'db2037' => 1,
'db2044' => 1,
],
'recentchanges' => [
-   # 'db2037' => 1,
+   'db2037' => 1,
'db2044' => 1,
],
'recentchangeslinked' => [
-   # 'db2037' => 1,
+   'db2037' => 1,
'db2044' => 1,
],
'contributions' => [
-   # 'db2037' => 1,
+   'db2037' => 1,
'db2044' => 1,
],
'logpager' => [
-   # 'db2037' => 1,
+   'db2037' => 1,
'db2044' => 1,
],
'dump' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: If09c48077107fe1fb94454feff4613d037a476f8
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 db1082 with low weight

2017-10-24 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Repool db1082 with low weight

db1082 crashed and got its controller replaced, repool it with low
weight to warm it up

Bug: T178460
Change-Id: I8a37d25dd2968ea6776d3883d7d995c008c129e3
---
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/27/386127/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 38e1d6b..956c258 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1063' => 0,   # C5 2.8TB 128GB, master
'db1070' => 1,   # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 1,   # D1 2.8TB 160GB, api
-   # 'db1082' => 300, # A2 3.6TB 512GB, api # crashed T178460
+   'db1082' => 100, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager

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

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

2017-10-24 Thread Marostegui (Code Review)

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

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

db-eqiad.php: Depool db1078

Going to fix data drifts on db1078

Bug: T164488
Change-Id: Icd008e171adb617d1b9f24abd87defefba1eb86c
---
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/28/386128/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 956c258..8b97f6c 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -127,7 +127,7 @@
'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
'db1072' => 0,  # B2 2.8TB 160GB, vslow, dump, old master
'db1077' => 400, # B1 3.6TB 512GB #temporary special slave - 
T172679
-   'db1078' => 500, # C3 3.6TB 512GB
+   # 'db1078' => 500, # C3 3.6TB 512GB #T164488
# 'db1103' => 0,  # A3 3.6TB 512GB, # not needed on s3 - has 
db1035's data that we have to checksum
],
's4' => [

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

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

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

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

2017-10-24 Thread Marostegui (Code Review)

Hello Urbanecm, jenkins-bot, Jcrespo, Zoranzoki21,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1078"

This reverts commit aba12d4044c8ca095b773ac125fbf6eaff079df5.

Change-Id: I21e7a0ee0f6b549d6bd866dd4b124f3353bcb1d9
---
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/30/386130/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8b97f6c..956c258 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -127,7 +127,7 @@
'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
'db1072' => 0,  # B2 2.8TB 160GB, vslow, dump, old master
'db1077' => 400, # B1 3.6TB 512GB #temporary special slave - 
T172679
-   # 'db1078' => 500, # C3 3.6TB 512GB #T164488
+   'db1078' => 500, # C3 3.6TB 512GB
# 'db1103' => 0,  # A3 3.6TB 512GB, # not needed on s3 - has 
db1035's data that we have to checksum
],
's4' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I21e7a0ee0f6b549d6bd866dd4b124f3353bcb1d9
Gerrit-PatchSet: 1
Gerrit-Project: operations/mediawiki-config
Gerrit-Branch: master
Gerrit-Owner: Marostegui 
Gerrit-Reviewer: Jcrespo 
Gerrit-Reviewer: Urbanecm 
Gerrit-Reviewer: Zoranzoki21 
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: Give more weight to db1082

2017-10-24 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Give more weight to db1082
..

db-eqiad.php: Give more weight to db1082

Increase traffic to db1082

Bug: T178460
Change-Id: I99af728bf94b54f533a7e60c2bbd06f29dae43a8
---
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/31/386131/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 956c258..3da7440 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1063' => 0,   # C5 2.8TB 128GB, master
'db1070' => 1,   # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 1,   # D1 2.8TB 160GB, api
-   'db1082' => 100, # A2 3.6TB 512GB, api
+   'db1082' => 200, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
@@ -369,7 +369,7 @@
'api' => [
'db1071' => 1,
'db1105' => 1, # only temporary
-   # 'db1082' => 1,
+   'db1082' => 1,
],
'watchlist' => [
'db1096' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I99af728bf94b54f533a7e60c2bbd06f29dae43a8
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 db1082 with original weight

2017-10-24 Thread Marostegui (Code Review)

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

Change subject: db-eqiad.php: Repool db1082 with original weight
..

db-eqiad.php: Repool db1082 with original weight

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 3da7440..4fbc972 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,14 +144,14 @@
'db1063' => 0,   # C5 2.8TB 128GB, master
'db1070' => 1,   # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 1,   # D1 2.8TB 160GB, api
-   'db1082' => 200, # A2 3.6TB 512GB, api
+   'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
'db1096' => 1,   # A6 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
'db1099' => 1,   # B2 3.6TB 512GB, watchlist, recentchanges, 
contributions, logpager
'db1100' => 1,   # C2 3.6TB 512GB, old master
# 'db1104' => 100,  # B3 3.6TB 512GB # Cloning db1106
-   'db1105' => 1,   # C3 3.6TB 512GB, api # temporarily api 
instead of db1082 (crashed)
+   # 'db1105' => 1,   # C3 3.6TB 512GB,
'db1106' => 100,  # D3 3.6TB 512GB #low weight after being 
provisioned
],
's6' => [
@@ -368,7 +368,6 @@
],
'api' => [
'db1071' => 1,
-   'db1105' => 1, # only temporary
'db1082' => 1,
],
'watchlist' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I11d5dfa23e1c37b93cb2b7e3f7ae468482236ecd
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]: install_server: Reimage db2088 with stretch

2017-10-24 Thread Marostegui (Code Review)

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

Change subject: install_server: Reimage db2088 with stretch
..

install_server: Reimage db2088 with stretch

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


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/35/386135/1

diff --git a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200 
b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
index 9a82279..6a8e0fe 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1666,6 +1666,8 @@
 host db2088 {
 hardware ethernet 18:66:DA:F8:ED:38;
 fixed-address db2088.codfw.wmnet;
+option pxelinux.pathprefix "stretch-installer/";
+filename "stretch-installer/debian-installer/amd64/pxelinux.0";
 }
 
 host db2089 {

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I29be0b2049552a8ff6c6553c6ededff0d995109e
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]: install_server: Reimage db2088 with stretch

2017-10-24 Thread Marostegui (Code Review)

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

Change subject: install_server: Reimage db2088 with stretch
..


install_server: Reimage db2088 with stretch

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

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



diff --git a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200 
b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
index 9a82279..6a8e0fe 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1666,6 +1666,8 @@
 host db2088 {
 hardware ethernet 18:66:DA:F8:ED:38;
 fixed-address db2088.codfw.wmnet;
+option pxelinux.pathprefix "stretch-installer/";
+filename "stretch-installer/debian-installer/amd64/pxelinux.0";
 }
 
 host db2089 {

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I29be0b2049552a8ff6c6553c6ededff0d995109e
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: Add db2088 to s1 and s2

2017-10-24 Thread Marostegui (Code Review)

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

Change subject: mariadb: Add db2088 to s1 and s2
..

mariadb: Add db2088 to s1 and s2

db2088 will serve as recentchanges slave in s1 and s2

Bug: T178359
Change-Id: I17a95ec7453ee2e7e1d29c17023263c1bde40ff0
---
A hieradata/hosts/db2088.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_codfw.yaml
3 files changed, 11 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/36/386136/1

diff --git a/hieradata/hosts/db2088.yaml b/hieradata/hosts/db2088.yaml
new file mode 100644
index 000..a10bb72
--- /dev/null
+++ b/hieradata/hosts/db2088.yaml
@@ -0,0 +1,5 @@
+# Buffer pool sizes/instance enabled
+profile::mariadb::core_multiinstance::num_instances: 2
+profile::mariadb::core_multiinstance::s1: '185G'
+profile::mariadb::core_multiinstance::s2: '185G'
+profile::base::notifications_enabled: '0'
diff --git a/manifests/site.pp b/manifests/site.pp
index ef0d804..1dce731 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -341,6 +341,10 @@
 role(mariadb::core_multiinstance)
 }
 
+node 'db2088.codfw.wmnet' {
+role(mariadb::core_multiinstance)
+}
+
 # s2 (large wikis) core production dbs on eqiad
 # eqiad master
 node 'db1054.eqiad.wmnet' {
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index c3d2cb8..04b924b 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -11,6 +11,7 @@
   - db2070:9104
   - db2071:9104
   - db2072:9104
+  - db2088:13311
   - db2092:13311
 - labels:
 shard: s1
@@ -28,6 +29,7 @@
   - db2056:9104
   - db2063:9104
   - db2064:9104
+  - db2088:13312
 - labels:
 shard: s2
 role: master

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

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

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

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mariadb: Add db2088 to s1 and s2

2017-10-24 Thread Marostegui (Code Review)

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

Change subject: mariadb: Add db2088 to s1 and s2
..


mariadb: Add db2088 to s1 and s2

db2088 will serve as recentchanges slave in s1 and s2

Bug: T178359
Change-Id: I17a95ec7453ee2e7e1d29c17023263c1bde40ff0
---
A hieradata/hosts/db2088.yaml
M manifests/site.pp
M modules/role/files/prometheus/mysql-core_codfw.yaml
3 files changed, 11 insertions(+), 0 deletions(-)

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



diff --git a/hieradata/hosts/db2088.yaml b/hieradata/hosts/db2088.yaml
new file mode 100644
index 000..a10bb72
--- /dev/null
+++ b/hieradata/hosts/db2088.yaml
@@ -0,0 +1,5 @@
+# Buffer pool sizes/instance enabled
+profile::mariadb::core_multiinstance::num_instances: 2
+profile::mariadb::core_multiinstance::s1: '185G'
+profile::mariadb::core_multiinstance::s2: '185G'
+profile::base::notifications_enabled: '0'
diff --git a/manifests/site.pp b/manifests/site.pp
index ef0d804..1dce731 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -341,6 +341,10 @@
 role(mariadb::core_multiinstance)
 }
 
+node 'db2088.codfw.wmnet' {
+role(mariadb::core_multiinstance)
+}
+
 # s2 (large wikis) core production dbs on eqiad
 # eqiad master
 node 'db1054.eqiad.wmnet' {
diff --git a/modules/role/files/prometheus/mysql-core_codfw.yaml 
b/modules/role/files/prometheus/mysql-core_codfw.yaml
index c3d2cb8..04b924b 100644
--- a/modules/role/files/prometheus/mysql-core_codfw.yaml
+++ b/modules/role/files/prometheus/mysql-core_codfw.yaml
@@ -11,6 +11,7 @@
   - db2070:9104
   - db2071:9104
   - db2072:9104
+  - db2088:13311
   - db2092:13311
 - labels:
 shard: s1
@@ -28,6 +29,7 @@
   - db2056:9104
   - db2063:9104
   - db2064:9104
+  - db2088:13312
 - labels:
 shard: s2
 role: master

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I17a95ec7453ee2e7e1d29c17023263c1bde40ff0
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

< 8 9 10 11 12 13 14 15 16 17 >

1201 - 1300 of 1966 matches

Mail list logo