1 / 14

Online & Databases Overview

Online & Databases Overview. Online Activities facilities logging & monitoring tasks Database Items server layout Db timestamps tasks. Online Computing Nuts & Bolts Wayne Betts. Firewall implemented at experiment .starp.bnl.gov => protected subnet

spearsc
Download Presentation

Online & Databases Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Online & Databases Overview • Online Activities • facilities • logging & monitoring • tasks • Database Items • server layout • Db timestamps • tasks Collab. Meeting R. J. Porter BNL

  2. Online Computing Nuts & BoltsWayne Betts • Firewall implemented at experiment • .starp.bnl.gov => protected subnet • managed by us (Wayne) in conjunction with ITD • Conduits for ssh,nfs,nis, and several task specific machine-to-machine protocols • Wireless installed • Subsystem machine support Collab. Meeting R. J. Porter BNL

  3. Online Web Server • Access into starp.bnl.gov subnet • Exported through BNL Firewall Collab. Meeting R. J. Porter BNL

  4. STAR Electronic ShiftLog Gabriele Carcassi Collab. Meeting R. J. Porter BNL

  5. RunLog Browser Period Summaries   Run Summaries Collab. Meeting R. J. Porter BNL

  6. Online Monitoring Akio Ogawa & Jamie Dunlop Star Status Page  Rich Scalers Collab. Meeting R. J. Porter BNL

  7. Trigger AccountingJeff Landgraf Trigger Versioning   Detailed view Collab. Meeting R. J. Porter BNL

  8. Online-to-Offline Db-Data moveJon Gans & Wei-Ming Zhang • Subset of Online Db data used in reco is automatically migrated to offline Collab. Meeting R. J. Porter BNL

  9. Online Near-Term Tasks • Scaler analysis & db loader • Joanna Kiryluk, Akio, ... • RunLog Browser Additional Information • Tell me what you want • Real-time plots of STAR status • Sergey & I are looking into this • Real-time Run/Detector Status Page • Jo Schambach? • Online Web-Server developer service task Collab. Meeting R. J. Porter BNL

  10. Database OverviewOnline • 5 Online Production Servers • Run Server • RunLog, RTS, ShiftLog, ShiftSignup, Scalers, • Input to Fast-Offline, offline dbs, & monitoring • Conditions Server • Conditions_tpc, Conditions_trg, ….11 of ‘em • Input to offline dbs & monitoring • TagDb Server • Daq’s run, file, & event tagdb • Event & file summaries • Y2000 Server + Y2001 Server Collab. Meeting R. J. Porter BNL

  11. Database Overview IIOffline • 1 Primary (Master) Server • 4 Slave servers supporting reco (RCRS) • 1 Slave server supporting RCAS and WAN • 2 Slave servers supporting PDSF • 2 Slave servers at institutions (WSU & San Paulo) • 1 Primary Server for FileCatalog & Operations • Will add slave for RCAS support • Will add slave for PDSF Collab. Meeting R. J. Porter BNL

  12. Database Server Monitoring Tool Gabriele Carcassi • Allows monitoring of the Master and many slave servers • Can be used to perform basic administration tasks • We plan to extend this for general administration tasks Collab. Meeting R. J. Porter BNL

  13. Offline Database Timestamps DAQ & ProdTime • DAQ Timestamp is Primary Index for DB data • ProdTime in chain tells API (StDbLib) to retrieve “frozen” db records • New DB data will not affect production • API & DB Machinery will work for • Old codes & old production time • New codes & new production time • API & DB Machinery may not to work for • New codes & old production times • Old codes & new production times Collab. Meeting R. J. Porter BNL

  14. Database “Near-Term” Tasks • Server maintainence and scalability • Development of our MySQL GUI • Streamline deployment of Slave servers • Add new Server Layout for FileCatalog • BNL Master + Slaves • PDSF Master + Slaves • Begin looking to next generation needs • STAR Size & Rates • STAR-GRID activities • MySQL 4.x, other db engines? Collab. Meeting R. J. Porter BNL

More Related