A MySQL Based EPICS Archiver

Conference · Thu Oct 01 04:00:00 EDT 2009

OSTI ID:1023592

Slominski, Christopher

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.

• Research Organization: Thomas Jefferson National Accelerator Facility, Newport News, VA (United States)
• Sponsoring Organization: USDOE Office of Science (SC)
• DOE Contract Number: AC05-06OR23177
• OSTI ID: 1023592
• Report Number(s): JLAB-ACO-09-1080; DOE/OR/23177-1011
• Country of Publication: United States
• Language: English

Related Subjects

43 PARTICLE ACCELERATORS
ACCELERATORS
COMPUTERIZED CONTROL SYSTEMS
DATA ACQUISITION SYSTEMS
DATA PROCESSING
INFORMATION RETRIEVAL
PERFORMANCE