LCG Project - Deployment Area - Distributed Deployment of Databases

N
E
W

2005/10/17: LCG Database Deployment and Persistency Workshop October 17-19 at CERN2005/03/10: FNAL, CNAF, ASCC and RAL added to the 3D testbed2005/03/09-10: 3D meeting at CNAF (joint with meeting on SC3 preparation)2005/03/05: 3D wiki pages setup for testbed site communication
2005/03/04: FNAL connected to 3D testbed (CNAF, RAL, ASCC planned for next week)
2005/01/24: Database Workshop for LHC Offline/Online Developers (agenda)
2004/12/13: Distributed DB Deployment kickoff workshop 13-15 Dec@CERN
2004/11/10: received first requirement drafts from all experiments

General Information

LCG 3D Project Leader: Dirk Duellmann
PEB Project Proposal: [ppt] / [pdf] and minutes of that meeting with the project proposal.
Talks and Publications

3D general mailing list: project-lcg-peb-distributed-database-deployment@cern.ch [subscribe] [archive]
3D data inventory mailing list: project-lcg-peb-3d-data-inventory@cern.ch [archive]
3D T1/T2 service definition mailing list: project-lcg-peb-3d-service-definition@cern.ch [archive]

Meetings

3D regular meetings and minutes in the agenda system
3D meeting at FNAL 21-22 October (thanks to Lee for this page collecting the material)

Data Inventory and Application Requirements Working Group

Role of the participants in this working group
- Define a complete inventory of RDBMS data and applications foreseen by the experiment computing models or the deployment plans of the software projects
- Feed back to the software development process the proposed distribution model and insure that the model implications and requirements on the application software are taken into account
- Participation will at least initially require a significant fraction of time (>30%) to gather the experiment input and feedback and interface between 3d project and the application development on the experiment side
Experiment representatives:
- ATLAS : Alexandre Vaniachine, Jeff Tseng, Andrea Formica
- CMS : Michael Case, Zhen Xie, Nick Sinanis
- LHCb : Markus Frank , Pere Mato
Common s/w project representatives:
Draft Documents
- Template spreadsheet for the Data Type Requirements ([excel] and explanation document)
  to be filled by each experiment or project for all data that will use the LCG database services during first deployment in 2005.
Received requests for the initial service (one year from autumn 2005)
- ALICE : [11/03/05]
- ATLAS: [10/11/04] [online]
- CMS: [08/11/04] (online still missing)
- LHCb: [26/10/04]
- EGEE: (no service request submitted)
- LCG GD:[18/11/04]

Service Definition and Implementation Working Group

Role of the participants in this working group
- represent the service infrastructure of the particular site
- contribute to the definition of an common database and distribution service which is provided to worker node and grid service applications
T1 representatives (to be confirmed):
- ASCC: Meng-Hang Ho, Jeng-Hsueh Wu, Chi-Wei Wang, Min-Hong Tsai
- BNL: Razvan Popescu, Grace Tsai, Shigeki Misawa
- CCLRC-RAL: Andrew Sansum, Gordon Brown
- CERN: Maria Girone
- CNAF: Barbara Martelli, Elisabetta Vilucchi, Simone Dalla Fina
- FNAL: Lee Lueking, Julie Trumbo, Anil Kumar
- GridKa: Rainer Kupsch, Holger Marten
- IN2P3: Pierre-Etienne Macchi
Representatives of potential tier 2 sites(to be confirmed):
- ANL/U Chicago: Rob Gardner, Andrew Zahn

Technology Evaluation Tasks Working Group

Role of the participants in this work package

define an evaluation plan for a particular technology which is used to implement part of the 3d distribution infrastructure
setup a prototype system for the particular technology and compare the prototype performance with the requirements delivered by the data inventory work package

summarise the outcome of a evaluation in a short technology evaluation document

Evaluation Projects in Progress
Evaluation or Development Task	Status	Participants
Conditions DB conversion using perl scripting	finished [s/w] [report]	Silvia Eccher (CASPUR)
Oracle to Oracle streams based replication	started	Dirk Duellmann, Eva Dafonte Perez, FNAL
Oracle to MySQL bridge using streams based log extraction	started	Flavia Donno, Andrea Domenici Gianni Pucciani
ROOT security package integration	started	Gerardo Ganis, Kuba Zajaczkowski
FroNtier evaluation	started	Lee Lueking

Related technologies:
- The FroNTier system

3D Distributed Database Testbed

The 3D project is setting up a distributed database testbed together with the LCG Tier 1 and 2 sites. Detailed instructions for joining this testbed can be found in the following documents.
Testbed Streams Setup
Instructions for changing a database name

Please contact Eva Dafonte Perez about testbed issues.

Software Releases

None so far...

Project Tracking, Bugs and Tasks

Project Portal (bugs/tasks): Savannah bug tracker

Contact: Dirk Duellmann