Distributed Database Operations Workshop

11 Nov 2008, 09:00 → 12 Nov 2008, 22:00 Europe/Zurich

160/1-009 (CERN)

Maria Girone (CERN)

EVO details EVO_Recurrent_Booking___Distributed_Database_Workshop.txt

Tuesday, 11 November

DB Deployment and Operation for CASTOR + SRM Services at WLCG Tier1s

1 Future CASTOR database developments

Speaker: Dr Giuseppe Lo Presti (CERN)

Slides CastorDev-DbOpsWorkshop.pdf CastorDev-DbOpsWorkshop.ppt

2 Review of Recent DB problems at Tier1s

Speaker: Gordon David Brown (Unknown)

Slides CERN_RAL_CASTOR_200811.pdf CERN_RAL_CASTOR_200811.pptx

3 DB set-up and configuration at Tier1s

Speaker: Mr Jason Shih (ASGC)

Slides ASGC_DB_Services.pdf ASGC_DB_Services.ppt

10:45 coffee break

4 Review of Tier1 DB Interventions and Service procedures

Speaker: Barbara Martelli (INFN CNAF)

Slides ReviewofTier1DBInterventions.pdf ReviewofTier1DBInterventions.pptx

12:30 lunch break

Distributed Database Operations - Hardware Requirements & Performance Review

5 Review of Experiments' Hardware Resource Requests at Tier0

Speaker: Maria Girone (CERN)

Slides CERNStatus_MG.pdf CERNStatus_MG.ppt

6 Review of Experiments' Hardware Resource Requests at Tier1s

Speaker: Gordon David Brown (Unknown)

Slides 3D_CERN_200811.pdf 3D_CERN_200811.ppt

7 ATLAS Reconstruction jobs

Speaker: Richard Hawkings (CERN)

Slides CondDbLCG3D_nov08.pdf CondDbLCG3D_nov08.ppt

8 ATLAS DB performance task force

Speaker: Alexandre Vaniachine (ATLAS)

Slides ADBPTF.pdf

15:30 coffee break

9 COOL Performance - Status and Outlook

Speaker: Dr Andrea Valassi (CERN)

Slides DBWS2008_20081111-COOL_Status.pdf DBWS2008_20081111-COOL_Status.pptx

10 Data Life Cycle Panel

Discuss requirements for data-archiving from Conditions, PVSS, SAM and other applications

Wednesday, 12 November

Database Administration, Monitoring and Configuration

11 RAC parameter configuration review

Speaker: Miguel Anjo (CERN)

Slides WLCG_RAC_parameters.pdf WLCG_RAC_parameters.pptx

12 RAC parameter tuning for remote access

Speaker: Carlos Gamboa (Brookhaven National Lab)

Slides opdwork_racparams_cfgbnl_lastlp.pdf opdwork_racparams_cfgbnl_lastlp.ppt

13 Streams Procedures Review

Speaker: Eva Dafonte Perez (Unknown)

Slides StreamsServiceReview_Nov2008.pdf StreamsServiceReview_Nov2008.ppt

14 AMI Plans

Speaker: Osman Aidel (Unknown)

Slides AMI_replication.ppt

10:45 coffee break

15 Database Monitoring for Tier1s

Speaker: Dawid Wojcik (CERN)

Slides Workshop_Mon_Tier1s.pdf Workshop_Mon_Tier1s.ppt

16 Backup, recovery and stand-by databases

Speaker: Jacek Wojcieszuk

Slides Efficient_data_protection_nov08_JW.pdf Efficient_data_protection_nov08_JW.ppt

12:55 Lunch break

Oracle RAC Internals & 11g New Features Review

17 Inside RAC

Speaker: Julian Dyke (UKOUG RAC SIG)

15:00 Coffee break

18 Closed discussion

More on 11g RAC and ASM features

19:30 social dinner