Monitoring in CORAL

The CORAL software is widely used by the LHC experiments for storing and accessing data using relational database technologies. CORAL provides a C++ abstraction layer that supports data persistency for several backends and deployment models, including local access to SQLite files, direct client access to Oracle and MySQL servers, and read-only access to Oracle through the FroNTier/Squid and CoralServer/!CoralServerProxy server/cache systems.

Given the huge amount of operations executed by several CORAL clients at the same time on several database servers, it was crucial to develop a monitoring system with two main goals: first, to allow individual CORAL users to study and optimize the performance of the relational operations executed by their applications; second, to check whether the whole system is properly working and well configured. Client-level monitoring functionalities already existed in CORAL, but they have recently been reviewed and significantly improved, especially for the Oracle and Frontier plugins, and the same functionality are also being integrated into the CORAL server component (itself a CORAL-based application) and its client plugin. Work is in progress also on the monitoring of the CoralServerProxy components and on the aggregation of the monitoring information these proxies provide when deployed in a hierarchical structure, such as that used by the ATLAS High Level Trigger system. This presentation will report on the status of this work at the time of the CHEP2012 conference, covering the design and implementation of these new features and the results from the first experience with their use.

  • Track: Software Engineering, Data Stores and Databases
  • Co-authors: VALASSI, Andrea (CERN), KALKHOF, Alexander (CERN), LOTH, Alexander (CERN), TRENTADUE, Raffaello (CERN)
  • Presentation types: parallel or poster (none specified)


-- AndreaValassi - 03-Oct-2011

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2011-10-20 - AndreaValassi
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LCG All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback