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

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

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

db-eqiad.php: Increase db1092 weight

Giving it more weight after reimage

Bug: T137191
Change-Id: Icec542f37d99373fdcbbfbeb862c6d2d820a510e
---
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/38/343938/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index b5be2ad..a2b8666 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
-   'db1092' => 150, # D2 3.6TB 512GB #T137191 less weight after 
reimage
+   'db1092' => 300, # D2 3.6TB 512GB #T137191 less weight after 
reimage
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

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

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

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

db-eqiad.php: Increase weight for db1092

After it has been reimaged, give it more weight

Bug: T137191
Change-Id: Ie0aadf5c10b2a8d5bf5b8efa2530b91c68c6f50a
---
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/23/343923/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 7e19c72..e7f21dc 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
-   'db1092' => 10, # D2 3.6TB 512GB #T137191 less weight after 
reimage
+   'db1092' => 50, # D2 3.6TB 512GB #T137191 less weight after 
reimage
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie0aadf5c10b2a8d5bf5b8efa2530b91c68c6f50a
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]: sanitarium.my.cnf: Set slave_type_conversions

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

Change subject: sanitarium.my.cnf: Set slave_type_conversions
..

sanitarium.my.cnf: Set slave_type_conversions

For the current sanitarium this is not really mandatory, but I prefer to
add it for consistency.

When doing an ALTER table on hosts whose master is running ROW based
replication, and attempting to expand a column, replication can break
with:

Last_SQL_Error: Column 8 of table 'commonswiki.image' cannot be
converted from type 'varchar(32)' to type 'varbinary(100)'

To prevent this we are setting slave_type_conversion to ALL_NON_LOSSY
which would allow the transaction to go on.
The documentation states:
"This mode permits conversions that do not require truncation or other
special handling of the source value; that is, it permits conversions
where the target type has a wider range than the source type.

Setting this mode has no bearing on whether lossy conversions are
permitted; this is controlled with the ALL_LOSSY mode. If only
ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion
that would result in the loss of data (such as INT to TINYINT, or
CHAR(25) to VARCHAR(20)) causes the slave to stop with an error."

Bug: T73563
Change-Id: Ib41b345b8bb59c907069998ba17e6764c67f93b6
---
M modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
1 file changed, 5 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/86/344586/1

diff --git a/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
index 416be66..899ca24 100644
--- a/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
@@ -41,6 +41,11 @@
 expire_logs_days   = 7
 sql-mode   = IGNORE_BAD_TABLE_OPTIONS
 
+# Needed when using ROW based replication and altering the width of a column, 
if not set, the ALTER will fail
+# 
https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-features-different-data-types.html
+# T73563#3117924
+slave_type_conversions = ALL_NON_LOSSY
+
 table_open_cache   = 1
 table_definition_cache = 5
 open-files-limit   = 40

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

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

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

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

db-eqiad.php: Depool db1056

Depool db1056 for alter table and repool db1081 db1064 and db1059 with their
original weights

Bug: T73563
Bug: T160415
Change-Id: Idd320ea31a95f391c06764178658a91b495bceb6
---
M wmf-config/db-eqiad.php
1 file changed, 12 insertions(+), 12 deletions(-)


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 80c92e6..67d1539 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -130,11 +130,11 @@
's4' => [
'db1040' => 0,   # B2 1.4TB  64GB, master
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-   'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-   'db1059' => 0,   # C2 2.8TB  96GB, temporary vslow #T73563 
T160415 api
-#  'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium #T153743 #T73563 T160415 api
+#  'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager T160415 T73563
+   'db1059' => 1,   # C2 2.8TB  96GB, api
+   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium
'db1068' => 1,   # D1 2.8TB 160GB, api
-   'db1081' => 200, # A2 3.6TB 512GB temporary api #T73563 T160415
+   'db1081' => 200, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
],
@@ -321,34 +321,34 @@
],
's4' => [
'vslow' => [
-   'db1059' => 1,
+   'db1064' => 1,
],
'dump' => [
-   'db1059' => 1,
+   'db1064' => 1,
],
'api' => [
-   'db1081' => 1,
+   'db1059' => 1,
'db1068' => 3,
],
'watchlist' => [
'db1053' => 1,
-   'db1056' => 1,
+#  'db1056' => 1,
],
'recentchanges' => [
'db1053' => 1,
-   'db1056' => 1,
+#  'db1056' => 1,
],
'recentchangeslinked' => [
'db1053' => 1,
-   'db1056' => 1,
+#  'db1056' => 1,
],
'contributions' => [
'db1053' => 1,
-   'db1056' => 1,
+#  'db1056' => 1,
],
'logpager' => [
'db1053' => 1,
-   'db1056' => 1,
+#  'db1056' => 1,
],
],
's5' => [

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

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

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

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

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

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

db-eqiad.php: Restore original weight for db1070

After all the reimages happened in s5, it is now time to restore the
original weight for db1070, db1071 and db1082

Bug: T137191
Change-Id: I0682533061477421ddd4105610d07eef3d89ba45
---
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/77/344577/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 09d6116..80c92e6 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -142,10 +142,10 @@
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
-   'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
-   'db1082' => 200, # A2 3.6TB 512GB, api #T137191
-   'db1087' => 200, # C2 3.6TB 512GB #temporary api #T153743
+   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
+   'db1071' => 50,  # D1 2.8TB 160GB, api
+   'db1082' => 300, # A2 3.6TB 512GB, api
+   'db1087' => 500, # C2 3.6TB 512GB
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
@@ -353,14 +353,14 @@
],
's5' => [
'vslow' => [
-   'db1071' => 1,
+   'db1070' => 1,
],
'dump' => [
-   'db1071' => 1,
+   'db1070' => 1,
],
'api' => [
+   'db1071' => 1,
'db1082' => 1,
-   'db1087' => 1,
],
'watchlist' => [
'db1026' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I0682533061477421ddd4105610d07eef3d89ba45
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]: sanitarium.my.cnf: Set slave_type_conversions

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

Change subject: sanitarium.my.cnf: Set slave_type_conversions
..


sanitarium.my.cnf: Set slave_type_conversions

For the current sanitarium this is not really mandatory, but I prefer to
add it for consistency.

When doing an ALTER table on hosts whose master is running ROW based
replication, and attempting to expand a column, replication can break
with:

Last_SQL_Error: Column 8 of table 'commonswiki.image' cannot be
converted from type 'varchar(32)' to type 'varbinary(100)'

To prevent this we are setting slave_type_conversion to ALL_NON_LOSSY
which would allow the transaction to go on.
The documentation states:
"This mode permits conversions that do not require truncation or other
special handling of the source value; that is, it permits conversions
where the target type has a wider range than the source type.

Setting this mode has no bearing on whether lossy conversions are
permitted; this is controlled with the ALL_LOSSY mode. If only
ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion
that would result in the loss of data (such as INT to TINYINT, or
CHAR(25) to VARCHAR(20)) causes the slave to stop with an error."

Bug: T73563
Change-Id: Ib41b345b8bb59c907069998ba17e6764c67f93b6
---
M modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
1 file changed, 5 insertions(+), 0 deletions(-)

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



diff --git a/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
index 416be66..899ca24 100644
--- a/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/sanitarium.my.cnf.erb
@@ -41,6 +41,11 @@
 expire_logs_days   = 7
 sql-mode   = IGNORE_BAD_TABLE_OPTIONS
 
+# Needed when using ROW based replication and altering the width of a column, 
if not set, the ALTER will fail
+# 
https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-features-different-data-types.html
+# T73563#3117924
+slave_type_conversions = ALL_NON_LOSSY
+
 table_open_cache   = 1
 table_definition_cache = 5
 open-files-limit   = 40

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ib41b345b8bb59c907069998ba17e6764c67f93b6
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-eqiad.php: Repool db1056

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

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

db-eqiad.php: Repool db1056

db1056 finished the alter table

Bug: T73563
Bug: T160415
Change-Id: I85ae8971da4740d0280ba37b26fd1001479f0992
---
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/05/344605/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 99b2272..56e4469 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -130,7 +130,7 @@
's4' => [
'db1040' => 0,   # B2 1.4TB  64GB, master
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager T160415 T73563
+   '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
'db1068' => 1,   # D1 2.8TB 160GB, api
@@ -332,23 +332,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/344605
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

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

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

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

db-eqiad.php: Depool db1092

Convert the UNIQUE keys into PK on wikidata (and later on dewiki)

Bug: T17441
Change-Id: Icbab9be7623dc06457134cd00b3db93c64c7fb5c
---
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/345109/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 56e4469..a1dcfda 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 #T17441
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

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

2017-03-28 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot, Jcrespo,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1089"

This reverts commit 04ed8a6d54dae89a5fec2391ae5d0fbe32518915.

Change-Id: Iea581ce5499b12a3c2ca683f825d1ba01ba28404
---
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/345102/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 80483fd..f8a5c47 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -104,7 +104,7 @@
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
-#  'db1089' => 500, # C3 3.6TB 512GB #T17441
+   'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [
'db1018' => 0,   # B1 1.4TB  64GB, master

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1092"

This reverts commit 15bb3bff04c08c50bae4eaee43b6eeaa99f2ab0a.

Change-Id: I1e28bc638f1cf653cfb2d9f36affeb6cb5fcca4c
---
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/39/345139/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index a1dcfda..56e4469 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 #T17441
+   'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

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

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

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

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

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

db-eqiad.php: Depool db1091

Convert UNIQUE keys into PK for all the used tables

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 56e4469..27d4461 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -136,7 +136,7 @@
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
-   'db1091' => 500, # D2 3.6TB 512GB
+#  'db1091' => 500, # D2 3.6TB 512GB #T17441
],
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master

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

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

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

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

db-eqiad.php: Depool db1053

Needs an alter table

Bug: T73563
Bug: T160415
Change-Id: If9df3069113e8b8caabb8d99e09bcc69d3472e0b
---
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/95/344895/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 56e4469..f8a5c47 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -129,7 +129,7 @@
],
's4' => [
'db1040' => 0,   # B2 1.4TB  64GB, master
-   'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager T160415 T73563
'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
@@ -331,23 +331,23 @@
'db1068' => 3,
],
'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/344895
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: If9df3069113e8b8caabb8d99e09bcc69d3472e0b
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-03-27 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/344911 )

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

db-eqiad.php: Depool db1083

I want to start testing and coverting UNIQUE keys into PK listed here:
https://phabricator.wikimedia.org/T17441#3128104

Bug: T17441
Change-Id: I0eed6b27798f160dae0f2cc6730e42923fbeb62f
---
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/11/344911/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f8a5c47..80483fd 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -104,7 +104,7 @@
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
-   'db1089' => 500, # C3 3.6TB 512GB
+#  'db1089' => 500, # C3 3.6TB 512GB #T17441
],
's2' => [
'db1018' => 0,   # B1 1.4TB  64GB, master

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1053"

This reverts commit 0940d57b9f92705332cb50ec39823645c1f5ff39.

Change-Id: I23e8e2a5af34c8e4784e035d53a2b6273f5e
---
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/344934/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index f8a5c47..56e4469 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -129,7 +129,7 @@
],
's4' => [
'db1040' => 0,   # B2 1.4TB  64GB, master
-#  'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager T160415 T73563
+   '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
@@ -331,23 +331,23 @@
'db1068' => 3,
],
'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/344934
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

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

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

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp: Remove db1057

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

Change subject: site.pp: Remove db1057
..

site.pp: Remove db1057

db1057 is broken and will never come back

Bug: T160435
Change-Id: I6628e758b886a5a331b56b3712a125e706c14321
---
M manifests/site.pp
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/45/345545/1

diff --git a/manifests/site.pp b/manifests/site.pp
index c79960c..029a8f7 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -391,7 +391,7 @@
 }
 }
 
-node /^db10(51|55|57|66|67|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|66|67|72|73|80|83|89)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's1',
 }

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I6628e758b886a5a331b56b3712a125e706c14321
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: Remove db1057 from s1

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

Change subject: db-eqiad.php: Remove db1057 from s1
..

db-eqiad.php: Remove db1057 from s1

db1057 went down and due to hardware issues it will not be back.

Bug: T160435
Change-Id: I6c1c58336f1aaeda0a465f4667e2b35346f88719
---
M wmf-config/db-eqiad.php
1 file changed, 0 insertions(+), 1 deletion(-)


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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1091"

This reverts commit 884c5a60f236dc6248cabf1346d3c1af135196c1.

Change-Id: Ie32bdbc06d8c3b2b969e807545cacd9b992e8184
---
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/41/345341/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 27d4461..56e4469 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -136,7 +136,7 @@
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
-#  'db1091' => 500, # D2 3.6TB 512GB #T17441
+   'db1091' => 500, # D2 3.6TB 512GB
],
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master

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

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

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

[MediaWiki-commits] [Gerrit] operations/puppet[production]: mysql-predump.erb: Reduce the number of jobs

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

Change subject: mysql-predump.erb: Reduce the number of jobs
..

mysql-predump.erb: Reduce the number of jobs

I am unsure if this is the correct place to reduce the concurrency of
jobs in our dbstore servers.
dbstore1001 is timming out lately because of load.
Right now it produces 12 concurrent mysqldumps, so reducing it to 8 to
see if that aliviates its load

Change-Id: If053dcb1a6c3b0d210a25a221705944c757b6227
---
M modules/backup/templates/mysql-predump.erb
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/72/345372/1

diff --git a/modules/backup/templates/mysql-predump.erb 
b/modules/backup/templates/mysql-predump.erb
index a4b789a..f155349 100644
--- a/modules/backup/templates/mysql-predump.erb
+++ b/modules/backup/templates/mysql-predump.erb
@@ -51,7 +51,7 @@
 find <%= @local_dump_dir %> -name "*sql.gz" -mtime +15 -exec rm {} \;
 for database in `$MYSQL -B -N -e "select schema_name from 
information_schema.schemata where schema_name not like '%\_schema'"`
 do
-   NP=$((<%= @processorcount %> * 3 / 4)) # This is guaranteed to return 
an integer
+   NP=$((<%= @processorcount %> * 3 / 6)) # This is guaranteed to return 
an integer
while [ $(jobs -p | wc -l) -ge $NP ]
do
sleep 1 # a magic number

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

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

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

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

db-eqiad.php: Depool db1090

db1090 is going to get its UNIQUE keys converted to PK
Pool db1063 with some weight to help

Bug: T17441
Change-Id: I9a041bed6d968cd2345ed1eb9f5c63165c92fc28
---
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/07/345507/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 56e4469..3cc2739 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -113,10 +113,10 @@
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
'db1060' => 1,   # C2 2.8TB  96GB, api
-#  'db1063' => 0,   # D1 2.8TB 128GB
+   'db1063' => 100,   # D1 2.8TB 128GB
'db1074' => 500, # A2 3.6TB 512GB
'db1076' => 500, # B1 3.6TB 512GB
-   'db1090' => 500, # C3 3.6TB 512GB
+#  'db1090' => 500, # C3 3.6TB 512GB T17441
],
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9a041bed6d968cd2345ed1eb9f5c63165c92fc28
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-03-30 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1090"

This reverts commit c6f337859ce30f54c9723e1e0720eb48c5ba3053.

Change-Id: I84717d72583faf574cd65e3c8484a28702b9b96a
---
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/74/345574/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 3cc2739..56e4469 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -113,10 +113,10 @@
'db1036' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1054' => 1,   # A3 2.8TB  96GB, api
'db1060' => 1,   # C2 2.8TB  96GB, api
-   'db1063' => 100,   # D1 2.8TB 128GB
+#  'db1063' => 0,   # D1 2.8TB 128GB
'db1074' => 500, # A2 3.6TB 512GB
'db1076' => 500, # B1 3.6TB 512GB
-#  'db1090' => 500, # C3 3.6TB 512GB T17441
+   'db1090' => 500, # C3 3.6TB 512GB
],
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master

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

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

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

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

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

Change subject: db-eqiad.php: Depool db1064, repool db1059
..

db-eqiad.php: Depool db1064, repool db1059

db1059 finished alter table, repool it as vlos temporarily while we
depool db1064 to run the alter table

Bug: T73563
Bug: T160415
Change-Id: I18be231f191b76e9834da0beea369a389bff10e0
---
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/65/344365/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c6e5442..9f0148b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -131,8 +131,8 @@
'db1040' => 0,   # B2 1.4TB  64GB, master
'db1053' => 1,   # A2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1056' => 1,   # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1059' => 1,   # C2 2.8TB  96GB, api #T73563 T160415
-   'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium #T153743
+   'db1059' => 0,   # C2 2.8TB  96GB, temporary vslow #T73563 
T160415 api
+#  'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium #T153743 #T73563 T160415 api
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 200, # A2 3.6TB 512GB temporary api #T73563 T160415
'db1084' => 500, # B1 3.6TB 512GB
@@ -321,10 +321,10 @@
],
's4' => [
'vslow' => [
-   'db1064' => 1,
+   'db1059' => 1,
],
'dump' => [
-   'db1064' => 1,
+   'db1059' => 1,
],
'api' => [
'db1081' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I18be231f191b76e9834da0beea369a389bff10e0
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]: labs.my.cnf: Set slave_type_conversions

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

Change subject: labs.my.cnf: Set slave_type_conversions
..

labs.my.cnf: Set slave_type_conversions

When doing an ALTER table on hosts whose master is running ROW based
replication, and attempting to expand a column, replication can break
with:

Last_SQL_Error: Column 8 of table 'commonswiki.image' cannot be
converted from type 'varchar(32)' to type 'varbinary(100)'

To prevent this we are setting slave_type_conversion to ALL_NON_LOSSY
which would allow the transaction to go on.
The documentation states:
"This mode permits conversions that do not require truncation or other
special handling of the source value; that is, it permits conversions
where the target type has a wider range than the source type.

Setting this mode has no bearing on whether lossy conversions are
permitted; this is controlled with the ALL_LOSSY mode. If only
ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion
that would result in the loss of data (such as INT to TINYINT, or
CHAR(25) to VARCHAR(20)) causes the slave to stop with an error."

Bug: T73563
Change-Id: Ida9183b38e213fe20cae8b8b5c7c2fe85ae95aad
---
M modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
1 file changed, 5 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/62/344362/1

diff --git a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
index 89b9aef..469ea61 100644
--- a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
@@ -53,6 +53,11 @@
 tmp_table_size = 64M
 max_heap_table_size= 64M
 
+# Needed when using ROW based replication and altering the width of a column, 
if not set, the ALTER will fail
+# 
https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-features-different-data-types.html
+# T73563#3117924
+slave_type_conversions = ALL_NON_LOSSY
+
 table_open_cache   = 1
 table_definition_cache = 5
 open-files-limit   = 40

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ida9183b38e213fe20cae8b8b5c7c2fe85ae95aad
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]: labs.my.cnf: Set slave_type_conversions

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

Change subject: labs.my.cnf: Set slave_type_conversions
..


labs.my.cnf: Set slave_type_conversions

When doing an ALTER table on hosts whose master is running ROW based
replication, and attempting to expand a column, replication can break
with:

Last_SQL_Error: Column 8 of table 'commonswiki.image' cannot be
converted from type 'varchar(32)' to type 'varbinary(100)'

To prevent this we are setting slave_type_conversion to ALL_NON_LOSSY
which would allow the transaction to go on.
The documentation states:
"This mode permits conversions that do not require truncation or other
special handling of the source value; that is, it permits conversions
where the target type has a wider range than the source type.

Setting this mode has no bearing on whether lossy conversions are
permitted; this is controlled with the ALL_LOSSY mode. If only
ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion
that would result in the loss of data (such as INT to TINYINT, or
CHAR(25) to VARCHAR(20)) causes the slave to stop with an error."

