Performance of popular open source databases for HEP related computing problems

20th International Conference on Computing in High Energy and Nuclear Physics

物理学;计算机科学

Kovalskyi, D.^1 ; Sfiligoi, I.^1 ; Wuerthwein, F.^1 ; Yagil, A.^1

University of California, San Diego, United States^1

关键词: Job scheduling;    Open source database;    Open source database management system;    Scalable solution;    Software component;    Sub-optimal performance;    Test applications;    Workflow management systems;   

Others  :  https://iopscience.iop.org/article/10.1088/1742-6596/513/4/042027/pdf
DOI  :  10.1088/1742-6596/513/4/042027

学科分类：计算机科学（综合）

来源: IOP

【 摘 要 】

Databases are used in many software components of HEP computing, from monitoring and job scheduling to data storage and processing. It is not always clear at the beginning of a project if a problem can be handled by a single server, or if one needs to plan for a multi-server solution. Before a scalable solution is adopted, it helps to know how well it performs in a single server case to avoid situations when a multi-server solution is adopted mostly due to sub-optimal performance per node. This paper presents comparison benchmarks of popular open source database management systems. As a test application we use a user job monitoring system based on the Glidein workflow management system used in the CMS Collaboration.