Issue: MySQL Services for SC4

Within IT at CERN, the database of choice is Oracle. This is a supported service which is staffed by an experienced team of database administrators with appropriate infrastructure and procedures.

However, there are some Grid applications which only support MySQL. While there may be development plans to support Oracle in the future, these will not be available before the code freeze for SC4 (and may not even be ready for LHC production).

The current list of MySQL-only applications are

  • Resource Broker
  • R-GMA
  • Archiver
  • Site Functional Tester

The Resource Broker service is defined as Critical in the SC4 service definition. The others are classified as Medium.

For the critical services, the following functions need to be in place

  • Administrator on-call 24/24
  • Automated monitoring of the database with alerts to operator
  • Automated and online backup with tested restore procedures
  • Working Instructions for the administrators and operators on starting/stopping/diagnosing databases and their associated applications
  • Recovery in the event of failed components

The delivery of reliable Grid application services will be dependent on a reliable database service that provides the above functions.

Date Who Description
16/09/2005 Tim Discussed with Bernd Panzer. Submitted issue description

TimBell - 16 Sep 2005
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2005-11-10 - TimBell
    • 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