Bug: T73563
Change-Id: Ida9183b38e213fe20cae8b8b5c7c2fe85ae95aad
---
M modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
1 file changed, 5 insertions(+), 0 deletions(-)

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



diff --git a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
index 89b9aef..469ea61 100644
--- a/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/labs.my.cnf.erb
@@ -53,6 +53,11 @@
 tmp_table_size = 64M
 max_heap_table_size= 64M
 
+# Needed when using ROW based replication and altering the width of a column, 
if not set, the ALTER will fail
+# 
https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-features-different-data-types.html
+# T73563#3117924
+slave_type_conversions = ALL_NON_LOSSY
+
 table_open_cache   = 1
 table_definition_cache = 5
 open-files-limit   = 40

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

Gerrit-MessageType: merged
Gerrit-Change-Id: Ida9183b38e213fe20cae8b8b5c7c2fe85ae95aad
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: Increase db1082 weight

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

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

db-eqiad.php: Increase db1082 weight

Bug: T137191
Change-Id: I60f38564e392a70d4449aa345d78adb361480662
---
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/344402/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0d83d1d..c1722fd 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
-   'db1082' => 10, # A2 3.6TB 512GB, api #T137191
+   'db1082' => 100, # A2 3.6TB 512GB, api #T137191
'db1087' => 200, # C2 3.6TB 512GB #temporary api #T153743
'db1092' => 500, # D2 3.6TB 512GB
],

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I60f38564e392a70d4449aa345d78adb361480662
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-03-23 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/344385 )

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

db-eqiad.php: Repool db1082 with low weight

After the reimage pool it with low weigth to warm it up

Bug: T137191
Change-Id: I87b965a444aea5610b9f3d250526291aca30887a
---
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/85/344385/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9f0148b..0d83d1d 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
-#  'db1082' => 300, # A2 3.6TB 512GB, api #T137191
+   'db1082' => 10, # A2 3.6TB 512GB, api #T137191
'db1087' => 200, # C2 3.6TB 512GB #temporary api #T153743
'db1092' => 500, # D2 3.6TB 512GB
],

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

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

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

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

db-eqiad.php: Increase weight db1082

Give it more weight and enable it on the API service

Bug: T137191
Change-Id: I10a862495b16443e80dd079f8b01cf6e3b703fa6
---
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/13/344413/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c1722fd..09d6116 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
-   'db1082' => 100, # A2 3.6TB 512GB, api #T137191
+   'db1082' => 200, # A2 3.6TB 512GB, api #T137191
'db1087' => 200, # C2 3.6TB 512GB #temporary api #T153743
'db1092' => 500, # D2 3.6TB 512GB
],
@@ -359,7 +359,7 @@
'db1071' => 1,
],
'api' => [
-#  'db1082' => 1,
+   'db1082' => 1,
'db1087' => 1,
],
'watchlist' => [

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1094"

This reverts commit 34104aa35baff8ea4a71199e0dd9fa01b34ae65f.

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 38aad8f..27d4461 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -168,7 +168,7 @@
'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
'db1086' => 500, # B3 3.6TB 512GB, api
-#  'db1094' => 500, # D2 3.6TB 512GB #T17441
+   'db1094' => 500, # D2 3.6TB 512GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right

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

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

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

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

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

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

db-eqiad.php: Depool db1093

db1093 is going to get its UNIQUE keys converted to PK.
pool db1061 with some weight to help while db1093 is out

Bug: T17441
Change-Id: Iff461d24491ceec2a038a263082cee6aa88a4840
---
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/85/345285/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 27d4461..2263ed9 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -154,10 +154,10 @@
'db1022' => 1,   # B1 1.4TB  64GB, api
'db1030' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1037' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1061' => 1,   # D1 2.8TB 128GB
+   'db1061' => 100,   # D1 2.8TB 128GB #T17441
'db1085' => 500, # B3 3.6TB 512GB
'db1088' => 500, # C2 3.6TB 512GB
-   'db1093' => 500, # D2 3.6TB 512GB
+#  'db1093' => 500, # D2 3.6TB 512GB #T17441
],
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master

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

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

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

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

db-eqiad.php: Depool db1094

db1094 is going to get its UNIQUE key converted to PK

Bug: T17441
Change-Id: Ibec0525c1cb6815aec0e6094f0c0d3beda99a9e7
---
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/345306/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 27d4461..38aad8f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -168,7 +168,7 @@
'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
'db1086' => 500, # B3 3.6TB 512GB, api
-   'db1094' => 500, # D2 3.6TB 512GB
+#  'db1094' => 500, # D2 3.6TB 512GB #T17441
],
'silver' => [
'silver' => 100,   # I have no idea if this is right

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1093"

This reverts commit 2148c32cc1b2d4e40df2a06ea2eb1d85f830bf87.

Change-Id: I0416a996735599b4ff59a138578fd5bb84c7e9f6
---
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/01/345301/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 2263ed9..27d4461 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -154,10 +154,10 @@
'db1022' => 1,   # B1 1.4TB  64GB, api
'db1030' => 0,   # B1 1.4TB  64GB, vslow, dump
'db1037' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1061' => 100,   # D1 2.8TB 128GB #T17441
+#  'db1061' => 1,   # D1 2.8TB 128GB
'db1085' => 500, # B3 3.6TB 512GB
'db1088' => 500, # C2 3.6TB 512GB
-#  'db1093' => 500, # D2 3.6TB 512GB #T17441
+   'db1093' => 500, # D2 3.6TB 512GB
],
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master

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

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

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

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

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

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

db-eqiad.php: Depool db1082

Needs to be reimaged

Bug: T137191
Change-Id: Iad02b292b772e93428a6b6e21aef879511bba38a
---
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/344306/1

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

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

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

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

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

db-eqiad.php: Depool db1045

Needs an alter table

