750806 - Database cleanup post-buildbot move

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

- drop buildbot and buildbot_reader users in b1 cluster
- drop users except buildbot, buildbot_reader and other functional users (like root, nagiosdaemon, etc) on buildbot1 cluster
- drop buildbot and buildbot_schedulers dbs in b1 cluster
- drop all but buildbot and buildbot_schedulers dbs in buildbot cluster

Comment 1

[Sheeri Cabral [:sheeri]]

Instead of dropping the db's right now, I'm going to rename them and see if anything breaks, then drop them on Wed or later.

Comment 2

[Sheeri Cabral [:sheeri]]

I have copied the user information into b1-db1.db.scl3:/root/archive/buildbot_users in case we need to restore the users.

mysql> \! hostname
b1-db1.db.scl3.mozilla.com

mysql> drop user buildbot_reader2@10.22.70.20_; drop user buildbot2@10.22.70.209;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)



DONE drop buildbot and buildbot_reader users in b1 cluster
- drop users except buildbot, buildbot_reader and other functional users (like root, nagiosdaemon, etc) on buildbot1 cluster
- drop buildbot and buildbot_schedulers dbs in b1 cluster
- drop all but buildbot and buildbot_schedulers dbs in buildbot cluster

Comment 3

[Sheeri Cabral [:sheeri]]

mysql> \! hostname
b1-db1.db.scl3.mozilla.com

mysql> show databases like 'buildbot%';
Empty set (0.00 sec)

Looks like the db's were already dropped in b1.


DONE drop buildbot and buildbot_reader users in b1 cluster
DONE drop buildbot and buildbot_schedulers dbs in b1 cluster
- drop users except buildbot, buildbot_reader and other functional users (like root, nagiosdaemon, etc) on buildbot1 cluster
- drop all but buildbot and buildbot_schedulers dbs in buildbot cluster

Comment 4

[Sheeri Cabral [:sheeri]]

Looks like the db's were already dropped in buildbot too:



DONE drop buildbot and buildbot_reader users in b1 cluster
DONE drop buildbot and buildbot_schedulers dbs in b1 cluster
- drop users except buildbot, buildbot_reader and other functional users (like root, nagiosdaemon, etc) on buildbot1 cluster
DONE drop all but buildbot and buildbot_schedulers dbs in buildbot cluster

I'll wait on the users until Monday just in case it does make things break.

Comment 5

[Sheeri Cabral [:sheeri]]

users on buildbot:

mysql> select @@hostname;
+-------------------------------+
| @@hostname                    |
+-------------------------------+
| buildbot1.db.scl3.mozilla.com |
+-------------------------------+
1 row in set (0.00 sec)

mysql> select distinct user from mysql.user order by user;
+------------------+
| user             |
+------------------+
| bugs             |
| buildbot2        |
| buildbot_reader2 |
| buildslaves      |
| checksum         |
| clobberer        |
| moz_eu           |
| munin            |
| nagiosdaemon     |
| regressdetect    |
| repl             |
| root             |
+------------------+
12 rows in set (0.00 sec)

So this is done too. Resolving.

Comment 6

[Sheeri Cabral [:sheeri]]

Just FYI, no changes were made today on buildbot, that's how it already was.