Difference between revisions of "GlueX Implementation of the RCDB"
From GlueXWiki
(→Database Servers) |
|||
| 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 == | ||
Revision as of 15:46, 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.
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.
