Closed
Bug 750806
Opened 12 years ago
Closed 12 years ago
Database cleanup post-buildbot move
Categories
(Data & BI Services Team :: DB: MySQL, task)
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 | ||
Comment 1•12 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•12 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•12 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•12 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•12 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
Closed: 12 years ago
Resolution: --- → FIXED
Assignee | ||
Comment 6•12 years ago
|
||
Just FYI, no changes were made today on buildbot, that's how it already was.
Updated•10 years ago
|
Product: mozilla.org → Data & BI Services Team
You need to log in
before you can comment on or make changes to this bug.
Description
•