Page MenuHomePhabricator
Create Task
Maniphest T245107

Possibly replace db1087 (s8) with db1127 (x1) due to disk space constrains
Closed, DeclinedPublic
Actions

Description

db1087 is sanitarium master in s8.
Right now (pending compression) this is the current status:

root@db1087:/srv/sqldata/wikidatawiki# df -hT /srv
Filesystem            Type  Size  Used Avail Use% Mounted on
/dev/mapper/tank-data xfs   3.6T  3.2T  486G  87% /srv

I have started the compression on it - once done, let's evaluate again the disk space available.
If needed, we can exchange roles with db1127, which is in x1 and it is tiny:

db1127.eqiad.wmnet df -hT /srv/
/dev/mapper/tank-data xfs       4.4T  196G  4.2T   5% /srv

Related Objects
Search...

Event Timeline

Marostegui created this task.Feb 13 2020, 7:08 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 13 2020, 7:08 AM
Marostegui renamed this task from Possibly replace db1087 (s8) with db1127 (x1) to Possibly replace db1087 (s8) with db1127 (x1) due to disk space constrains.Feb 13 2020, 7:08 AM
Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to Pending comment on the DBA board.
Agusbou2015 subscribed.Feb 18 2020, 10:39 PM
Marostegui closed this task as Declined.Feb 28 2020, 6:27 AM

We are good for now after compressing all the tables:

root@db1087:~# df -hT /srv
Filesystem            Type  Size  Used Avail Use% Mounted on
/dev/mapper/tank-data xfs   3.6T  1.6T  2.1T  44% /srv

Going to decline this, as db1087 will be refreshed next FY and we have probably enough room to wait for that refresh.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits