Closed Bug 750806 Opened 12 years ago Closed 12 years ago

Database cleanup post-buildbot move

Categories

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

x86
macOS
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: scabral, Assigned: scabral)

References

Details

- 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: server-ops-database → scabral
See Also: → 707203
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.
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
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
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.
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
Closed: 12 years ago
Resolution: --- → FIXED
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.