Difference between revisions of "GlueX Implementation of the RCDB"

From GlueXWiki
Jump to: navigation, search
(Created page with "== Web Interface == == Database Servers == == SQLite Database Files == === Backup Scheme === Each daily version of the SQLite database is written to /cache/halld/home/gl...")
 
(SQLite Database Files)
Line 4: Line 4:
  
 
== SQLite Database Files ==
 
== 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 ===
 
=== Backup Scheme ===

Revision as of 12:46, 17 January 2018

Web Interface

Database Servers

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.