Page MenuHomePhabricator

Enable report_host on candidate masters
Open, MediumPublic

Description

This is the current list of candidate masters (taken from hiera) that need a mysql restart to pick up report_host flag enablement:

  • db1075
  • db1076
  • db1093
  • db1109
  • db1130
  • db1134
  • db1136
  • db1138
  • db1141
  • db1149
  • db2080
  • db2103
  • db2104
  • db2110
  • db2113
  • db2114
  • db2121
  • db2127
  • es1020
  • es1023
  • es2020
  • es2024

Event Timeline

Marostegui triaged this task as Medium priority.Mon, Jan 4, 2:31 PM
Marostegui created this task.
Marostegui moved this task from Triage to Ready on the DBA board.

codfw ones should be easy, the rest would need depooling and we should probably take the opportunity to upgrade kernels if there're pending updates.

Mentioned in SAL (#wikimedia-operations) [2021-01-04T14:34:42Z] <marostegui> Upgrade and restart mysql on es2020 and es2024 - T271106

Marostegui updated the task description. (Show Details)Mon, Jan 4, 2:54 PM
Marostegui moved this task from Ready to In progress on the DBA board.Tue, Jan 5, 6:27 AM

Mentioned in SAL (#wikimedia-operations) [2021-01-05T08:30:26Z] <marostegui> Restart db2127 T271106

# for i in es2020 es2024 db2127; do mysql.py -h$i -e "select @@report_host";done
+--------------------+
| @@report_host      |
+--------------------+
| es2020.codfw.wmnet |
+--------------------+
+--------------------+
| @@report_host      |
+--------------------+
| es2024.codfw.wmnet |
+--------------------+
+--------------------+
| @@report_host      |
+--------------------+
| db2127.codfw.wmnet |
+--------------------+
Marostegui updated the task description. (Show Details)Tue, Jan 5, 8:38 AM

Mentioned in SAL (#wikimedia-operations) [2021-01-05T12:01:40Z] <marostegui> Restart db2121 T271106

Marostegui updated the task description. (Show Details)Tue, Jan 5, 12:24 PM

Mentioned in SAL (#wikimedia-operations) [2021-01-12T10:13:19Z] <marostegui> Restart mysql on db1138 to pick up new config T271427 T271106

Marostegui updated the task description. (Show Details)Tue, Jan 12, 10:15 AM
root@db1138:~# mysql -e "select @@report_host"
+--------------------+
| @@report_host      |
+--------------------+
| db1138.eqiad.wmnet |
+--------------------+

Mentioned in SAL (#wikimedia-operations) [2021-01-13T09:49:43Z] <marostegui> Enable report_host on all codfw sby masters - T271106

enabled on all candidate masters at codfw

db2080
+--------------------+
| @@report_host      |
+--------------------+
| db2080.codfw.wmnet |
+--------------------+
db2103
+--------------------+
| @@report_host      |
+--------------------+
| db2103.codfw.wmnet |
+--------------------+
db2104
+--------------------+
| @@report_host      |
+--------------------+
| db2104.codfw.wmnet |
+--------------------+
db2110
+--------------------+
| @@report_host      |
+--------------------+
| db2110.codfw.wmnet |
+--------------------+
db2113
+--------------------+
| @@report_host      |
+--------------------+
| db2113.codfw.wmnet |
+--------------------+
db2114
+--------------------+
| @@report_host      |
+--------------------+
| db2114.codfw.wmnet |
+--------------------+
db2121
+--------------------+
| @@report_host      |
+--------------------+
| db2121.codfw.wmnet |
+--------------------+
db2127
+--------------------+
| @@report_host      |
+--------------------+
| db2127.codfw.wmnet |
+--------------------+
Marostegui updated the task description. (Show Details)Wed, Jan 13, 9:57 AM

Mentioned in SAL (#wikimedia-operations) [2021-01-13T09:59:05Z] <marostegui> Enable report_host on es1020 T271106

root@es1020:~# mysql -e "select @@report_host"
+--------------------+
| @@report_host      |
+--------------------+
| es1020.eqiad.wmnet |
+--------------------+
Marostegui updated the task description. (Show Details)Wed, Jan 13, 10:02 AM