1 / 13

CD Databases & Systems

CD Databases & Systems. Services & Lessons Learned Btev Workshop June 23, 2004 Updated July 2005 J.Trumbo Core Support Services, Database Systems Group CSS-DSG. System Administration for Database Servers Hardware planning and support. Do NOT under estimate your hardware needs!

orlando-navaez
Download Presentation

CD Databases & Systems

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. CD Databases & Systems Services & Lessons Learned Btev Workshop June 23, 2004 Updated July 2005 J.Trumbo Core Support Services, Database Systems Group CSS-DSG

  2. System Administration for Database Servers Hardware planning and support. Do NOT under estimate your hardware needs! Support model is a development, an integration and a production database instance for each application. Normally 2 machines, 1 machine housing dev, the other prod. Integration can sit on either machine, and will need to be sized to house a copy of production. OverviewSystem Administration

  3. System Administration • Capacity Planning • Backup & Recovery • Sun & Linux support in certified configurations • Monitoring • 24x7 support for mission critical systems • Security patches and general maintenance

  4. OverviewDatabase Support • Oracle • Freeware Databases • Postgres • Mysql • MS Sql (SDSS) • General Consultant Support

  5. Oracle & MS Sql • Oracle for mission critical databases • Oracle provides 24x7 technical support • Patches for upgrade and security • Oracle ‘Streams’ is our Replication Product • MS Sql is used exclusively for Sloan Digital Sky Survey.

  6. Freeware • Postgres and Mysql are supported by DSG. • New versions in kits, actively assisting users with questions, upgrades, testing, etc. for freeware products. • To date, no 3rd party vendor support, thus, email support only. • Currently, no mission critical uses • Lack of database constraints in Mysql lay question to Mysql’s candidacy for mission critical applications. Imho, read only database only.

  7. Freeware • DSG is ramping up dba expertise on freeware as opportunity arises. • Reference url: http://www-css.fnal.gov/dsg/external/freeware • Repeat, for mission critical, 24x7 databases, there is no vendor support for freeware databases. If there is a problem your database may be down for an unpredictable or extended period of time.

  8. Database Support • Design Consulting & Data Modeling • What are my requirements? Requirements need to be written before data modeling can begin. • What have others done? Can this be reused? • When does this database need to be in production? • Choice of application architecture can impact long term database support needs. For example, a 3 tiered solution will allow more autonomy between the app and the dbas as far as synchronizing modifications.

  9. Database Support Cont. • INVEST TIME IN PROPER, NORMALIZED DATA MODELING UP FRONT! Redesigning after an application is in production is costly and time consuming. • Database design via entity relationship diagrams • Design Reviews with stakeholders and dbas. • Long term database support with ‘mou’, memorandum of understanding or ‘sla’ a service level agreement.

  10. Database Support Cont. • Which database will meet my requirements? • What is the potential size? • How will it be backed up? • What will the activity level require? Users & backups have impact. • What will the support level require? • DSG Standards and procedures • http://www-css.fnal.gov/dsg/external/oracle_admin/run2_standards.html • http://www-css.fnal.gov/dsg/external/oracle_admin/24x7_run_procedures_draft.htm • http://www-css.fnal.gov/dsg/external/workshops/index.htm

  11. Database Support Cont. • Long Term Support includes (mou or sla): • Patches and upgrades • Space allocation & planning support • Monitoring • Backup and recovery (extremely important, varies by database chosen, may strongly influence which database to use) • Replication needs • Excludes hardware purchases

  12. Man Power & Support 3 Sysadmins – support 4 Dbas – support 5 24x7 mission critical databases, as well as a many others. Currently supported experiments & infrastructure • Cms • D0 (3 tier application arch. lessens dba support issues) • Cdf (replication requires 1 dba fte for support) • Minos • Miscomp • CAD • SDSS (Sloan Digital Sky Survey)

  13. DSG & BTEV Please refer to http://www-css.fnal.gov/dsg/external/BTeV/index.html for plans, projects and other past btev presentations and planning for databases. There is good background here! Success depends on a highly communicative environment, working together as a team and planning for the future.

More Related