Document details

A comparison of different database technologies for the CMS AsyncStageOut transfer database


Description

Made available in DSpace on 2022-04-28T19:07:11Z (GMT). No. of bitstreams: 0 Previous issue date: 2017-11-23

AsyncStageOut (ASO) is the component of the CMS distributed data analysis system (CRAB) that manages users transfers in a centrally controlled way using the File Transfer System (FTS3) at CERN. It addresses a major weakness of the previous, decentralized model, namely that the transfer of the user's output data to a single remote site was part of the job execution, resulting in inefficient use of job slots and an unacceptable failure rate. Currently ASO manages up to 600k files of various sizes per day from more than 500 users per month, spread over more than 100 sites. ASO uses a NoSQL database (CouchDB) as internal bookkeeping and as way to communicate with other CRAB components. Since ASO/CRAB were put in production in 2014, the number of transfers constantly increased up to a point where the pressure to the central CouchDB instance became critical, creating new challenges for the system scalability, performance, and monitoring. This forced a re-engineering of the ASO application to increase its scalability and lowering its operational effort. In this contribution we present a comparison of the performance of the current NoSQL implementation and a new SQL implementation, and how their different strengths and features influenced the design choices and operational experience. We also discuss other architectural changes introduced in the system to handle the increasing load and latency in delivering output to the user.

Universidade Estadual Paulista

California Institute of Technology

INFN Sezione di Trieste

INFN Sezione di Perugia

Fermi National Accelerator Laboratory

Vilnius University

University of Sofia St. Kliment Ohridski

CERN

CIEMAT

Universidade Estadual Paulista

Document Type Other
Language English
facebook logo  linkedin logo  twitter logo 
mendeley logo

Related documents

No related documents