Difference between revisions of "GlueX Implementation of the RCDB"

From GlueXWiki
Jump to: navigation, search
(SQLite Database Files)
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
  
 
== Database Servers ==
 
== 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 ==
 
== SQLite Database Files ==
Line 16: Line 20:
  
 
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.
 
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.
 +
 +
To use this form of the database, set your RCDB_CONNECTION environment to the following value:
 +
 +
sqlite:////group/halld/www/halldweb/html/dist/rcdb.sqlite
  
 
=== Backup Scheme ===
 
=== Backup Scheme ===

Latest revision as of 15:51, 16 November 2020

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.

To use this form of the database, set your RCDB_CONNECTION environment to the following value:

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

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.