Database Structure

Database Structure

DQM^2 Mirror requires two databases when running, one for storing production machines' status, and another for playback machines.

In each of the databases, the following tables are created:

• runs, which stores information about CMSSW jobs (which host they run on, the jobs' logs, their exit code, etc.)
• graphs, which stores graph data: file delivery, events processed over time. TODO: Add more details.
• hostnames, which stores the hostnames of the cluster machines.
• hoststatuses, which stores a status of each host in hostnames.

runs

This table's columns are defined in db.py

graphs

This table's columns are defined in db.py