This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Petya Vasileva

Wide-Range Database & Application Monitoring for the ATLAS Experiment at CERN


Petya Vasileva, CERN


 

Abstract

In High-Energy Physics (HEP) experiments at LHC (Large Hadron Collider) the database applications often become complex by reflecting the ever demanding requirements of the researchers. The ATLAS experiment has several Oracle DB clusters with over 216 database schemes each with its own set of database objects. To effectively monitor them, we designed a modern and portable application with exceptionally good characteristics. Some of them include: concise view of the most important DB metrics; top SQL statements based on CPU, executions, block reads, etc.; volume growth plots per schema and DB object type; database jobs section with signaling for problematic ones; in-depth analysis in case of contention on data or processes.This presentation describes also the technical aspects of the implementation. The project can be separated into two independent layers. The first layer consists in highly-optimized database objects hiding all complicated calculations and the Oracle REST Data Services (ORDS) provides the API for accessing the monitoring data. The second layer is an AngularJS Web interface, which allows the creation of reusable components, interactive charts and gives modern look and feel of the application. In addition, we will summarize the continuous integration cycle of the application, which uses GitLab-ci pipelines for basic testing, containerization and deployment on the CERN Openshift infrastructure.  

Speaker Biography

More details coming soon.