HEPiX Spring 2012 Workshop

DB On Demand at CERN

Apr 23, 2012, 2:30 PM

20m

J. Heyrovsky Institute of Physical Chemistry

IT Infrastructure and Services IT Infrastructure

Speaker

Daniel Gomez Blanco (CERN)

Description

This presentation gives an introduction to the Database On Demand service at CERN. The need to offer support based on different database systems is on the rise within our user community. For example, one use case includes certain applications certified for running with non-Oracle databases (e.g. MySQL). Additional use cases are based on the desire expressed by user groups in being able to easily deploy and maintain different DBMS systems for their internal applications development. DB On Demand will cover this need offering users an easy way to create and manage their databases through a system that is fully integrated with different CERN technologies.

Summary

DB On Demand is a service which empowers users to create and manage database instances using a simple and intuitive web interface. Although MySQL is the only database system supported at present, the architecture has been designed to be flexible and we should be able to support other relational database systems in the future.

DB On Demand has been developed to provide, in a scalable way, database platform support for people who cannot use the Oracle relational database service. The DB On Demand service offers: full DBA privileges on a database running in a preconfigured virtual machine, configurable backups (with a possibility to send consistent full backups to tape), point-in-time recovery using binary logs, configuration management via Web interface, monitoring for instances, database upgrades to be installed by the user when it best suits them and support in case of hardware failure on the underlying virtualization platform.

Presentation materials

Slides

DBOnDemand@HEPiX.pdf

DB On Demand slides