Project

General

Profile

Support #15793

Milestone #15057: Minos SLF5 retirement

Support #15792: Individual Minos SLF5 node shutdowns

retire minos-mysql2

Added by Arthur Kreymer over 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
High
Start date:
03/08/2017
Due date:
03/31/2017
% Done:

100%

Estimated time:
10.00 h
Duration: 24

Description

Retire minos-mysql2

History

#1 Updated by Arthur Kreymer over 3 years ago

  • Priority changed from Normal to High

#2 Updated by Arthur Kreymer over 3 years ago

  • % Done changed from 0 to 10

Summary

Task Completed Comment
Ganglia 03/08 Idle
procsum 03/08 Users off 03/08 (dbmauto logging removed)
data 03/19 /minos/data/mindata/archive/minos-mysql2/data-mysqldata
/minos/data/mindata/archive/minos-mysql2/data-home
home 03/19 /minos/data/mindata/archive/minos-mysql2/minsoft
opt 03/19 will not retain /opt/condor files and logs

Ganglia week average 03/19
Idle 99.6%
Load 1 67m
Net in 622
Net out 3k

#3 Updated by Arthur Kreymer over 3 years ago

  • % Done changed from 10 to 80

Details of file archives

df -hP | grep dev
/dev/sda1              20G  5.1G   14G  28% /
/dev/sda6             174G 1018M  164G   1% /var
/dev/sda3             9.7G  159M  9.1G   2% /tmp
tmpfs                 7.9G   20K  7.9G   1% /dev/shm
/dev/sdb1             2.7T  667G  1.9T  26% /home
/dev/sdc1             917G  329G  542G  38% /data

ls -alF /home
total 56
drwxr-xr-x 10 minsoft root   4096 Feb 14  2012 ./
drwxr-xr-x 33 root    root   4096 Jan 19 09:46 ../
drwxr-xr-x  3 minsoft    27  4096 Jan 21  2011 ettab/
drwxr-xr-x  2 jpaley  e875   4096 Feb 14  2012 jpaley/
drwxr-xr-x  3 kreymer e875   4096 Feb 14  2012 kreymer/
drwxr-xr-x  2 lena    e875   4096 Feb 16  2012 lena/
drwx------  2 root    root  16384 Jul 15  2010 lost+found/
drwxr-xr-x 18 minsoft e875   4096 Jul 15  2010 minosoft.BAD/
drwxr-xr-x 23 minsoft mysql  4096 Mar  9 16:17 minsoft/
drwxr-xr-x  3 root    root   4096 Jul 16  2010 room1/

ettab - abandon
    working files from 2011/01/21 disk failure and SLF5 upgrade
jpaley - empty
kreymer - abandon
    grid/mysqlroot
lena - abaondon 
    mysqlroot
minosoft.BAD - abandon
    dates from 
minsoft - copy, once ran mysql server

cp -ax /home/minsoft ${MA}/minsoft 2>&1 | tee /tmp/minsoftcp

cp -ax /data/mysqldata ${MA}/data-mysqldata

cp -ax /data/home      ${MA}/data-home

Prep for copies, fixing permissions as needed

du -sm  /home/minsoft/* | sort -n
3    /home/minsoft/tmpbackup
27    /home/minsoft/minoscrlMar16.sql
95    /home/minsoft/ups
197    /home/minsoft/MYSQL2T
389    /home/minsoft/BINLOG
2249    /home/minsoft/users
639681    /home/minsoft/archive

MSQL2T files from Feb 2011 system swaps - abandon by moving
mv /home/minsoft/MYSQL2T /home/minosoft.BAD/MYSQL2T
   permission denied, as MYSQL2T is owned by root
will let the copy fail

Clear out the archive - problems with
-rw-r--r--  1 minsoft e875  114042378240 Jun  7  2011 20110607.tar
drwxr-xr-x  3 root    root          4096 Feb  7  2011 ettab.0207.1/
drwxr-xr-x  3 root    root          4096 Feb  7  2011 ettab.0207.2/
drwxr-xr-x  3 root    root          4096 Feb  7  2011 ettab.0207.3/

better yet, block archive and save logs
chmod 700 archive
mkdir archlog
mv archive/*.log archlog/

chmod 7chmod 755 /data/home/tmpbackup/backup-mysqlcrl/mysql
chmod 755 /data/home/tmpbackup/backup-mysqldb/mysql
chmod 755 /data/home//tmpbackup/slvbackup/mysql

chmod 644 /data/mysqldata/mysql/*
chmod 644 /data/home/tmpbackup/slvbackup/mysql/*
chmod 644 /data/home/tmpbackup/backup-mysqldb/mysql/*
chmod 644 /data/home/tmpbackup/backup-mysqlcrl/mysql/*
55 /data/home/tmpbackup/backup-mysqlcrl/mysql
chmod 755 /data/home/tmpbackup/backup-mysqldb/mysql
chmod 755 /data/home//tmpbackup/slvbackup/mysql

chmod 644 /data/mysqldata/mysql/*
chmod 644 /data/home/tmpbackup/slvbackup/mysql/*
chmod 644 /data/home/tmpbackup/backup-mysqldb/mysql/*
chmod 644 /data/home/tmpbackup/backup-mysqlcrl/mysql/*

#4 Updated by Arthur Kreymer over 3 years ago

  • % Done changed from 80 to 90

RITM0540867 03/20 minos-mysql2 shutdown

At your convenience, please shut down the minos-mysql2 system.
This SLF5 system is being retired.

See preparation details in https://cdcvs.fnal.gov/redmine/issues/15793

Please hold the hardware for a month before disposal,
in case we overlooked something.
_________________________________________________________________
2017-03-20 09:30:40 CDT - Timothy Skirvin (Additional comments)
Done.

#5 Updated by Arthur Kreymer over 3 years ago

  • % Done changed from 90 to 100

#6 Updated by Arthur Kreymer over 3 years ago

  • Status changed from Work in progress to Resolved

#7 Updated by Arthur Kreymer about 3 years ago

  • Status changed from Resolved to Closed


Also available in: Atom PDF