Optimization of the storage database for the Monitoring system of the CTA

• Main Authors: Incardona, Federico, Costa, Alessandro, Munari, Kevin, Bruno, Pietro, Germani, Stefano, Grillo, Alessandro, Oya, Igor, Neise, Dominik, Sciacca, Eva, Observatory, for the CTA
• Format: Journal Article
• Language: English
• Published: 13-07-2022
• Subjects: Physics - Instrumentation and Methods for Astrophysics
• DOI: 10.48550/arxiv.2207.06381

We present preliminary test results for the correct sizing of the bare metal
hardware that will host the database of the Monitoring system (MON) for the
Cherenkov Telescope Array (CTA). The MON is the subsystem of the Array Control
and Data Acquisition System (ACADA) that is responsible for monitoring and
logging the overall CTA array. It acquires and stores monitoring points and
logging information from the array elements, at each of the CTA sites. MON is
designed and built in order to deal with big data time series, and exploits
some of the currently most advanced technologies in the fields of databases and
Internet of Things (IoT). To dimension the bare metal hardware required by the
monitoring system (excluding the logging), we performed the test campaign that
is discussed in this paper. We discuss here the best set of parameters and the
optimized configuration to maximize the database data writing in terms of the
number of updated rows per second. We also demonstrate the feasibility of our
approach in the frame of the CTA requirements.