Online Server Port Map
Below is a port/node mapping for the online databases both Current and Archival
Archival
| Run/Year | NODE | Port |
| Run1 | dbbak.starp.bnl.gov | 3400 |
| Run2 | dbbak.starp.bnl.gov | 3401 |
| Run3 | dbbak.starp.bnl.gov | 3402 |
| Run4 | dbbak.starp.bnl.gov | 3403 |
| Run5 | dbbak.starp.bnl.gov | 3404 |
| Run6 | dbbak.starp.bnl.gov | 3405 |
| Run7 | dbbak.starp.bnl.gov | 3406 |
| Run8 | dbbak.starp.bnl.gov | 3407 |
CURRENT
| DATABASE | NODE | Port |
| Run Log, Conditions_rts, Shift Signup, Shift Log | onldb.starp.bnl.gov | 3501 |
| Conditions | onldb.starp.bnl.gov | 3502 |
| Daq Tag Tables | onldb.starp.bnl.gov | 3503 |
Procedures:
At the end of the Run - 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.
Move the previous run to dbbak.starp
Send email announcing the creation of this port, so web pages can be changed.
Tar/zip the directories and ship them to HPSS.
Prior to the next Run: 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.
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.