Database cleanup post-buildbot move

RESOLVED FIXED

Status

RESOLVED FIXED
7 years ago
4 years ago

People

(Reporter: scabral, Assigned: scabral)

Tracking

Details

(Assignee)

Description

7 years ago
- 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
(Assignee)

Updated

7 years ago
Assignee: server-ops-database → scabral
See Also: → bug 707203
(Assignee)

Comment 1

6 years ago
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.
(Assignee)

Comment 2

6 years ago
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
(Assignee)

Comment 3

6 years ago
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
(Assignee)

Comment 4

6 years ago
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.
(Assignee)

Comment 5

6 years ago
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.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
(Assignee)

Comment 6

6 years ago
Just FYI, no changes were made today on buildbot, that's how it already was.
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.