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

09:00 → 13:10 Experiments and Database Operations

09:00 Welcome and Workshop Goals

Speaker: Dr Maria Girone (CERN)

Slides Goals.pdf Goals.pptx

09:15 LHC Start-up

Speaker: Dr Roger Bailey (CERN)

Slides LHCstartup.pdf LHCstartup.pptx

09:45 Experiment Database Strategy

10:45 Coffee break

11:00 ATLAS Frontier/Squid Status Update

Speaker: Dr Douglas Smith (STANFORD LINEAR ACCELERATOR CENTER)

Slides database_workshop_20091126.pdf

11:20 Coral Server Status

Speaker: Dr Andrea Valassi (CERN)

Slides DBWS_20091126_CoralServer_AV.pdf DBWS_20091126_CoralServer_AV.ppt

11:40 CERN Database Services for Physics: Status and Plans

Speaker: Maria Girone (CERN)

Slides CERNPhyDB.pdf CERNPhyDB.pptx

11:55 CASTOR+SRM DB@Tier0 Status and Plans

Speaker: Nilo Segura Chinchilla (CERN)

Slides CastorT0.pdf CastorT0.pptx

12:10 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 → 14:00 Lunch break

14:00 → 18:15 Tier0 and Tier1 Service Review

14:00 Recovery Exercise

Speaker: Jacek Wojcieszuk

Slides

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

14:30 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

15:45 Backup configuration best practices

Speaker: Jacek Wojcieszuk

Slides Backup_Configuration_Review.pdf Backup_Configuration_Review.pptx

16:15 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

16:35 ASGC Incident and Recovery report

Speaker: Mr Jason Shih (ASGC)

Slides ASGC_incident_report.pdf ASGC_incident_report.ppt

16:55 Analysis of the recovery exercise

Speaker: Jacek Wojcieszuk

19:00 → 21:30 Social Dinner

Friday 27 November

09:00 → 12:45 Database Administration, Monitoring and Configuration

09:00 Backup Management System Overview

Speaker: Przemyslaw Adam Radowiecki

Slides BakupManagementSystem.pdf BakupManagementSystem.ppt

09:20 Streams Service Review

Speaker: Eva Dafonte Perez (Unknown)

Slides StreamsServiceReview_CERN_27Nov.pdf StreamsServiceReview_CERN_27Nov.pptx

09:40 Database Monitoring

Speaker: Dawid Wojcik

Slides Monitoring_3D_2009.pdf Monitoring_3D_2009.ppt

10:10 Streams Monitoring Enhancements

Speaker: Zbigniew BARANOWSKI

Slides Streams_monitoring_enhancements.pptx

10:30 Site Survey: RAC Storage

Speaker: Mr Gordon Brown (STFC-RAL)

document SiteDBStorage.xls

10:40 Coffee break

10:50 Security Review

Speaker: Katarzyna Maria Dziedziniewicz (CERN)

Slides OracleSecurityReview.pdf OracleSecurityReview.ppt

11:10 Memory and process limit review (Tier1s Cond. DB for ATLAS)

Speaker: Gancho Dimitrov (DESY)

Slides Gancho_WLCG_Nov2009.pdf Gancho_WLCG_Nov2009.ppt

11:30 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

12:00 Analysis of the Recovery Exercise

Speaker: Jacek Wojcieszuk

Slides Recovery_exercise_wrapup.pdf Recovery_exercise_wrapup.pptx

12:45 → 14:00 Lunch break

14:00 → 17:30 Beyond 2010 Run: Oracle 11g New Features

14:00 RAC and ASM

Speaker: Dawid Wojcik

slides Oracle11g_New_Features.pdf Oracle11g_New_Features.ppt

14:30 Active Data Guard

Speaker: Svetozar Kapusta (CERN)

Slides DBworkshopKapustaADG.pdf DBworkshopKapustaADG.pptx

15:00 Coffee break

15:10 Streams New Features Review

Speakers: Eva Dafonte, Zbigniew BARANOWSKI

Slides Streams_new_features_in_11g.pptx

15:40 Advanced Compression

Speaker: Luca Canali

Slides Compression_Workshop_Nov09_LC.pdf Compression_Workshop_Nov09_LC.ppt

16:10 Workshop Wrap-up

Speaker: Maria Girone (CERN)

Slides Wrapup.pdf Wrapup.pptx