Bug: T160415
Change-Id: I182c742f9c5d40d19c088526929d124555b9a904
---
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/47/343047/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5b98df9..9020605 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -141,7 +141,7 @@
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T160415
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
@@ -364,23 +364,23 @@
],
'watchlist' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'recentchanges' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'recentchangeslinked' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'contributions' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
'logpager' => [
'db1026' => 1,
-   'db1045' => 1,
+#  'db1045' => 1,
],
],
's6' => [

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

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

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

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

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

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

db-eqiad.php: Depool db1082

Needs an alter table

Bug: T160415
Change-Id: If5af95835aa3f41f7b35e342885aeaf113cb078d
---
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/53/343053/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c937628..0dde78b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 10,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
-   'db1082' => 300, # A2 3.6TB 512GB, api
+#  'db1082' => 300, # A2 3.6TB 512GB, api #T160415
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
'db1092' => 500, # D2 3.6TB 512GB
],
@@ -359,7 +359,7 @@
'db1071' => 1,
],
'api' => [
-   'db1082' => 1,
+#  'db1082' => 1,
'db1087' => 1,
],
'watchlist' => [

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

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

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

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

db-eqiad.php: Repool db1070 with low weight

db1070 was reimaged and switched to file per table, so repool it with
less weight

Bug: T157931
Change-Id: I19965b1e9da7d149a7671d274e5353be7ba20bf9
---
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/51/343051/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5b98df9..c937628 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -142,7 +142,7 @@
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
+   'db1070' => 10,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1082"

This reverts commit ddba9967a6ebf647ae1067d048cf353179f7a6c4.

Change-Id: I6ab126b1da27e8d8d2744cf4784160ccc8b67768
---
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/54/343054/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0dde78b..c937628 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -144,7 +144,7 @@
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1070' => 10,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
-#  'db1082' => 300, # A2 3.6TB 512GB, api #T160415
+   'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
'db1092' => 500, # D2 3.6TB 512GB
],
@@ -359,7 +359,7 @@
'db1071' => 1,
],
'api' => [
-#  'db1082' => 1,
+   'db1082' => 1,
'db1087' => 1,
],
'watchlist' => [

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1045"

This reverts commit 8b8ae2573b5c1b31c38cbc884c7f2b86ae42de06.

Change-Id: I09700c21a997a159409002b4aa6930821029c5a9
---
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/49/343049/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9020605..5b98df9 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -141,7 +141,7 @@
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T160415
+   'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
@@ -364,23 +364,23 @@
],
'watchlist' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'recentchanges' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'recentchangeslinked' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'contributions' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
'logpager' => [
'db1026' => 1,
-#  'db1045' => 1,
+   'db1045' => 1,
],
],
's6' => [

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1087"

This reverts commit 182e4abf87d9f240dd06a70edd933b01cfa01149.

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0ae7863..c937628 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -145,7 +145,7 @@
'db1070' => 10,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
-#  'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743 
#T160415
+   'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
@@ -360,7 +360,7 @@
],
'api' => [
'db1082' => 1,
-#  'db1087' => 1,
+   'db1087' => 1,
],
'watchlist' => [
'db1026' => 1,

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

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

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

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

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

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

db-eqiad.php: Depool db1087

Needs an alter table

Bug: T160415
Change-Id: Icaa2eb3086eb30776add5d692ab44124a2a33c76
---
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/57/343057/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c937628..0ae7863 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -145,7 +145,7 @@
'db1070' => 10,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
-   'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
+#  'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743 
#T160415
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
@@ -360,7 +360,7 @@
],
'api' => [
'db1082' => 1,
-   'db1087' => 1,
+#  'db1087' => 1,
],
'watchlist' => [
'db1026' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: Icaa2eb3086eb30776add5d692ab44124a2a33c76
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-03-16 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1092"

This reverts commit 28176846fbeaee11db3f686d453f7a33fa091179.

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 4fc9c19..c937628 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
-#  'db1092' => 500, # D2 3.6TB 512GB
+   'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

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

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

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

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

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

db-codfw.php: Depool db2065

Needs alter table

Bug: T160415
Bug: T73563
Change-Id: I4b9af87ad17d7aedf64eea7d925668daf20b4d72
---
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/81/343081/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index da44f55..873d816 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -124,7 +124,7 @@
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2051' => 200, # C6 2.9TB 160GB, api
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   'db2065' => 400, # D6 3.3TB 160GB
+#  'db2065' => 400, # D6 3.3TB 160GB #T73563 T160415
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master

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

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

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

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

db-eqiad.php: Increase weight for db1070

After reinstall it, give it more weight

Bug: T157931
Change-Id: I8d2c031e25c3e98c72973e711d4ef1b28bc2b752
---
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/85/343085/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c937628..bf1e4cc 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -142,7 +142,7 @@
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1070' => 10,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
+   'db1070' => 30,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743

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

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

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

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

db-eqiad.php: Depool db1092

Needs an alter table

Bug: T160415
Change-Id: Ia52985788a2101553732acca2206bca45e217dde
---
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/65/343065/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c937628..4fc9c19 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
-   'db1092' => 500, # D2 3.6TB 512GB
+#  'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

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

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

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2051"

This reverts commit 2a2db7af6d32daa5fba475664b9486ca43162cd4.

Change-Id: I22cb4b6675de81b1bec2dea130b51ea0ff679b1b
---
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/22/343822/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 8982e86..da44f55 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -122,9 +122,9 @@
'db2019' => 0,   # B6 2.9TB  96GB, master
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
-#  'db2051' => 200, # C6 2.9TB 160GB, api #T160415
+   'db2051' => 200, # C6 2.9TB 160GB, api
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   'db2065' => 200, # D6 3.3TB 160GB #temporary api #T160415
+   'db2065' => 400, # D6 3.3TB 160GB
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
@@ -329,7 +329,7 @@
'db2058' => 1,
],
'api' => [
-   'db2065' => 1,
+   'db2051' => 1,
],
],
's5' => [

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

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

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

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

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

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

db-codfw.php: Depool db2044

db2044 needs an ALTER table

Bug: T160415
Bug: T73563
Change-Id: I7285bb46e39c7ee2721e1dbece10635b1585bb0d
---
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/23/343823/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index da44f55..42a79c0 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -121,7 +121,7 @@
's4' => [
'db2019' => 0,   # B6 2.9TB  96GB, 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 #T73563 T160415
'db2051' => 200, # C6 2.9TB 160GB, api
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 400, # D6 3.3TB 160GB
@@ -304,23 +304,23 @@
's4' => [
'watchlist' => [
'db2037' => 1,
-   'db2044' => 1,
+#  'db2044' => 1,
],
'recentchanges' => [
'db2037' => 1,
-   'db2044' => 1,
+#  'db2044' => 1,
],
'recentchangeslinked' => [
'db2037' => 1,
-   'db2044' => 1,
+#  'db2044' => 1,
],
'contributions' => [
'db2037' => 1,
-   'db2044' => 1,
+#  'db2044' => 1,
],
'logpager' => [
'db2037' => 1,
-   'db2044' => 1,
+#  'db2044' => 1,
],
'dump' => [
'db2058' => 1,

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

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

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

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

db-eqiad.php: Depool db1092

db1092 is going to be reimaged

Bug: T137191
Change-Id: I29def560cad34665e16addcc6f4fb605d4b292af
---
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/24/343824/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 1b06b2d..9e06111 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -142,11 +142,11 @@
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
+#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
-   'db1092' => 500, # D2 3.6TB 512GB
+#  'db1092' => 500, # D2 3.6TB 512GB #T137191
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

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

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

[MediaWiki-commits] [Gerrit] operations/mediawiki-config[master]: db-codfw.php: Repool db2044, depool db2037

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

Change subject: db-codfw.php: Repool db2044, depool db2037
..

db-codfw.php: Repool db2044, depool db2037

db2044 finished its alter tabke
db2037 needs an alter table

Bug: T73563
Bug: T160415
Change-Id: I6a3ed20be9b9f9c6aca00a1b5d546cd76d82425c
---
M wmf-config/db-codfw.php
1 file changed, 12 insertions(+), 12 deletions(-)


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 42a79c0..235523d 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -120,8 +120,8 @@
],
's4' => [
'db2019' => 0,   # B6 2.9TB  96GB, master
-   'db2037' => 50,  # C6 2.9TB 160GB, rc, log
-#  'db2044' => 50,  # C6 2.9TB 160GB, rc, log #T73563 T160415
+#  'db2037' => 50,  # C6 2.9TB 160GB, rc, log #T73563 T160415
+   'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2051' => 200, # C6 2.9TB 160GB, api
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 400, # D6 3.3TB 160GB
@@ -303,24 +303,24 @@
],
's4' => [
'watchlist' => [
-   'db2037' => 1,
-#  'db2044' => 1,
+#  'db2037' => 1,
+   'db2044' => 1,
],
'recentchanges' => [
-   'db2037' => 1,
-#  'db2044' => 1,
+#  'db2037' => 1,
+   'db2044' => 1,
],
'recentchangeslinked' => [
-   'db2037' => 1,
-#  'db2044' => 1,
+#  'db2037' => 1,
+   'db2044' => 1,
],
'contributions' => [
-   'db2037' => 1,
-#  'db2044' => 1,
+#  'db2037' => 1,
+   'db2044' => 1,
],
'logpager' => [
-   'db2037' => 1,
-#  'db2044' => 1,
+#  'db2037' => 1,
+   'db2044' => 1,
],
'dump' => [
'db2058' => 1,

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1080"

This reverts commit 34e3883d6002285f7efeec560a9c4fa137ffe8c3.

Change-Id: I4f16c2b42c97ac26cd804c542819d09213c4c837
---
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/92/342992/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5c9c914..9ab7b6f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -102,7 +102,7 @@
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
-#  'db1080' => 500, # A2 3.6TB 512GB #T160415
+   'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],

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

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

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

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

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

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

db-eqiad.php: Depool db1080

Needs an alter table

Bug: T160415
Change-Id: Ie6946f55bd84cbc51fe44790e7832a973e9f9e47
---
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/91/342991/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9ab7b6f..5c9c914 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -102,7 +102,7 @@
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
-   'db1080' => 500, # A2 3.6TB 512GB
+#  'db1080' => 500, # A2 3.6TB 512GB #T160415
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
],

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1089"

This reverts commit 681b0834549b1da7135e5cb0ffb8013785c77cb0.

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9599606..9ab7b6f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -104,7 +104,7 @@
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
-#  'db1089' => 500, # C3 3.6TB 512GB #T160415
+   'db1089' => 500, # C3 3.6TB 512GB
],
's2' => [
'db1018' => 0,   # B1 1.4TB  64GB, master

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

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

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

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

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

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

db-eqiad.php: Depool db1073

Needs an alter table

Bug: T160415
Change-Id: I673160e59db5a33816558bd9e1dd45df8830388f
---
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/95/342995/1

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

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

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

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

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

db-eqiad.php: Depool db1072

Needs an alter table

Bug: T160415
Change-Id: I809c0e21b118c1005825543e11819ec096db95b6
---
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/98/342998/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9ab7b6f..ee04137 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -100,7 +100,7 @@
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
-   'db1072' => 50,  # B2 2.8TB 160GB, api
+#  'db1072' => 50,  # B2 2.8TB 160GB, api #T160415
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
@@ -265,7 +265,7 @@
],
'api' => [
'db1066' => 1,
-   'db1072' => 1,
+#  'db1072' => 1,
'db1073' => 1,
],
],

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

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

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

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

db-eqiad.php: Depool db1089

Needs an alter table

Bug: T160415
Change-Id: I4398737e571713298d31dc97133824b69f34277a
---
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/93/342993/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9ab7b6f..9599606 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -104,7 +104,7 @@
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
-   'db1089' => 500, # C3 3.6TB 512GB
+#  'db1089' => 500, # C3 3.6TB 512GB #T160415
],
's2' => [
'db1018' => 0,   # B1 1.4TB  64GB, master

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

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

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

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

db-eqiad.php: Depool db1055

Needs an alter table

Bug: T160415
Change-Id: I79c2bff7ab9f40d33eee54b6e841f5f76b32a6b6
---
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/04/343004/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9ab7b6f..422cce5 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -97,7 +97,7 @@
 #  'db1067' => 0,   # D1 2.8TB 160GB, old master
 #  'db1057' => 0,   # C2 2.8TB  96GB, down, T160435
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-   'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T160415
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
@@ -239,7 +239,7 @@
's1' => [
'watchlist' => [
'db1051' => 1,
-   'db1055' => 1,
+#  'db1055' => 1,
],
'recentchanges' => [
'db1051' => 1,

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

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

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

[MediaWiki-commits] [Gerrit] operations/software[master]: s1, s2.hosts: Move db1067 from s2 to s1

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

Change subject: s1,s2.hosts: Move db1067 from s2 to s1
..

s1,s2.hosts: Move db1067 from s2 to s1

db1057 in s1 is having some HW issues, so we are going to replace it
with db1067 from s2.

Bug: T160435
Change-Id: I25c3e5d48da2f6b0216d121f48cbc8ec03fa9e0c
---
M dbtools/s1.hosts
M dbtools/s2.hosts
2 files changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/software 
refs/changes/90/342990/1

diff --git a/dbtools/s1.hosts b/dbtools/s1.hosts
index a63469d..355564b 100644
--- a/dbtools/s1.hosts
+++ b/dbtools/s1.hosts
@@ -28,4 +28,5 @@
 db1051.eqiad.wmnet 3306
 db1047.eqiad.wmnet 3306
 db1057.eqiad.wmnet 3306
+db1067.eqiad.wmnet 3306
 db1052.eqiad.wmnet 3306
diff --git a/dbtools/s2.hosts b/dbtools/s2.hosts
index ee8af20..1bbc29c 100644
--- a/dbtools/s2.hosts
+++ b/dbtools/s2.hosts
@@ -18,7 +18,6 @@
 db1054.eqiad.wmnet 3306
 db1060.eqiad.wmnet 3306
 db1063.eqiad.wmnet 3306
-db1067.eqiad.wmnet 3306
 db1074.eqiad.wmnet 3306
 db1076.eqiad.wmnet 3306
 db1090.eqiad.wmnet 3306

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1072"

This reverts commit 7962fc85e786be5bd5a1e0ef937befb38aab9643.

Change-Id: I69e094aea1f940a6b76fdb76d85a30bb81a598b7
---
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/99/342999/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index ee04137..9ab7b6f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -100,7 +100,7 @@
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
-#  'db1072' => 50,  # B2 2.8TB 160GB, api #T160415
+   'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
@@ -265,7 +265,7 @@
],
'api' => [
'db1066' => 1,
-#  'db1072' => 1,
+   'db1072' => 1,
'db1073' => 1,
],
],

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

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

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

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

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

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

db-eqiad.php: Depool db1066

Needs an alter table

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9ab7b6f..02ae863 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,7 +99,7 @@
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
-   'db1066' => 50,  # D1 2.8TB 160GB, api
+#  'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
@@ -264,7 +264,7 @@
'db1065' => 1,
],
'api' => [
-   'db1066' => 1,
+#  'db1066' => 1,
'db1072' => 1,
'db1073' => 1,
],

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1066"

This reverts commit d63d5da1961453e7bbcd317e2f78ac52b94c4ddb.

Change-Id: Ie5c09fbb861fc338db6c6e923dc1ee9aee397fdd
---
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/03/343003/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 02ae863..9ab7b6f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -99,7 +99,7 @@
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
-#  'db1066' => 50,  # D1 2.8TB 160GB, api
+   'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
@@ -264,7 +264,7 @@
'db1065' => 1,
],
'api' => [
-#  'db1066' => 1,
+   'db1066' => 1,
'db1072' => 1,
'db1073' => 1,
],

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1055"

