Speaker
Description
Belle II experiment at KEK, Japan, has been using RUCIO as a data management service, maintained at BNL for several years. It is currently the 2nd largest RUCIO service behind ATLAS experiment at CERN in terms of the number of files stored in its catalog. RUCIO service uses the relational database underneath to store information about data that manages. For the choice of the relational database, while ATLAS uses ORACLE, Belle II uses PostgreSQL. Although both databases have similar capabilities, they differ quite a bit in their operations of the services. Since RUCIO is developed at CERN, and since it has been used for experiments at CERN, their operational knowledge of using ORACLE as the backend relational database is well known and documented. On the other hand, for the other database, PostgreSQL, the information about its configuration and operational information for high performance RUCIO service is not as well documented. In this presentation, the experience of running PostgreSQL database for Belle II RUCIO at BNL will be presented. It will highlight certain operations and settings in PostgreSQL that will help administrators of RUCIO PostgreSQL services in a production environment.
