Search NASA⌕ Search

DOE OSTI · 1023592

A MySQL Based EPICS Archiver

Abstract

Archiving a large fraction of the EPICS signals within the Jefferson Lab (JLAB) Accelerator control system is vital for postmortem and real-time analysis of the accelerator performance. This analysis is performed on a daily basis by scientists, operators, engineers, technicians, and software developers. Archiving poses unique challenges due to the magnitude of the control system. A MySQL Archiving system (Mya) was developed to scale to the needs of the control system; currently archiving 58,000 EPICS variables, updating at a rate of 11,000 events per second. In addition to the large collection rate, retrieval of the archived data must also be fast and robust. Archived data retrieval clients obtain data at a rate over 100,000 data points per second. Managing the data in a relational database provides a number of benefits. This paper describes an archiving solution that uses an open source database and standard off the shelf hardware to reach high performance archiving needs. Mya has been in production at Jefferson Lab since February of 2007.

Explore related subjects

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

Slominski, Christopher. 2009-10-01. A MySQL Based EPICS Archiver. https://www.osti.gov/biblio/1023592

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related reports

Design and Integration of High Precision Superconducting Magnet Power Supply Systems

This paper reviews the design and integration approach being taken to power more than 400 superconducting magnets in Electron Ion Collider (EIC) by power supplies ranging from 20V to 400V and 100A to 18kA. A major challenge is to integrate existing legacy power supplies with new high current systems and maximize performance and reduce costs. Successful implementation requires coordinated integration of power convertors, current regulation, quench protection, energy extraction, machine protection, controls and existing accelerator infrastructure.

43 PARTICLE ACCELERATORS↗

Searching for the Most Harmful Field Errors in the HSR IR Superconducting Magnets

In this project, we improve beam stability for the Electron-Ion Collider. Magnetic field errors can reduce beam stability, making it essential to identify the field errors that have the greatest impact on accelerator performance. However, this is particularly challenging because beam stability depends on the complex interactions of many magnetic field errors, resulting in a high-dimensional and nonlinear optimization problem. We determine which field errors are the most influential for the large physical aperture superconducting magnet B2PF, a critical magnet in the Interaction Region (IR) in the Hadron Storage Ring (HSR). We complete and analyze nearly 30,000 simulations on the Brookhaven National Laboratory Linux Cluster by varying 18 nonlinear magnetic field errors. We evaluate beam stability using the dynamic aperture and the tune diffusion. We identify the field errors that most strongly influence beam stability and establish quantitative field error tolerances that improve accelerator performance.

43 PARTICLE ACCELERATORS↗