A MySQL Based EPICS Archiver
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 (TJNAF), 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; TRN: US1105036
- Resource Relation:
- Conference: ICALEPCS 2009, October 12-16, 2009, Kobe Japan
- Country of Publication:
- United States
- Language:
- English
Similar Records
A Client/Server Architecture for Supporting Science Data Using EPICS Version 4
Structuring an EPICS System to Optimize Reliability, Performance and Cost