Closed Bug 750806 Opened 13 years ago Closed 13 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: 13 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.