1 / 13

BNL Database Services Update

BNL Database Services Update. Database Readiness Workshop CERN, Geneva, Switzerland Yingzi(Iris) Wu, Yuri Smirnov February 6, 2006. Outline. BNL Database Services Readiness of LCG production service. BNL Database Services. Oracle Database Service FTS 3D Project

dee
Download Presentation

BNL Database Services Update

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BNL Database Services Update Database Readiness Workshop CERN, Geneva, Switzerland Yingzi(Iris) Wu, Yuri Smirnov February 6, 2006

  2. Outline • BNL Database Services • Readiness of LCG production service Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  3. BNL Database Services • Oracle Database Service • FTS • 3D Project • MySQL database Service • PandaDB • PostgreSQL • dCache Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  4. Oracle service in production • Backend database for FTS • Hardware • Xeon 2 CPU 3GHz, 2GB RAM, 200GB disk • Operating system • RHEL3 • Oracle server/DB • Oracle 10g (10.1.0.4) • Backup tool • Recovery Manager (RMAN) Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  5. 3D Oracle streams test bed • Test bed for Oracle streams replication • Since Oct, 2005 • Hardware • Xeon 2 CPU 3GHz, 2GB RAM, 200GB disk • Operating system • RHEL3 • Orace server/DB • Oracle 10g (10.1.0.4) Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  6. Readiness of LCG production Service • Hardware readiness– middle Dec, 2005 • 300 GB hard disk ( after mirrored) • Fiber channel • Operating System • RHEL3 • Oracle server/DB – early Jan, 2006 • Oracle 10g release 2 • 2 nodes Cluster • ASMlib 2.0 as the storage management system Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  7. Plan • Application installation • Data replication from Tie0 to BNL via Oracle streams • Schedule ? Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  8. ATLAS MySQL clusters at BNL Tier1 • MySQL clusters • Production dbpro • 2 nodes Xeon 2CPU 3GHz, 2GB RAM, 250GB disk, RHEL-4 • MySQL 4.1.14 • supports USATLAS PandaDB (production and distributed analysis) • uses NDB-technology (“in-memory” MySQL DataBase tables implementation) • special cluster-based daily backup (using management server ndb_mgm) Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  9. Sample -Panda job error summary page Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  10. ATLAS MySQL clusters at BNL Tier1 • MySQL clusters • Development adbpro • 4 nodes PIII 0.7GHz, 0.5GB RAM, 25GB disk, RHEL-4 • MySQL 4.1.14 (plans to test 5.X) • supports development version PandaDevDB • uses NDB-engine • daily backup for cluster (ndb_mgm based) Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  11. ATLAS MySQL DataBase servers at BNL Tier1 • db1 supports production • ConditionsDB (IOV and payload), Geometry NOVA, DBs for subdetectors, VDC, DialDB, Terapaths DB • dbdevel1 • ATLASDD, MagdaFC • dbdevel2 • TAG DB (Oracle CERN replica), PandaArchiveDB • dms01 • RLS, DQ1 • dms02 • DQ2 DataBases and catalogs, LFC • gums • GUMS DB for OSG and LCG • vo • VOMS DB for OSG and LCG Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  12. Q & A Yingzi(Iris) Wu, Yuri Smirnov (BNL)

  13. Thank you ! Yingzi(Iris) Wu, Yuri Smirnov (BNL)

More Related