790414 - decom ip-admin02.phx.mozilla.com database

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Sheeri Cabral [:sheeri]]

ip-admin02 is on MySQL 5.0, but isn't actually using it, and hasn't for 2 years.

[root@ip-admin02 ~]# rpm -qa | grep -i mysql
mysql-server-5.0.77-4.el5_5.4
MySQL-python26-1.2.3c1-1
mysql-5.0.77-4.el5_5.4
mysql-devel-5.0.77-4.el5_5.4
perl-DBD-mysql-4.014-1.el5.rf
mysql-5.0.77-4.el5_5.4
php-mysql-5.2.9-2.rhel5
mysql-devel-5.0.77-4.el5_5.4
[root@ip-admin02 ~]# ls -l /var/lib/mysql
total 20528
-rw-rw---- 1 mysql mysql 10485760 Sep  5  2010 ibdata1
-rw-rw---- 1 mysql mysql  5242880 Sep  5  2010 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 Aug 15  2010 ib_logfile1
drwx------ 2 mysql mysql     4096 Aug 15  2010 mysql
drwx------ 2 mysql mysql     4096 Aug 15  2010 test
[root@ip-admin02 ~]# grep datadir /etc/my.cnf
datadir=/var/lib/mysql

We should be able to decommission the database on this server -remove the db packages other than the client packages.

Comment 1

[Sheeri Cabral [:sheeri]]

These commands did the trick:

[root@ip-admin02 ~]# yum remove mysql-server mysql-devel

[root@ip-admin02 ~]# rm -rf /var/lib/mysql