GlueX Implementation of the RCDB

From GlueXWiki
Revision as of 15:46, 16 November 2020 by Marki (Talk | contribs) (Database Servers)

Jump to: navigation, search

Web Interface

https://halldweb.jlab.org/rcdb

Database Servers

The master version of the RCDB database is on gluexdb1.jlab.org, located in the Hall D Counting House. The database is also replicated to hallddb.jlab.org for offlie, read-only use. To use this copy, set our RCDB_CONNECTION environment to the following value:

mysql://rcdb@hallddb.jlab.org/rcdb

SQLite Database Files

The latest version of the RCDB, in SQLite form can be downloaded from

https://halldweb.jlab.org/dist/rcdb.sqlite

On the disk at JLab this is

/group/halld/www/halldweb/html/dist/rcdb.sqlite

This file is created daily, but only if changes to the RCDB have been made during the previous day. There is a cron job that runs on sandd1.jlab.org as user gluex at midnight to do this.

Backup Scheme

Each daily version of the SQLite database is written to

/cache/halld/home/gluex/rcdb_sqlite

a location on the write-through cache. They are thus archived to tape before old ones are automatically deleted.