Distributed Database Operations Workshop

26 Nov 2009, 09:00 → 27 Nov 2009, 21:30 Europe/Zurich

IT Auditorium (CERN)

EVO details EVO_Booking___Distributed_Database_Operations_Workshop_from_Thu,_26_Nov_09_08_00_+0100_(CET).pdf

Thursday, 26 November

Experiments and Database Operations

1 Welcome and Workshop Goals

Speaker: Dr Maria Girone (CERN)

Slides Goals.pdf Goals.pptx

2 LHC Start-up

Speaker: Dr Roger Bailey (CERN)

Slides LHCstartup.pdf LHCstartup.pptx

3 Experiment Database Strategy

10:45 Coffee break

4 ATLAS Frontier/Squid Status Update

Speaker: Dr Douglas Smith (STANFORD LINEAR ACCELERATOR CENTER)

Slides database_workshop_20091126.pdf

5 Coral Server Status

Speaker: Dr Andrea Valassi (CERN)

Slides DBWS_20091126_CoralServer_AV.pdf DBWS_20091126_CoralServer_AV.ppt

6 CERN Database Services for Physics: Status and Plans

Speaker: Maria Girone (CERN)

Slides CERNPhyDB.pdf CERNPhyDB.pptx

7 CASTOR+SRM DB@Tier0 Status and Plans

Speaker: Nilo Segura Chinchilla (CERN)

Slides CastorT0.pdf CastorT0.pptx

8 Tier1s Status and Plans (3D and CASTOR)

Speaker: Site Representatives

Slides

• ASGC_Status_report.pdf
• ASGC_Status_report_v2.pdf
• ASGC_Status_report_v2.ppt
• BNL_STATUS_CERNOV2009.pdf
• BNL_STATUS_CERNOV2009.ppt
• IN2P3-CC.pdf
• IN2P3-CC.ppt
• NDGF_status_and_plans.pdf
• NDGF_status_and_plans.ppt
• Oracle_RAC_at_SARA_2009.pdf
• Oracle_RAC_at_SARA.pdf
• Oracle RAC @ SARA
• Oracle RAC @ SARA
• Oracle RAC @ SARA 2009
• PIC_review.pdf
• PIC_review.ppt
• RAL__Status_and_Plans.pdf
• RAL__Status_and_Plans.ppt
• TRIUMF_NOV262009.pdf

13:00 Lunch break

Tier0 and Tier1 Service Review

9 Recovery Exercise

Speaker: Jacek Wojcieszuk

Slides

• Recovery_exercise_Nov09.pdf
• Recovery_exercise_Nov09.pptx
• Recovery_exercise_November09.pdf

10 ASM Configuration Review and Set-up Example

Speaker: Luca Canali (CERN)

Slides ASM_review_workshop_Nov2009_LC.pdf ASM_review_workshop_Nov2009_LC.ppt

15:30 Coffee break

11 Backup configuration best practices

Speaker: Jacek Wojcieszuk

Slides Backup_Configuration_Review.pdf Backup_Configuration_Review.pptx

12 RAL data loss incident review

Speaker: Mr Gordon Brown (STFC-RAL)

Slides

• CERN_200911_RAL.pdf
• CERN_200911_RAL.ppt
• CERN_200911_RAL.ppt.pdf

13 ASGC Incident and Recovery report

Speaker: Mr Jason Shih (ASGC)

Slides ASGC_incident_report.pdf ASGC_incident_report.ppt

14 Analysis of the recovery exercise

Speaker: Jacek Wojcieszuk

19:00 Social Dinner

Friday, 27 November

Database Administration, Monitoring and Configuration

15 Backup Management System Overview

Speaker: Przemyslaw Adam Radowiecki

Slides BakupManagementSystem.pdf BakupManagementSystem.ppt

16 Streams Service Review

Speaker: Eva Dafonte Perez (Unknown)

Slides StreamsServiceReview_CERN_27Nov.pdf StreamsServiceReview_CERN_27Nov.pptx

17 Database Monitoring

Speaker: Dawid Wojcik

Slides Monitoring_3D_2009.pdf Monitoring_3D_2009.ppt

18 Streams Monitoring Enhancements

Speaker: Zbigniew BARANOWSKI

Slides Streams_monitoring_enhancements.pptx

19 Site Survey: RAC Storage

Speaker: Mr Gordon Brown (STFC-RAL)

document SiteDBStorage.xls

10:40 Coffee break

20 Security Review

Speaker: Katarzyna Maria Dziedziniewicz (CERN)

Slides OracleSecurityReview.pdf OracleSecurityReview.ppt

21 Memory and process limit review (Tier1s Cond. DB for ATLAS)

Speaker: Gancho Dimitrov (DESY)

Slides Gancho_WLCG_Nov2009.pdf Gancho_WLCG_Nov2009.ppt

22 Hardware Migration using Data Guard

Speakers: Carlos Gamboa, Carmine Cioffi, Jon Westgaard

slides BNL_migration_CERNOV2009.ppt

Slides

• NDGF_Hardware_Migration_using_DataGuard.pdf
• NDGF_Hardware_Migration_using_DataGuard.ppt
• RAL_Dataguard_for_Harware_migration.pdf
• RAL_Dataguard_for_Harware_migration.ppt

23 Analysis of the Recovery Exercise

Speaker: Jacek Wojcieszuk

Slides Recovery_exercise_wrapup.pdf Recovery_exercise_wrapup.pptx

12:45 Lunch break

Beyond 2010 Run: Oracle 11g New Features

24 RAC and ASM

Speaker: Dawid Wojcik

slides Oracle11g_New_Features.pdf Oracle11g_New_Features.ppt

25 Active Data Guard

Speaker: Svetozar Kapusta (CERN)

Slides DBworkshopKapustaADG.pdf DBworkshopKapustaADG.pptx

15:00 Coffee break

26 Streams New Features Review

Speakers: Eva Dafonte, Zbigniew BARANOWSKI

Slides Streams_new_features_in_11g.pptx

27 Advanced Compression

Speaker: Luca Canali

Slides Compression_Workshop_Nov09_LC.pdf Compression_Workshop_Nov09_LC.ppt

28 Workshop Wrap-up

Speaker: Maria Girone (CERN)

Slides Wrapup.pdf Wrapup.pptx