CERN 的 MySQL 社区版.pdf

1、MySQL Community Edition at CERNAbel Cabezas Alonso 1st May 2024Abel Cabezas Alonso|MySQL Community Edition CERNAbel Cabezas Alonso Database Engineer at CERN since 2019 Transition as DevOps engineer Early career as Software Developer1st May 20242Abel Cabezas Alonso abel.cabezas.alonsocern.chAbel Cabe

2、zas Alonso|MySQL Community Edition CERNEstablished in 1954 23 Member states Our mission:Unveil how the universe works and what it is made of Provide a unique range of particle accelerator facilities to enable research at the forefront of the human knowledge Unite people from all over the world to pu

3、sh the frontiers of science and technology1st May 20243Abel Cabezas Alonso|MySQL Community Edition CERNThe Large Hadron Collider1st May 20244Worlds largest particle accelerator 27 km(16.8 miles)ring of superconducting magnetsMagnets are cooled to-271.3C(-456.34F)a temperature colder than outer space

4、Particles circle the accelerator 11.245 times/s reaching 99.9999991%the speed of lightLead ion collisions create temperatures of 100 000 x hotter than the heart of the sunAbel Cabezas Alonso|MySQL Community Edition CERNThe Worldwide LHC Computing Grid(WLCG)Tier0:Data reconstruction+Tape archival+dat

5、a distribution to other tiers 200 PB of data per year1st May 202451 PB of data per second Only 1%is kept(events with specific characteristics)WLCG:-170 collaborating centers -36 countries-Data analysis Abel Cabezas Alonso|MySQL Community Edition CERNOracle databases since 1982 105 Oracle databases M

6、ore than 11.800 Oracle accounts RAC,Active DataGuard,OEM,RMAN Complex environment Used by Administrative Information Services Engineering teams Accelerator and experiments etc.Full DBA support 5PB of data Databases at CERN:Oracle1st May 20246Abel Cabezas Alonso|MySQL Community Edition CERNDatabase O