database services n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Database Services PowerPoint Presentation
Download Presentation
Database Services

Loading in 2 Seconds...

play fullscreen
1 / 16

Database Services - PowerPoint PPT Presentation


  • 114 Views
  • Uploaded on

Database Services. Richard Sinclair GridPP Tier1 Review 10 th May 2013. Agenda. Overview of Current Service Key Developments Current Issues Development Plans for 2013-14 Parting Thoughts New Team Leader. Service Overview. CASTOR 2 x 3 Node Oracle Clusters for Primary Databases

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Database Services' - laken


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
database services

Database Services

Richard Sinclair

GridPP Tier1 Review

10th May 2013

agenda
Agenda
  • Overview of Current Service
  • Key Developments
  • Current Issues
  • Development Plans for 2013-14
  • Parting Thoughts
  • New Team Leader
service overview
Service Overview
  • CASTOR
    • 2 x 3 Node Oracle Clusters for Primary Databases
    • Identical Setup for Standby Systems
    • 2 Node Pre-Production Oracle Cluster
    • Single Instance Certification Database
    • Single Instance Logging Database
service overview1
Service Overview
  • LFC and FTS
    • 3 Node Oracle Cluster
    • No Standby System
    • LFC for non-LHC Experiments
  • ATLAS 3D (Conditions)
    • 3 Node Oracle Cluster using Streams
  • Production Tier1 MySQL
    • Helpdesks, Accounting etc
service configuration
Service Configuration
  • All Databases Now Running Oracle 11.2.0.3
  • Monitoring via Internal Grid Control and Tier1 Production Team via Nagios
  • Standardised Infrastructure
service retirements
Service Retirements
  • LHCB Conditions and LFC Retired in October
    • At Request of LHCB
  • ATLAS Tags Database Retired in December
    • Low Usage, Unnecessary for ATLAS
key developments
Key Developments
  • Upgrade to 11gR2
    • No more reliance on outdated Oracle software
  • Changes to CASTOR Performance Tuning and Procedures
    • No database call outs in 2013
  • Improved Staff non-Oracle Skills
    • Greater push to use MySQL in future
  • New Oracle Licensing Agreement
    • No restrictions on scalability
  • Hardware Requirements for 2013 Established
current issues
Current Issues
  • Ageing Non-CASTOR Infrastructure
  • Delays in Hardware Deployments
  • Team Lead Departure and Recruitments
    • Contractor to fill skills shortfall in short term
    • 2 posts to be filled
  • Site Network Issues
    • Particular issue for LFC service
developments for 2013 14
Developments for 2013-14
  • Hardware Refresh for Non-CASTOR Systems
    • Requirements established, working on implementation planning
  • Replace Disk Sub-Systems (EMC Arrays)
  • Standby (Off Site) Systems for LFC, FTS
  • Run Production FTS3?
  • Plan for CASTOR Databases to 2019
  • Plan for Increased Use of MySQL (potentially for LFC, FTS)
parting thoughts
Parting Thoughts
  • Databases are reliable and fit for purpose
  • Key technical challenges have been met
  • Tier1 as a project functions well
  • Oracle dependencies are being broken (good thing)
  • Long term less reliance on DB Services from Tier1
new team leader
New Team Leader
  • John Casson
  • Asked by SCD management to be temporary team leader until a full time replacement is found
  • Leading the team and learning DBA skills on the job
  • Experience delivering production services
    • GOCDB, JISCMail, APEL
  • Experience as a database user + some DB administration
  • Keen to be closely involved in Tier 1 operations