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