23-27 April 2012
J. Heyrovsky Institute of Physical Chemistry
Europe/Prague timezone

DB On Demand at CERN

23 Apr 2012, 14:30
20m
J. Heyrovsky Institute of Physical Chemistry

J. Heyrovsky Institute of Physical Chemistry

Dolejškova 2155/3, 182 23 Prague 8, Czech Republic
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.

Primary authors

Daniel Gomez Blanco (CERN) Dawid Wojcik (CERN) Ignacio Coterillo Coz (Consejo Superior de Investigaciones Cientificas (CSIC) (ES)) Ruben Domingo Gaspar Aparicio (CERN)

Presentation Materials