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)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
== Web Interface ==
 
== Web Interface ==
 +
 +
https://halldweb.jlab.org/rcdb
  
 
== 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 ==
 +
 +
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 ===
 
=== 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.