Database | Responsible | Comment | Direct access | Action | Destination | Complete | ||
---|---|---|---|---|---|---|---|---|
Archive | kiml kuss | used with the Archiver | No | Should move to central server and inform when migrating glastDB alias from glastlnx01 | mysql-node01 |
| ||
RM | kiml kuss | appears to be an older version of ReleaseManager database |
| Pending details of contents, possibly we will discard. | mysql-node01 |
| ||
ReleaseManager | kuss | ReleaseManager | kiml | 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 | kiml 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 | kiml 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 | kiml 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 glastDB 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 glastDB 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 glastDB 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 | kiml kuss | a component of CMT Release Manager | No | Should move to central server | mysql-node01 |
| ||
dependency | kiml 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 | kiml kuss | a component of CMT Release Manager to store build history | No | Should move to central server | mysql-node01 |
| ||
lsf | kiml 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 | kiml 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 | kiml kuss | Seems to be used in CMT Release Manager | Michael: I guess "No" | Should be moved to central server | mysql-node01 |
|