| Run/Year | NODE | Port |
| Run 1 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3400 |
| Run 2 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3401 |
| Run 3 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3402 |
| Run 4 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3403 |
| Run 5 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3404 |
| Run 6 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3405 |
| Run 7 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3406 |
| Run 8 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3407 |
| Run 9 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3408 |
| Run 10 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3409 |
| Run 11 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3410 |
| Run 12 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3411 |
| Run 13 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3412 |
| Run 14 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3413 |
| Run 15 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3414 |
| Run 16 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3415 |
| Run 17 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3416 |
| Run 18 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3417 |
| Run 19 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3418 |
| Run 20 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3419 |
| Run 21 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3420 |
| Run 22 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3421 |
| Run 23 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3422 |
| Run 24 | dbbak.starp.bnl.gov / db04.star.bnl.gov | 3423 |
| DATABASE | NODE | Port |
| [MASTER] Run Log, Conditions_rts, Shift Signup, Shift Log | onldb.starp.bnl.gov | 3501 |
| [MASTER] Conditions | onldb.starp.bnl.gov | 3502 |
| [MASTER] Daq Tag Tables | onldb.starp.bnl.gov | 3503 |
| [SLAVE] Run Log, Conditions_rts, Shift Signup, Shift Log | onldb2.starp.bnl.gov onldb3.starp.bnl.gov onldb4.starp.bnl.gov mq01.starp.bnl.gov mq02.starp.bnl.gov |
3501 |
| [SLAVE] Conditions | onldb2.starp.bnl.gov onldb3.starp.bnl.gov onldb4.starp.bnl.gov mq01.starp.bnl.gov mq02.starp.bnl.gov |
3502 |
| [SLAVE] Daq Tag Tables | onldb2.starp.bnl.gov onldb3.starp.bnl.gov onldb4.starp.bnl.gov mq01.starp.bnl.gov mq02.starp.bnl.gov |
3503 |
| [MASTER] MQ Conditions DB | mq01.starp.bnl.gov | 3606 |
| [SLAVE] MQ Conditions DB | mq02.starp.bnl.gov onldb2.starp.bnl.gov onldb3.starp.bnl.gov onldb4.starp.bnl.gov |
3606 |
| RTS Database (MongoDB cluster) | mongodev01.starp.bnl.gov mongodev02.starp.bnl.gov mongodev03.starp.bnl.gov |
27017 |
1. Freeze databases (especially ShiftSignup on 3501) by creating a new db instance on the next sequential port from the archival series and copy all dbs from all three ports to this port.
2. Move the previous run to dbbak.starp
3. Send email announcing the creation of this port, so web pages can be changed.
4. Tar/zip the directories and ship them to HPSS.
1. Clear out the dbs on the "current" ports. NOTE: do not clear out overhead tables (e.g., Nodes, NodeRelations, blahIDs etc.). There is a script on onldb /online/production/databases/createTables which does this. Make sure you read the README.
UPDATE: more advanced script to flush db ports is attached to this page (chdb.sh). Existing " createPort350X.sql " files do not care about overhead tables!
UPDATE.v2: RunLog.runTypes & RunLog.detectorTypes should not be cleared too // D.A.
UPDATE.V3: RunLog.destinationTypes should not be cleared // D.A.
Confirm all firewall issues are resolved from both the IP TABLES on the local host and from an institutional networking perspective. This should only really need to be addressed with a new node, but it is good to confirm prior to advertising availability.
Update the above tables.
2. Verify that Online/Offline Detector ID list matches to RunLog list (table in RunLog db) :
http://www.star.bnl.gov/cgi-bin/protected/cvsweb.cgi/StRoot/RTS/include/rtsSystems.h