Page MenuHomePhabricator

Recompress special slaves across eqiad and codfw
Closed, ResolvedPublic

Description

We need to review and recompress all the tables across all the special slaves:

  • s1
    • db1099
    • db1105
    • db2085
    • db2088
  • s2
    • db1103
    • db1105
    • db2088
    • db2091
  • s4
    • db1097
    • db1103
    • db2084
    • db2091
  • s5
    • db1096
    • db1097
    • db2084
    • db2089
  • s6
    • db1096
    • db1098
    • db2087
    • db2089
  • s7
    • db1098
    • db1101
    • db2086
    • db2087
  • s8

Event Timeline

Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to In progress on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2019-10-16T12:20:26Z] <marostegui> Compress tables on db1099:3311 - T235599

Mentioned in SAL (#wikimedia-operations) [2019-10-17T12:50:02Z] <marostegui> Compress tables on db2088:3312 - T235599

Mentioned in SAL (#wikimedia-operations) [2019-10-17T12:52:49Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db2088:3312 for compression T235599', diff saved to https://phabricator.wikimedia.org/P9379 and previous config saved to /var/cache/conftool/dbconfig/20191017-125248-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2019-10-18T05:15:16Z] <marostegui> Compress tables on db2091:3314 T235599

Mentioned in SAL (#wikimedia-operations) [2019-10-18T13:02:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db2084:3315 for tables compression T235599', diff saved to https://phabricator.wikimedia.org/P9390 and previous config saved to /var/cache/conftool/dbconfig/20191018-130253-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2019-10-21T05:25:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repool db2088:3312 db2084:3315 - T235599', diff saved to https://phabricator.wikimedia.org/P9397 and previous config saved to /var/cache/conftool/dbconfig/20191021-052527-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2019-10-21T05:28:22Z] <marostegui> Compress tables on db2084:3314 db2091:3312 - T235599

Mentioned in SAL (#wikimedia-operations) [2019-10-22T05:02:06Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db2089:3315 for compression T235599', diff saved to https://phabricator.wikimedia.org/P9421 and previous config saved to /var/cache/conftool/dbconfig/20191022-050204-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2019-10-23T06:38:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1097:3315 for compression T235599', diff saved to https://phabricator.wikimedia.org/P9445 and previous config saved to /var/cache/conftool/dbconfig/20191023-063800-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2019-10-23T06:38:31Z] <marostegui> Compress tables on db1097:3315 T235599

Mentioned in SAL (#wikimedia-operations) [2019-11-12T06:20:00Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db2087:3316, db2087:3317 for compression - T235599', diff saved to https://phabricator.wikimedia.org/P9588 and previous config saved to /var/cache/conftool/dbconfig/20191112-061959-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2019-11-12T06:21:17Z] <marostegui> Compress db2087:3316, db2087:3317 T235599

Mentioned in SAL (#wikimedia-operations) [2019-11-14T07:54:50Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1103:3312 T235599', diff saved to https://phabricator.wikimedia.org/P9631 and previous config saved to /var/cache/conftool/dbconfig/20191114-075449-marostegui.json

Marostegui updated the task description. (Show Details)

All done