computing

Datasets marked bad or unavailable

Under:

This page will list datasets we have marked as bad or unavailable with the reasons listed below.

dAu(2008) with new alignment

Under:

Hao Qiu was able to calibrate alignment of the TPC sectors for Run 8, but this has not yet been used for large sc

Contact persons for remote db mirrors

Post procurement 1 space topology

Following the Disk space for FY09, here is the new space topology and space allocation. 

Set up replication slave for Offline and FC databases

Currently, STAR is able to provide nightly Offline and FC snapshots to allow easy external db mirror setup.
Generally, one will need three things :

Offline DB performance study

Offline Database is READ-heavy (99% reads / 1% writes due to replication), therefore it should benefit from various buffers optimization, elimination of key-less joins and disk (ram) IO improvement

MySQL Version Upgrades

Under:

This section contains information about MySQL version upgrades and related issues. Mostly, it is required to keep track of nuances..

ChangeLog:

Replication

Replication enables data from one MySQL database server (called the master) to be replicated to one or more MySQL database servers (slaves).

Security

Under:

This section contains references to database security-related topics like security scan information, access to db from outside of BNL firewall, user account privileges etc.

Monitoring

Under:

Database monitoring

Following tools are available for replication check:

Maintenance

Database maintenance tasks: monitoring, backup, upgrades, performance issues, server list etc...

FileCatalog Databases

FileCatalog databases

Current Filecatalog databases are :

Software Infrastructure Databases

There are several applications in STAR, which use databases as back-end. Those databases are not directly related to data analysis.

Offline Databases

Under:

Offline Databases

Offline databases are :

Online Databases

Online Databases

Online databases are :

onldb.starp.bnl.gov:3501 - contains 'RunLog', 'Shift Sign-up' and 'Online' databases

How-To: admin section

This section contains various pages explaining how to do typical STAR DB administrative tasks.

Frequently Asked Questions

Under:

Frequently Asked Questions

Q: I am completely new to databases, what should I do first?

Databases

Under:

STAR DATABASE INFORMATION PAGES

N Server type Server Contact

EVO Conference Computer

If you would like to be able to use EVO in the 1006 trailer, there is a conference PC setup for use.  There is a generic account on the computer for everyone to share.

Domain scanning

General

Domain scanning page shows when the STAR domain were last scanned. Quarterly scans are mandated by BNL CSPP. In red, ongoing scans or lines needing update based on results.