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 | apw | Record flight software builds |
| Should move to central server. Always accesses the database using the glastDB alias. | mysql-node01 |
| ||||
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 | Extra Original copy of I&T elog prior to copy to oracle? . | No | Archive | N/A | Yes | ||||
elogbook_bt | chee | Extra 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 | apw | Record LAT test executive (LTX) runs. |
| Should move to central server. Always accesses the database using the glastDB alias. | mysql-node01 |
| ||||
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 |
|
| Anyway, let's move it. | 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 |
|