# Presentation: 634710

## BNL ATLAS Database service update

**Yuri Smirnov, Iris Wu**
**BNL, USA**
**LCG Database Deployment and Persistency Workshop, CERN, Geneva**
**October 17-19, 2005**

## Outline

- BNL Databases and servers for ATLAS production
- ATLAS MySQL servers and DBs at BNL Tier1
- Work on DataBase replication CERN-BNL
- Monitoring tools for MySQL servers: MySQLStat, Ganglia, BNL GridCat
- Oracle servers and Databases
- Resources
- Status of parcitipation in 3D testbed
- Plans and conclusions

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## BNL MySQL Servers/DBs for ATLAS production

- BNL Tier1 site constantly contributes to ATLAS Data Challanges and Production on the GRID (GRID3 and OSG now)
- Details about DC2 and Rome production in the talk of Sasha Vaniachine and David Malon
- Following BNL DB MySQL servers are used:
- dms01
- Xeon 2 CPU 3GHz, 2GB RAM, 250GB disk
- RHEL3, MySQL-4.0.23
- DBs: Globus RLS (both LRC and RLI), DQ1
- db1
- P-III 2 CPU 1GHz,  1GB RAM, 100GB disk
- RHEL3, MySQL-4.0.25
- DBs: Production VDC for Capone, Conitions DB (both IOV+payload), NOVA
- dbdevel1
- P-III 2 CPU 0.7GHz,  0.5GB RAM, 20GB disk
- RHEL3, MySQL-4.0.25
- Magda File Catalog, ATLASDD

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## ATLAS MySQL Database servers

- ATLAS MySQL servers at BNL
- dms01 ( RLS, DQ1 for GRID3 and OSG)
- dms02 ( DQ2, LFC  for OSG)
- db1 (ConditionsDB IOV+payload, GeometryDB NOVA, DBs for subdetectors LAr,TileCal,etc., production VDC, DialDB)
- dbdevel1 (ATLASDD, MagdaFC)
- dbdevel2 (TAG DB, PandaDB Archive)
- adbpro development mysql cluster (PandaDevDB)
-  gums  (GUMS DB for OSG and LCG)
-  vo (VOMS DB for OSG and LCG)

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## Database replication at BNL

- MySQL – MySQL replication:
- DataBases: Geometry DB NOVA, LAr subsystem DB
- collected the first experience CERN-BNL ATLAS DB replication
- procedure using both mysqldump and on-line replication
- thanks to Wensheng Deng and Sasha Vaniachine for participation
- Oracle – MySQL replication:
- DataBase: TAG DB.
- use case :  Oracle CERN to MySQL BNL (push)
- tool: Octopus replicator ( Java-based extraction, transfomation and loading)
- thanks to Julius Hrivnac and Kristo Karr for successful collaboration
- More details in Twiki: https://uimon.cern.ch/twiki/bin/view/Atlas/DatabaseReplication

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## MySQL servers monitoring

- We use different monitoring tools for MySQL servers:
- -MySQLStat (thanks to Jason Smith)
- -Ganglia
- -BNL GridCat  provides some info about  production servers for GRID3 (thanks to Dantong Yu)

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## MySQL servers monitoring

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## MySQL servers monitoring: GANGLIA

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## BNL Servers/DBs (Oracle, etc.)

- Oracle
- oracle01
- Xeon 2 CPU 3GHz, 2GB RAM, 200GB disk
- Operating system : RHEL3 Oracle 10g (10.1.0.4)
- DB: bnlsc3
- Used in Service Challenge 3 (SC3) as the backend Database of FTS (File Transfer Service)
- gridftp01
- Xeon 2 CPU 1GHz,  2GB RAM, 200GB disk
- Operating system: RHEL3 Oracle 10g (10.1.0.4)
- DB: bnlorcl
- Used for LCG 3D replication
- PostgreSQL
- Used by dCache system

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## Status of participation in 3D testbed

- Oracle database (10.1.0.4) is installed with requried patch set for streams replication
- Streams setup will start this week
- Oracle  Oracle streams replication
- ATLAS Databases and applications to work with
- COOL
- TAG (?)
-  Geometry DB (?)
- Others (?)
- Feedback
- Useful installation scripts and documents
- Thanks to Eva Dafonte for the help and participation

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005

## Plans and Conclusion

- BNL Tier1 is very interested in ATLAS GRID-based production, databases services support  and LCG applications validation
- Several new production servers (4-5 both MySQL and ORACLE)  will be installed and used soon (end of 2005). Configuration:
- Xeon 2 CPU 3GHz, 2GB RAM, 200GB disk
- Operating system : RHEL3

- Yuri Smirnov, Iris Wu (BNL)

- October 17, 2005