Author: Giovannini, L.G.
Paper Title Page
WEPC154 EPICS HyperArchiver: initial tests at ESSBilbao 2343
  • M. del Campo
    ESS-Bilbao, Zamudio, Spain
  • M.G. Giacchini, L.G. Giovannini
    INFN/LNL, Legnaro (PD), Italy
  • J. Jugo
    University of the Basque Country, Faculty of Science and Technology, Bilbao, Spain
  Funding: The present work is supported by the Basque Government and Spanish Ministry of Science and Innovation.
The aim of this work is to present the results obtained after different tests performed regarding data storage for an Ion Source, by means of an EPICS control system at ESS-Bilbao (Spain). As a first approach, data was recorded on a MySQL database, using a traditional EPICS RDB Channel Archiver instance, maintained at ORNL SNS (USA). Nevertheless, initial results shown the need of an evolution towards a high performance scalable database. Therefore, current tests are focused on the customization and usage of a HyperArchiver instance, developed at INFN/LNL (Italy), which uses Hypertable as its main database. Hypertable is a distributed, high performance non relational database, released under GNU licence and focused on data-intensive tasks. At ESS Bilbao, a slightly modified version of the HyperArchiver was used, due to the necessity of an improvement on the management of array PVs. Regarding data retrieval and visualization, a python GUI developed at ESS-Bilbao was used, in opposition to the traditional CSS data browser, trying to make data retrieval as fast and simple as possible. Hypertable is presented as a high performance alternative to MySQL for any EPICS control system.