This reverts commit be7632201786f44b31d412178e69a2bacff1f157.

Change-Id: Id223070c9528b0dc528d40fa049c7a898e1ffe91
---
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/07/343007/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5507418..9ab7b6f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -97,7 +97,7 @@
 #  'db1067' => 0,   # D1 2.8TB 160GB, old master
 #  'db1057' => 0,   # C2 2.8TB  96GB, down, T160435
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T160415
+   'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
'db1072' => 50,  # B2 2.8TB 160GB, api
@@ -239,23 +239,23 @@
's1' => [
'watchlist' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'recentchanges' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'recentchangeslinked' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'contributions' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'logpager' => [
'db1051' => 1,
-#  'db1055' => 1,
+   'db1055' => 1,
],
'dump' => [
'db1065' => 1,

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1073"

This reverts commit d698c388bc92aa648284c89333f8154b2d853125.

Change-Id: Id443ba553cf7a611678d0d467f703f49294d3c92
---
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/97/342997/1

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

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

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

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

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

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

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

db-eqiad.php: Increase weight db1070

Giving it more weight after its reinstall

Bug: T157931
Change-Id: Idfd4099826ec5468e4773bbb57a9e9a41e4800e1
---
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/50/343250/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index bf1e4cc..33d8f77 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -142,7 +142,7 @@
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1070' => 30,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
+   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743

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

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

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

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

db-codfw.php: Depool db2058

db2058 needs an ALTER table

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index da44f55..235d74a 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -123,8 +123,8 @@
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2051' => 200, # C6 2.9TB 160GB, api
-   'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   'db2065' => 400, # D6 3.3TB 160GB
+#  'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T160415
+   'db2065' => 300, # D6 3.3TB 160GB #temporary vslow #T160415
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
@@ -323,10 +323,10 @@
'db2044' => 1,
],
'dump' => [
-   'db2058' => 1,
+   'db2065' => 1,
],
'vslow' => [
-   'db2058' => 1,
+   'db2065' => 1,
],
'api' => [
'db2051' => 1,

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

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

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

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2065"

This reverts commit f87c10421807ce8ee6aaeb2aa1d2acb03bad42de.

Change-Id: Ice9b405ef08909f34063a01ef86fecdb76a5268a
---
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/53/343253/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 873d816..da44f55 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -124,7 +124,7 @@
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2051' => 200, # C6 2.9TB 160GB, api
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-#  'db2065' => 400, # D6 3.3TB 160GB #T73563 T160415
+   'db2065' => 400, # D6 3.3TB 160GB
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2058"

This reverts commit e7e6aec3d25223eb330c9797d3dc267fbccabb11.

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


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

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 235d74a..da44f55 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -123,8 +123,8 @@
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2051' => 200, # C6 2.9TB 160GB, api
-#  'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow 
#T160415
-   'db2065' => 300, # D6 3.3TB 160GB #temporary vslow #T160415
+   'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
+   'db2065' => 400, # D6 3.3TB 160GB
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
@@ -323,10 +323,10 @@
'db2044' => 1,
],
'dump' => [
-   'db2065' => 1,
+   'db2058' => 1,
],
'vslow' => [
-   'db2065' => 1,
+   'db2058' => 1,
],
'api' => [
'db2051' => 1,

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

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

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

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

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

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

db-eqiad.php: Depool db1026

Needs an alter table

Bug: T160415
Change-Id: I19e010ede7940cb4e95e1839716eb6cb5d225f6c
---
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/41/343041/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 680c263..d025a44 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -140,7 +140,7 @@
],
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master
-   'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T160415
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
@@ -363,23 +363,23 @@
'db1087' => 1,
],
'watchlist' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'recentchanges' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'recentchangeslinked' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'contributions' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
'logpager' => [
-   'db1026' => 1,
+#  'db1026' => 1,
'db1045' => 1,
],
],

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1026"

This reverts commit 2761b1c09b77101d218aefe6bea2aff78a44f068.

Change-Id: I0eb7bbfdc4001428bc4b50a5a3aca9c7bd8d2268
---
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/43/343043/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 79bd6e6..5b98df9 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -140,7 +140,7 @@
],
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master
-#  'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T160415
+   'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
@@ -363,23 +363,23 @@
'db1087' => 1,
],
'watchlist' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'recentchanges' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'recentchangeslinked' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'contributions' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
'logpager' => [
-#  'db1026' => 1,
+   'db1026' => 1,
'db1045' => 1,
],
],

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

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

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

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

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

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

db-codfw.php: Depool db2051

db2051 needs an alter table

Bug: T160415
Bug: T73563
Change-Id: I6f02e7c1d5f5ee34df9cf50700bab2a15248d3f5
---
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/03/343303/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index da44f55..8982e86 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -122,9 +122,9 @@
'db2019' => 0,   # B6 2.9TB  96GB, master
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
-   'db2051' => 200, # C6 2.9TB 160GB, api
+#  'db2051' => 200, # C6 2.9TB 160GB, api #T160415
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
-   'db2065' => 400, # D6 3.3TB 160GB
+   'db2065' => 200, # D6 3.3TB 160GB #temporary api #T160415
],
's5' => [
'db2023' => 0,   # B6 2.9TB  96GB, master
@@ -329,7 +329,7 @@
'db2058' => 1,
],
'api' => [
-   'db2051' => 1,
+   'db2065' => 1,
],
],
's5' => [

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

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

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

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

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

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

db-codfw.php: Repool db2037

Finished alter table

Bug: T73563
Bug: T160415
Change-Id: Iff38ffefdebddd0d86ea4e754a6100b2a2c090cb
---
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/81/344081/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 235523d..da44f55 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -120,7 +120,7 @@
],
's4' => [
'db2019' => 0,   # B6 2.9TB  96GB, master
-#  'db2037' => 50,  # C6 2.9TB 160GB, rc, log #T73563 T160415
+   'db2037' => 50,  # C6 2.9TB 160GB, rc, log
'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2051' => 200, # C6 2.9TB 160GB, api
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
@@ -303,23 +303,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/344081
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Iff38ffefdebddd0d86ea4e754a6100b2a2c090cb
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]: sanitarium2.my.cnf: Set slave_type_conversions

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

Change subject: sanitarium2.my.cnf: Set slave_type_conversions
..

sanitarium2.my.cnf: Set slave_type_conversions

When doing an ALTER table on hosts whose master is running ROW based
replication, and attempting to expand a column, replication can break
with:

Last_SQL_Error: Column 8 of table 'commonswiki.image' cannot be
converted from type 'varchar(32)' to type 'varbinary(100)'

To prevent this we are setting slave_type_conversion to ALL_NON_LOSSY
which would allow the transaction to go on.
The documentation states:
"This mode permits conversions that do not require truncation or other
special handling of the source value; that is, it permits conversions
where the target type has a wider range than the source type.

Setting this mode has no bearing on whether lossy conversions are
permitted; this is controlled with the ALL_LOSSY mode. If only
ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion
that would result in the loss of data (such as INT to TINYINT, or
CHAR(25) to VARCHAR(20)) causes the slave to stop with an error."

Bug: T73563
Change-Id: Iaafd150644592b6976da3054ce467b337d914f5c
---
M modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
1 file changed, 5 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/87/344087/1

diff --git 
a/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
index e15869a..bb6317c 100644
--- a/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
@@ -73,6 +73,11 @@
 # 10.1 option to allow triggers with RBR enabled
 slave_run_triggers_for_rbr = yes
 
+# Needed when using ROW based replication and altering the width of a column, 
if not set, the ALTER will fail
+# 
https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-features-different-data-types.html
+# T73563#3117924
+slave_type_conversions = ALL_NON_LOSSY
+
 table_open_cache   = 1
 table_definition_cache = 5
 open-files-limit   = 40

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

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

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

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

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

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

db-eqiad.php: Restore db1092 weight

db1092 had a lower weight after its reimage. Restore it now

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 118a908..0ed7b5f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -146,7 +146,7 @@
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
-   'db1092' => 300, # D2 3.6TB 512GB #T137191 less weight after 
reimage
+   'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
'db1050' => 0,   # B2 2.8TB  64GB, master

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

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

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

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

db-eqiad.php: Depool db1087

db1087 needs a reimage

