Database | Responsible | Comment | Direct access | Action | Destination | Complete |
---|---|---|---|---|---|---|
Archive | kuss | used with the Archiver | No | Should move to central server and inform when migrating glastDB alias from glastlnx01 | mysql-node01 |
|
RM | kuss | appears to be an older version of ReleaseManager database |
| Pending details of contents, possibly we will discard. | mysql-node01 |
|
ReleaseManager | kuss | Does use in CMT RM web pages require access outside SLAC? | Should move to central server and inform when migrating glastDB alias from glastlnx01 | mysql-node01 |
| |
Workflow | kuss | a component of CMT Release Manager | No | Should move to central server and inform when migrating glastDB alias from glastlnx01 | mysql-node01 |
|
Workflow_v2 | kuss | contains one record in settings table. Not clear this is currently used by CMT RM, but we think it doesn't hurt to move it over. | No | Should move to central server and inform when migrating glastDB alias from glastlnx01 | mysql-node01 |
|
bsub | kuss | a component of CMT Release Manager | No | Should move to central server and inform when migrating glastDB from glastlnx01 | mysql-node01 |
|
calib | jrb | calibrations database | Yes | Should move to central server and inform when migrating glastCalibDB alias from glastlnx01 | mysql-node03 | Successfully tested reads in new location with test_Gleam and production job. Newest version of rdbGUI, used for writing, connects and reads successfully. |
calib_test | jrb | calibrations test | Yes | Should move to central server and inform when migrating glastCalibDB alias from glastlnx01 | mysql-node03 | Newest version of rdbGUI connects, reads and writes successfully |
calib_user | jrb | calibrations | Yes | Should move to central server and inform when migrating glastCalibDB alias from glastlnx01 | mysql-node03 |
|
cmx kiml | apw | Record flight software builds |
| Should move to central server. Always accesses the database using the glastDB alias. | mysql-node01 Decision pending discussion with Tony Waite |
|
crl_db | tonyj | OpsLog database. | No | Should move to central server. Uses glastdb alias (configured in /nfs/farm/g/glast/u11/tomcat/data/elog/LogBook_admin/LogbookConfigParms.properties) | mysql-node01 |
|
cron | kuss | a component of CMT Release Manager | No | Should move to central server | mysql-node01 |
|
dependency | kuss | Does use in CMT installer require outside SLAC access? | Should move to central server | mysql-node01 |
| |
elogbook | chee | Original copy of I&T elog prior to copy to oracle. | No | Archive | N/A | Yes |
elogbook_bt | chee | Original copy of BeamTest elog prior to copy to oracle. | No | Archive | N/A | Yes |
log | kuss | a component of CMT Release Manager to store build history | No | Should move to central server | mysql-node01 |
|
lsf | kuss | a component of CMT Release Manager to store temporarily info associated with a running job | No | Should move to central server | mysql- node01 |
|
ltx_db kiml | apw | Record LAT test executive (LTX) runs. |
| Should move to central server. Always accesses the database using the glastDB alias. | mysql-node01 Decision pending discussion with Tony Waite |
|
mood | jrb and panetta | MOOD database on glastlnx01 and glastlnx02 are mirrors for production version on glastlnx06 | Yes | Provide mirror on central server or elsewhere to act as hot spare for glastlnx06 | mysql-node03 | Yes |
mood_test | jrb and panetta | MOOD database used for testing | Yes | Should be moved to central server | mysql-node03 |
|
mood_user | jrb and panetta | No longer needed |
| Remove from glastlnx01, glastlnx02, glastlnx06 | N/A |
|
mstore | kuss | Used as part of the Archiver | No | Should be moved to central server | mysql-node01 |
|
systests | ? | seems to be unused, likely associated with the system tests |
| Archive? | N/A |
|
usermanager | kuss | Seems to be used in CMT Release Manager | Michael: I guess "No" | Should be moved to central server | mysql-node01 |
|