Database Distribution: Status

The following tables list the distribution flows in and out of our Master databases.

Site Update name Mode Table Filter
Soudan (minos-offline.minos-soudan.org) SOUDAN_nnnnnnnn.dbm Export BFIELDCOILCURRENT
BFLDDBICOILSTATE
CAL*
DBILOGENTRY
DBU*
DCS*
FAB*
PULSER*
SPILLSERVERMON
FNAL (minos-db1.fnal.gov) SOUDAN_nnnnnnnn.dbm Import None

Site	Update name	Mode	Table Filter
Soudan (minos-offline.minos-soudan.org)	SOUDAN_nnnnnnnn.dbm	Export	BFIELDCOILCURRENT BFLDDBICOILSTATE CAL* DBILOGENTRY DBU* DCS* FAB* PULSER* SPILLSERVERMON
FNAL (minos-db1.fnal.gov)	SOUDAN_nnnnnnnn.dbm	Import	None

Site Update name Mode Table Filter
FNAL (minos-db1.fnal.gov) FNAL_nnnnnnnn.dbm Export *
!DBUVACHIP*
!DCS*
DCS_ENV_*
DCS_MAG_NEAR
!PULSERDRIFT
Soudan (minos-offline.minos-soudan.org) FNAL_nnnnnnnn.dbm Import *
!DBUVA*
!DCS*
!PULSER*

Site	Update name	Mode	Table Filter
FNAL (minos-db1.fnal.gov)	FNAL_nnnnnnnn.dbm	Export	* !DBUVACHIP* !DCS* DCS_ENV_* DCS_MAG_NEAR !PULSERDRIFT
Soudan (minos-offline.minos-soudan.org)	FNAL_nnnnnnnn.dbm	Import	* !DBUVA* !DCS* !PULSER*

i.e.

Soudan is feeding to FNAL:-
- The data that is created automatically i.e. BFIELDCOILCURRENT, BFLDDBICOILSTATE, DBU*, DCS*, PULSER* and SPILLSERVERMON.
- The Calibration updates (CAL*).
- The HWDB (Hardware Database) updates FAB*.
- The database log entries (DBILOGENTRY).
FNAL is transmitting everything apart from DBUVACHIP*, DCS* (except DCS_MAG_NEAR because BFIELDCOILCURRENT doesn't yet have ND data and the DCS_ENV_* tables that are loaded by the calibrator) and the large PULSER table PULSERGAIN. Soudan is rejecting DBUVA*, DCS* and PULSER*, so only keeps its own type of automatically generated data apart from DBUSUBRUNSUMMARYs.

Eventually FNAL may start transmitting all data, but we are currently (Mar 2005) trying to decide how to manage tables that are expected to exceed ~ 1GB.

FNAL updates are written to the publish directory:-

  /afs/fnal.gov/files/data/minos/d210/rsync

where they are accessible both by afs and rsync. The rsync server is minos-db1.fnal.gov::out.

Return to the top-level Database Distribution document
Last Modified: $Date: 2008/09/22 13:12:00 $