Bug: T137191
Change-Id: I750e7a33caa72056724c599a2631ec02629d44b9
---
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/83/344083/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 0ed7b5f..56cfbc2 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -145,7 +145,7 @@
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 300, # A2 3.6TB 512GB, api
-   'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743
+#  'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743 
#T137191
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
@@ -360,7 +360,7 @@
],
'api' => [
'db1082' => 1,
-   'db1087' => 1,
+#  'db1087' => 1,
],
'watchlist' => [
'db1026' => 1,

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

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

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

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

db-eqiad.php: Depool db1091

Needs an alter table

Bug: T73563
Bug: T160415
Change-Id: Ic6409d5682e857697d98fa3ce35df127446d330e
---
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/86/344086/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 079dab1..b7de6a0 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -136,7 +136,7 @@
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
-   'db1091' => 500, # D2 3.6TB 512GB
+#  'db1091' => 500, # D2 3.6TB 512GB #T73563 T160415
],
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1091"

This reverts commit 7a71b4aaaf6238fa183063c389bb43044deee482.

Change-Id: Ia1065b8b9f8a4047b8f171f635283aa1e004c42d
---
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/92/344092/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index b7de6a0..079dab1 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -136,7 +136,7 @@
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
'db1084' => 500, # B1 3.6TB 512GB
-#  'db1091' => 500, # D2 3.6TB 512GB #T73563 T160415
+   'db1091' => 500, # D2 3.6TB 512GB
],
's5' => [
'db1049' => 0,   # B1 2.8TB  64GB, master

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

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

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

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

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

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

db-eqiad.php: Depool db1084

Needs an alter table

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 079dab1..48485d5 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -135,7 +135,7 @@
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium #T153743
'db1068' => 1,   # D1 2.8TB 160GB, api
'db1081' => 500, # A2 3.6TB 512GB
-   'db1084' => 500, # B1 3.6TB 512GB
+#  'db1084' => 500, # B1 3.6TB 512GB #T73563 T160415
'db1091' => 500, # D2 3.6TB 512GB
],
's5' => [

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

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

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

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2044"

This reverts commit fb9d4cb366ed94faaa8f61dc2a6ccb35f13ededd.

Change-Id: I7d1d9ee60cff5229041839a50c37c574499fde9c
---
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/50/343850/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 42a79c0..da44f55 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -121,7 +121,7 @@
's4' => [
'db2019' => 0,   # B6 2.9TB  96GB, master
'db2037' => 50,  # C6 2.9TB 160GB, rc, log
-#  'db2044' => 50,  # C6 2.9TB 160GB, rc, log #T73563 T160415
+   'db2044' => 50,  # C6 2.9TB 160GB, rc, log
'db2051' => 200, # C6 2.9TB 160GB, api
'db2058' => 50,  # D6 3.3TB 160GB, dump (inactive), vslow
'db2065' => 400, # D6 3.3TB 160GB
@@ -304,23 +304,23 @@
's4' => [
'watchlist' => [
'db2037' => 1,
-#  'db2044' => 1,
+   'db2044' => 1,
],
'recentchanges' => [
'db2037' => 1,
-#  'db2044' => 1,
+   'db2044' => 1,
],
'recentchangeslinked' => [
'db2037' => 1,
-#  'db2044' => 1,
+   'db2044' => 1,
],
'contributions' => [
'db2037' => 1,
-#  'db2044' => 1,
+   'db2044' => 1,
],
'logpager' => [
'db2037' => 1,
-#  'db2044' => 1,
+   'db2044' => 1,
],
'dump' => [
'db2058' => 1,

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

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

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

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

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

Change subject: db-eqiad.php: Repooli db1087 with low weight
..

db-eqiad.php: Repooli db1087 with low weight

db1087 has been reimaged so repool it with low weight

Bug: T137191
Change-Id: I4087758a3f5572380a9c903f030bc78497e37e9a
---
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/17/344117/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 48485d5..d538ed8 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -145,7 +145,7 @@
 #  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
'db1071' => 50,  # D1 2.8TB 160GB, #temporary vslow #T153743
'db1082' => 200, # A2 3.6TB 512GB, api
-#  'db1087' => 300, # C2 3.6TB 512GB #temporary api #T153743 
#T137191
+   'db1087' => 50, # C2 3.6TB 512GB #low weight temporary api 
#T153743 #T137191
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I4087758a3f5572380a9c903f030bc78497e37e9a
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 db1084, depool db1081

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

Change subject: db-eqiad.php: Repool db1084,depool db1081
..

db-eqiad.php: Repool db1084,depool db1081

db1084 finished alter table
db1081 needs alter table

Bug: T73563
Bug: T160415
Change-Id: I9f5308f9456801bcaac38bc050c53f7aa95cc3ee
---
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/22/344122/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index d538ed8..c165dc8 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -134,8 +134,8 @@
'db1059' => 1,   # C2 2.8TB  96GB, api
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium #T153743
'db1068' => 1,   # D1 2.8TB 160GB, api
-   'db1081' => 500, # A2 3.6TB 512GB
-#  'db1084' => 500, # B1 3.6TB 512GB #T73563 T160415
+#  'db1081' => 500, # A2 3.6TB 512GB #T73563 T160415
+   'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
],
's5' => [

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I9f5308f9456801bcaac38bc050c53f7aa95cc3ee
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: Enable db1087 in API service

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

Change subject: db-eqiad.php: Enable db1087 in API service
..

db-eqiad.php: Enable db1087 in API service

Give more traffic to db1087 after its reimage, enabling it on API

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index c165dc8..7c621d0 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -360,7 +360,7 @@
],
'api' => [
'db1082' => 1,
-#  'db1087' => 1,
+   'db1087' => 1,
],
'watchlist' => [
'db1026' => 1,

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I800296dd4414a3a0c1128346fd67cb8b0a6441fc
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]: sanitarium2.my.cnf: Set slave_type_conversions

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

Change subject: sanitarium2.my.cnf: Set slave_type_conversions
..


sanitarium2.my.cnf: Set slave_type_conversions

When doing an ALTER table on hosts whose master is running ROW based
replication, and attempting to expand a column, replication can break
with:

Last_SQL_Error: Column 8 of table 'commonswiki.image' cannot be
converted from type 'varchar(32)' to type 'varbinary(100)'

To prevent this we are setting slave_type_conversion to ALL_NON_LOSSY
which would allow the transaction to go on.
The documentation states:
"This mode permits conversions that do not require truncation or other
special handling of the source value; that is, it permits conversions
where the target type has a wider range than the source type.

Setting this mode has no bearing on whether lossy conversions are
permitted; this is controlled with the ALL_LOSSY mode. If only
ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion
that would result in the loss of data (such as INT to TINYINT, or
CHAR(25) to VARCHAR(20)) causes the slave to stop with an error."

Bug: T73563
Change-Id: Iaafd150644592b6976da3054ce467b337d914f5c
---
M modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
1 file changed, 5 insertions(+), 0 deletions(-)

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



diff --git 
a/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb 
b/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
index e15869a..bb6317c 100644
--- a/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
+++ b/modules/role/templates/mariadb/mysqld_config/sanitarium2.my.cnf.erb
@@ -73,6 +73,11 @@
 # 10.1 option to allow triggers with RBR enabled
 slave_run_triggers_for_rbr = yes
 
+# Needed when using ROW based replication and altering the width of a column, 
if not set, the ALTER will fail
+# 
https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-features-different-data-types.html
+# T73563#3117924
+slave_type_conversions = ALL_NON_LOSSY
+
 table_open_cache   = 1
 table_definition_cache = 5
 open-files-limit   = 40

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

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

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

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

db-eqiad.php: Depool db1051

Needs an alter table

Bug: T160415
Change-Id: I0340441f14b8b42ac9b9ccb085476be8dac21954
---
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/09/343009/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 9ab7b6f..680c263 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -96,7 +96,7 @@
'db1052' => 0,   # B3 2.8TB  96GB, master
 #  'db1067' => 0,   # D1 2.8TB 160GB, old master
 #  'db1057' => 0,   # C2 2.8TB  96GB, down, T160435
-   'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T160415
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
@@ -238,23 +238,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/343009
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1051"

This reverts commit b19bf1b50229adb958bb125e3e0d71fff379079e.

Change-Id: Id9e21d12fbc761eb0739505e489563c879169266
---
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/11/343011/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 680c263..9ab7b6f 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -96,7 +96,7 @@
'db1052' => 0,   # B3 2.8TB  96GB, master
 #  'db1067' => 0,   # D1 2.8TB 160GB, old master
 #  'db1057' => 0,   # C2 2.8TB  96GB, down, T160435
-#  'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager #T160415
+   'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
'db1066' => 50,  # D1 2.8TB 160GB, api
@@ -238,23 +238,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/343011
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

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

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

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

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

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

db-eqiad.php: Depool db1034

db1034 needs an alter table
pool db1062 to take over db1034 temporarliy

Bug: T160390
Change-Id: I216b5cccb4b32470bde552e877661ac2eb1712ad
---
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/38/346238/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 84ef436..6a81d46 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -162,9 +162,9 @@
'db1041' => 0,   # B2 1.4TB  64GB, master
 #  'db1033' => 0,   # B2 1.4TB  64GB, old master
'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump
-   'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T160390
 #  'db1039' => 0,   # B2 1.4TB  64GB
-#  'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
+   'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager #T160390
'db1079' => 300, # A2 3.6TB 512GB, api
'db1086' => 500, # B3 3.6TB 512GB, api
'db1094' => 500, # D2 3.6TB 512GB
@@ -420,19 +420,19 @@
'db1086' => 1,
],
'watchlist' => [
-   'db1034' => 1,
+   'db1062' => 1,
],
'recentchanges' => [
-   'db1034' => 1,
+   'db1062' => 1,
],
'recentchangeslinked' => [
-   'db1034' => 1,
+   'db1062' => 1,
],
'contributions' => [
-   'db1034' => 1,
+   'db1062' => 1,
],
'logpager' => [
-   'db1034' => 1,
+   'db1062' => 1,
],
],
 ],

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1034"

