Oracle Services for Physics - High Availability and Performance

This page aggregates documentation, measurements and studies on the subject of performance, high availability and storage configuration developed at CERN Database Services for Physics. The reference platform is Oracle 10g RAC + ASM on Linux deployed on commodity HW.

Oracle 10g RAC production architecture

An overview of the Oracle architecture deployed at CERN Database Services for Physics. Oracle 10g features are leveraged to maximize scalability, availability, and performance/cost. A uniform deployment model is used to decrease manageability and provisioning costs.

• Architecture Description.pdf - Oracle 10g RAC and ASM architecture at CERN

Performance Tests and Measurements

I/O performance measurements for the current production setup are reported in the following documents:

• I/O Performance Measurements with RAC: Oracle 10g RAC and ASM on Linux - storage performance measured with Oracle's SQL

• I/O mesurements with Orion: I/O performance measurements using Oracle's ORION testing tool

• ASM_Internals: experiments and findings on ASM metadata internals, supersedes ASM_metadata_30012006.html

• PSS_quadcore_tests_April07.pdf: Test of a quad-core server for Oracle PDB services

Links

• presentations2007, presentations2006: Recent presentations on RAC and Physics DB Services at CERN