946463 - Can we archive these sumo/sumotools databases?

Status: RESOLVED FIXED

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

Description

[Sheeri Cabral [:sheeri]]

The following databases on sumotools look like they haven't been written to in months:

openfire_chat	last written	11/13/2012
b2g_input	last written	1/18/2013
b2g_tags	last written	1/18/2013
sumo_processed	last written	1/18/2013
testpilot_update	last written	1/18/2013
input_mozilla_com	last written	4/18/2013

And these on production SUMO:
openfire_chat	last written	11/13/2012
test	last	written	2/19/2013

If these are not being used, please let me know, and I can archive them (in case we find out we really do need them) and drop the databases.

Comment 1

[Ricky Rosario [:rrosario, :r1cky]]

I don't use or need any of those. I know for sure we can get rid of openfire_chat and test.

Cheng do you know anything about the others?

Comment 2

[[:Cww]]

Yeah, we can archive them. I don't even know what that means but I don't use them anymore.

Comment 3

[Sheeri Cabral [:sheeri]]

Archive means I do a mysqldump of the database and put it in /root/archive on sumotools and support1, so we can put them back if needed.

I will commence doing this now, will let you know when I'm done.

Comment 4

[Sheeri Cabral [:sheeri]]

These databases have been archived and deleted. Please let me know if they need to be restored.