This reverts commit e15f70f646743eb4134c5cdee5ec2684a33e55f2.

Change-Id: Ibd81d1294b8d6ddcde42f05d6ce7671ca44c0318
---
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/39/346239/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 6a81d46..84ef436 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -162,9 +162,9 @@
'db1041' => 0,   # B2 1.4TB  64GB, master
 #  'db1033' => 0,   # B2 1.4TB  64GB, old master
'db1028' => 0,   # B1 1.4TB  64GB, vslow, dump
-#  'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T160390
+   'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1039' => 0,   # B2 1.4TB  64GB
-   'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager #T160390
+#  'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
'db1086' => 500, # B3 3.6TB 512GB, api
'db1094' => 500, # D2 3.6TB 512GB
@@ -420,19 +420,19 @@
'db1086' => 1,
],
'watchlist' => [
-   'db1062' => 1,
+   'db1034' => 1,
],
'recentchanges' => [
-   'db1062' => 1,
+   'db1034' => 1,
],
'recentchangeslinked' => [
-   'db1062' => 1,
+   'db1034' => 1,
],
'contributions' => [
-   'db1062' => 1,
+   'db1034' => 1,
],
'logpager' => [
-   'db1062' => 1,
+   'db1034' => 1,
],
],
 ],

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

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

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

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

2017-04-05 Thread Marostegui (Code Review) 
Hello jenkins-bot,

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2061"

This reverts commit cb4045cbb90877d47d482b9d08153d6103944c86.

Change-Id: Iee46f0968857bed305696d6cbbd7ad0e736cc923
---
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/97/346497/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index dafe5e7..1f7e24b 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -147,8 +147,8 @@
'db2040' => 200, # C6 2.9TB 160GB, rc, log
'db2047' => 400, # C6 2.9TB 160GB
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
-#  'db2061' => 200, # D6 3.3TB 160GB, api T160390
-   'db2068' => 200, # D6 3.3TB 160GB #temporary api T160390
+   'db2061' => 200, # D6 3.3TB 160GB, api
+   'db2068' => 300, # D6 3.3TB 160GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right
@@ -407,7 +407,7 @@
'db2054' => 1,
],
'api' => [
-   'db2068' => 1,
+   'db2061' => 1,
],
],
 ],

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

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

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

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

2017-04-05 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/346503 )

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

db-eqiad.php: Depool db1081

Going to migrate db1081 to file per table, to at least has one host
ready to be able to clone new servers that just arrived with the correct
configuration

Bug: T161088
Change-Id: I8fa8e3206855222f04d7216a28ed977af3496595
---
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/346503/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 760129b..3718483 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -133,7 +133,7 @@
'db1059' => 1,   # C2 2.8TB  96GB, api
'db1064' => 0,   # D1 2.8TB 160GB, vslow, dump #Master for 
db1095 - new sanitarium
'db1068' => 1,   # D1 2.8TB 160GB, api
-   'db1081' => 500, # A2 3.6TB 512GB
+#  'db1081' => 500, # A2 3.6TB 512GB #T161088
'db1084' => 500, # B1 3.6TB 512GB
'db1091' => 500, # D2 3.6TB 512GB
],

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

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

2017-04-11 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1093"

This reverts commit b19eae6ae29a2ed2aeec50920b3e8ba1aaaed159.

Change-Id: I2a1e2fd9213d0792037caba85aeff603887927cd
---
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/51/347651/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index e9fcf3b..8092917 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -156,7 +156,7 @@
 #  'db1061' => 1,   # D1 2.8TB 128GB
'db1085' => 500, # B3 3.6TB 512GB
'db1088' => 500, # C2 3.6TB 512GB
-#  'db1093' => 500, # D2 3.6TB 512GB #missing key
+   'db1093' => 500, # D2 3.6TB 512GB
],
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master

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

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

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

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

2017-04-11 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/347634 )

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

db-eqiad.php: Depool db1093

db1093 is missing a key that is being forced

Change-Id: I7d377fb569589ec9c0faadd085d5d01bd6bc236a
---
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/34/347634/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8092917..e9fcf3b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -156,7 +156,7 @@
 #  'db1061' => 1,   # D1 2.8TB 128GB
'db1085' => 500, # B3 3.6TB 512GB
'db1088' => 500, # C2 3.6TB 512GB
-   'db1093' => 500, # D2 3.6TB 512GB
+#  'db1093' => 500, # D2 3.6TB 512GB #missing key
],
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master

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

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

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

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

db-eqiad.php: Depool db1015

db1015 needs an ALTER table

Bug: T159319
Change-Id: I864ffc0f9103b8950d4755ca98b4ae3740bef9d7
---
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/60/346160/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 981bec3..84ef436 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -120,8 +120,8 @@
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master
'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master
-   'db1015' => 1,   # A2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-#  'db1035' => 0,   # B2 1.4TB  64GB
+#  'db1015' => 1,   # A2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T159319
+   'db1035' => 1,   # B2 1.4TB  64GB #temporary watchlist, recent 
changes #T159319
 #  'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
'db1077' => 500, # B1 3.6TB 512GB
'db1078' => 500, # C3 3.6TB 512GB
@@ -303,19 +303,19 @@
'db1038' => 1,
],
'watchlist' => [
-   'db1015' => 1,
+   'db1035' => 1,
],
'recentchanges' => [
-   'db1015' => 1,
+   'db1035' => 1,
],
'recentchangeslinked' => [
-   'db1015' => 1,
+   'db1035' => 1,
],
'contributions' => [
-   'db1015' => 1,
+   'db1035' => 1,
],
'logpager' => [
-   'db1015' => 1,
+   'db1035' => 1,
],
],
's4' => [

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1015"

This reverts commit 08e83abb1ae07c298c5b59f3f637437c00e38fba.

Change-Id: Ia124eff6ea544f2ce4648a140034c59f7b4dae2b
---
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/58/346258/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 84ef436..981bec3 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -120,8 +120,8 @@
/* s3 */ 'DEFAULT' => [
'db1075' => 0,   # A2 3.6TB 512GB, master
'db1038' => 0,   # B2 1.4TB  64GB, vslow, dump, old master
-#  'db1015' => 1,   # A2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager #T159319
-   'db1035' => 1,   # B2 1.4TB  64GB #temporary watchlist, recent 
changes #T159319
+   'db1015' => 1,   # A2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
+#  'db1035' => 0,   # B2 1.4TB  64GB
 #  'db1044' => 0,   # B2 1.4TB  64GB, #Temporary master for db1095 
- new sanitarium #T150802
'db1077' => 500, # B1 3.6TB 512GB
'db1078' => 500, # C3 3.6TB 512GB
@@ -303,19 +303,19 @@
'db1038' => 1,
],
'watchlist' => [
-   'db1035' => 1,
+   'db1015' => 1,
],
'recentchanges' => [
-   'db1035' => 1,
+   'db1015' => 1,
],
'recentchangeslinked' => [
-   'db1035' => 1,
+   'db1015' => 1,
],
'contributions' => [
-   'db1035' => 1,
+   'db1015' => 1,
],
'logpager' => [
-   'db1035' => 1,
+   'db1015' => 1,
],
],
's4' => [

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

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

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

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

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

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

db-codfw.php: Depool db2068

db2068 needs an ALTER table

Bug: T160390
Change-Id: I8cff3160012ed9bae8b363cdad6a15515a30741b
---
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/43/346243/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1f7e24b..1b6de22 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -148,7 +148,7 @@
'db2047' => 400, # C6 2.9TB 160GB
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
'db2061' => 200, # D6 3.3TB 160GB, api
-   'db2068' => 300, # D6 3.3TB 160GB
+#  'db2068' => 300, # D6 3.3TB 160GB #T160390
],
'silver' => [
'silver' => 100,   # I have no idea if this is right

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

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

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

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1086"

This reverts commit 697acba6af59f9694e6a28e6c5f47d3b08b9e651.

Change-Id: I456b211a93b1879a308c8ee14a454aaa1128312c
---
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/44/346144/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 5188519..981bec3 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -166,7 +166,7 @@
 #  'db1039' => 0,   # B2 1.4TB  64GB
 #  'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
-#  'db1086' => 500, # B3 3.6TB 512GB, api #T160390
+   'db1086' => 500, # B3 3.6TB 512GB, api
'db1094' => 500, # D2 3.6TB 512GB
],
'silver' => [
@@ -417,7 +417,7 @@
],
'api' => [
'db1079' => 100,
-#  'db1086' => 1,
+   'db1086' => 1,
],
'watchlist' => [
'db1034' => 1,

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

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

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

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

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

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

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

to review the following change.


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

Revert "db-codfw.php: Depool db2068"

This reverts commit f86090398b8f3efb8e515e2b5e56acff9809e2ab.

Change-Id: I686ad2099bef71c5c4bd269c777645ae9764c3e2
---
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/77/346277/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1b6de22..1f7e24b 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -148,7 +148,7 @@
'db2047' => 400, # C6 2.9TB 160GB
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
'db2061' => 200, # D6 3.3TB 160GB, api
-#  'db2068' => 300, # D6 3.3TB 160GB #T160390
+   'db2068' => 300, # D6 3.3TB 160GB
],
'silver' => [
'silver' => 100,   # I have no idea if this is right

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

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

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

[MediaWiki-commits] [Gerrit] operations/puppet[production]: site.pp, linux-host-entries.ttyS1: Remove db1057

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

Change subject: site.pp,linux-host-entries.ttyS1: Remove db1057
..


site.pp,linux-host-entries.ttyS1: Remove db1057

db1057 is broken and will never come back

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

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



diff --git a/manifests/site.pp b/manifests/site.pp
index 846c145..b162490 100644
--- a/manifests/site.pp
+++ b/manifests/site.pp
@@ -386,7 +386,7 @@
 }
 }
 
