Online Server Port Map

Below is a port/node mapping for the online databases both Current and Archival


Archival


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

CURRENT (RUN 20 -> 21)


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
27018
27019

 

End of the run procedures:

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.

Prior to the next Run: 

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