-node /^db10(51|55|57|66|67|72|73|80|83|89)\.eqiad\.wmnet/ {
+node /^db10(51|55|66|67|72|73|80|83|89)\.eqiad\.wmnet/ {
 class { '::role::mariadb::core':
 shard => 's1',
 }
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 67a165d..d7afa8b 100644
--- a/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
+++ b/modules/install_server/files/dhcpd/linux-host-entries.ttyS1-115200
@@ -1088,11 +1088,6 @@
 fixed-address db1056.eqiad.wmnet;
 }
 
-host db1057 {
-hardware ethernet 90:B1:1C:28:35:C6;
-fixed-address db1057.eqiad.wmnet;
-}
-
 host db1059 {
 hardware ethernet 90:B1:1C:2A:D3:AE;
 fixed-address db1059.eqiad.wmnet;
diff --git a/modules/role/files/prometheus/mysql-core_eqiad.yaml 
b/modules/role/files/prometheus/mysql-core_eqiad.yaml
index f502a7a..aadfb2f 100644
--- a/modules/role/files/prometheus/mysql-core_eqiad.yaml
+++ b/modules/role/files/prometheus/mysql-core_eqiad.yaml
@@ -4,7 +4,6 @@
   targets:
   - db1051:9104
   - db1055:9104
-  - db1057:9104
   - db1065:9104
   - db1066:9104
   - db1072:9104

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

Gerrit-MessageType: merged
Gerrit-Change-Id: I6628e758b886a5a331b56b3712a125e706c14321
Gerrit-PatchSet: 5
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 db2061

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

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

db-codfw.php: Depool db2061

db2061 needs an ALTER table
pool db2068 for API meanwhile

Bug: T160390
Change-Id: Id58eb10a1452c5aaeff5e13e60e963707f3c15d0
---
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/78/346278/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1f7e24b..dafe5e7 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -147,8 +147,8 @@
'db2040' => 200, # C6 2.9TB 160GB, rc, log
'db2047' => 400, # C6 2.9TB 160GB
'db2054' => 200, # D6 2.9TB 160GB, dump (inactive), vslow
-   'db2061' => 200, # D6 3.3TB 160GB, api
-   'db2068' => 300, # D6 3.3TB 160GB
+#  'db2061' => 200, # D6 3.3TB 160GB, api T160390
+   'db2068' => 200, # D6 3.3TB 160GB #temporary api T160390
],
'silver' => [
'silver' => 100,   # I have no idea if this is right
@@ -407,7 +407,7 @@
'db2054' => 1,
],
'api' => [
-   'db2061' => 1,
+   'db2068' => 1,
],
],
 ],

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

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

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

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

db-eqiad.php: Depool db1086

db1086 needs an alter table

Bug: T160390
Change-Id: I7f72199acf080a2b961d064cb269a15383daa8d8
---
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/08/346108/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 981bec3..5188519 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -166,7 +166,7 @@
 #  'db1039' => 0,   # B2 1.4TB  64GB
 #  'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
'db1079' => 300, # A2 3.6TB 512GB, api
-   'db1086' => 500, # B3 3.6TB 512GB, api
+#  'db1086' => 500, # B3 3.6TB 512GB, api #T160390
'db1094' => 500, # D2 3.6TB 512GB
],
'silver' => [
@@ -417,7 +417,7 @@
],
'api' => [
'db1079' => 100,
-   'db1086' => 1,
+#  'db1086' => 1,
],
'watchlist' => [
'db1034' => 1,

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

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

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

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

db-eqiad.php: Depool db1070

db1070 is going to be compressed
Pool db1071 into vslow and db1087 into api while the compression takes
place

Change-Id: I0275e0af771e6547115814ee3d742add818514b0
---
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/02/346102/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index e05d8ac..981bec3 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -141,10 +141,10 @@
'db1049' => 0,   # B1 2.8TB  64GB, master
'db1026' => 1,   # B1 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
'db1045' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
-   'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
-   'db1071' => 50,  # D1 2.8TB 160GB, api
+#  'db1070' => 50,  # D1 2.8TB 160GB, vslow, dump #ROW based 
replication - master for db1095 #T137191
+   'db1071' => 50,  # D1 2.8TB 160GB, api #temporary vslow - 
#T137191
'db1082' => 300, # A2 3.6TB 512GB, api
-   'db1087' => 500, # C2 3.6TB 512GB
+   'db1087' => 200, # C2 3.6TB 512GB #temporary api - #T137191
'db1092' => 500, # D2 3.6TB 512GB
],
's6' => [
@@ -352,13 +352,13 @@
],
's5' => [
'vslow' => [
-   'db1070' => 1,
+   'db1071' => 1,
],
'dump' => [
-   'db1070' => 1,
+   'db1071' => 1,
],
'api' => [
-   'db1071' => 1,
+   'db1087' => 1,
'db1082' => 1,
],
'watchlist' => [

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

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

2017-04-12 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1072"

This reverts commit 64260acc568d0d5e319c6862312b6c9ff31cd261.

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8092917..c9b620b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -98,9 +98,9 @@
'db1051' => 50,  # B3 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1055' => 50,  # C2 2.8TB  96GB, watchlist, recentchanges, 
contributions, logpager
'db1065' => 0,   # D1 2.8TB 160GB, vslow, dump, master for 
sanitarium
-   'db1066' => 20,  # D1 2.8TB 160GB, api #less main traffic 
weight T132416
-#  'db1072' => 50,  # B2 2.8TB 160GB, api #T132416
-   'db1073' => 20,  # B3 2.8TB 160GB, api #less main traffic 
weight T132416
+   'db1066' => 50,  # D1 2.8TB 160GB, api
+   'db1072' => 50,  # B2 2.8TB 160GB, api
+   'db1073' => 50,  # B3 2.8TB 160GB, api
'db1080' => 500, # A2 3.6TB 512GB
'db1083' => 500, # B1 3.6TB 512GB
'db1089' => 500, # C3 3.6TB 512GB
@@ -264,7 +264,7 @@
],
'api' => [
'db1066' => 1,
-#  'db1072' => 1,
+   'db1072' => 1,
'db1073' => 1,
],
],

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

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

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

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

2017-04-11 Thread Marostegui (Code Review) 
Marostegui has uploaded a new change for review. ( 
https://gerrit.wikimedia.org/r/347805 )

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

db-eqiad.php: Depool db1093

db1093 needs an index added

Bug: T17441
Change-Id: Iee7bcd687b9fb2dd55ee0fb2c2f497301ded90b7
---
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/347805/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 8092917..448e58b 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -156,7 +156,7 @@
 #  'db1061' => 1,   # D1 2.8TB 128GB
'db1085' => 500, # B3 3.6TB 512GB
'db1088' => 500, # C2 3.6TB 512GB
-   'db1093' => 500, # D2 3.6TB 512GB
+#  'db1093' => 500, # D2 3.6TB 512GB T17441
],
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master

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

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

2017-04-12 Thread Marostegui (Code Review) 
Hello Florianschmidtwelzow, jenkins-bot,

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

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

to review the following change.


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

Revert "db-eqiad.php: Depool db1093"

This reverts commit 7f37368d06c0d65da9a64ebf4c01b954baf497b6.

Change-Id: Ib030097393cda8a43716421a6a3441f1eb69b9b0
---
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/10/347810/1

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 448e58b..8092917 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -156,7 +156,7 @@
 #  'db1061' => 1,   # D1 2.8TB 128GB
'db1085' => 500, # B3 3.6TB 512GB
'db1088' => 500, # C2 3.6TB 512GB
-#  'db1093' => 500, # D2 3.6TB 512GB T17441
+   'db1093' => 500, # D2 3.6TB 512GB
],
's7' => [
'db1041' => 0,   # B2 1.4TB  64GB, master

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

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

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

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

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

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

db-eqiad.php: Depool db1079

db1079 needs an ALTER table

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


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

diff --git a/wmf-config/db-eqiad.php b/wmf-config/db-eqiad.php
index 621b631..dd0039e 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -165,8 +165,8 @@
'db1034' => 1,   # B2 1.4TB  64GB, watchlist, recentchanges, 
contributions, logpager
 #  'db1039' => 0,   # B2 1.4TB  64GB
 #  'db1062' => 1,   # D1 2.8TB 128GB, watchlist, recentchanges, 
contributions, logpager
-   'db1079' => 300, # A2 3.6TB 512GB, api
-   'db1086' => 500, # B3 3.6TB 512GB, api
+#  'db1079' => 300, # A2 3.6TB 512GB, api #T160390
+   'db1086' => 200, # B3 3.6TB 512GB, api #less weight than usual 
T160390
'db1094' => 500, # D2 3.6TB 512GB
],
'silver' => [
@@ -416,7 +416,7 @@
'db1028' => 1,
],
'api' => [
-   'db1079' => 100,
+#  'db1079' => 100,
'db1086' => 1,
],
'watchlist' => [

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

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

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

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

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

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

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

tempdb2001 is a temporary host that will be used to have redundancy in
x1 until we get the new servers installed

Bug: T162290
Change-Id: Ia5daf33626673e33e3629bc0df61277045155156
---
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/64/346764/1

diff --git a/wmf-config/db-codfw.php b/wmf-config/db-codfw.php
index 1f7e24b..d0592d5 100644
--- a/wmf-config/db-codfw.php
+++ b/wmf-config/db-codfw.php
@@ -556,6 +556,7 @@
'db2068' => '10.192.48.20', # do not remove or comment out
'db2069' => '10.192.48.21', # do not remove or comment out
'db2070' => '10.192.32.5', # do not remove or comment out
+   'tempdb2001' => '10.192.48.14', # 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 dd0039e..5519713 100644
--- a/wmf-config/db-eqiad.php
+++ b/wmf-config/db-eqiad.php
@@ -582,6 +582,7 @@
'db2068' => '10.192.48.20', # do not remove or comment out
'db2069' => '10.192.48.21', # do not remove or comment out
'db2070' => '10.192.32.5', # do not remove or comment out
+   'tempdb2001' => '10.192.48.14', # 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/346764
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

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

<    1   2   3   4   5   6   7   8   9   10   >