1 / 16

Oracle Database 11g:  First Experiences with Grid Computing

Oracle Database 11g:  First Experiences with Grid Computing. Plamen Zyumbyulev Head of DBAs Mobiltel. Mobiltel (M-Tel). M-Tel is the market leader in Bulgaria and one of the most successful mobile operators in Europe More than 4.8 M subscribers Founded in March 1994

deidra
Download Presentation

Oracle Database 11g:  First Experiences with Grid Computing

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. Oracle Database 11g:  First Experiences with Grid Computing Plamen Zyumbyulev Head of DBAs Mobiltel

  2. Mobiltel (M-Tel) • M-Tel is the market leader in Bulgaria and one of the most successful mobile operators in Europe • More than 4.8 M subscribers • Founded in March 1994 • Part of Mobilcom Austria Group • M-Tel became the world fifth to offer HSDPA services

  3. The IT reality • IT becomes more and more complicated • New roles and tasks • Hundreds of systems • Increased system dependencies and integration • Lot’s of new systems • Constant changes / Increased Risk • Everything is important and 24/7 • Increased demand for reliability, availability, performance, etc. • Islands of Computation • Limited scalability, no resource sharing • Must be configured for peak loads • Single point of failure • Slow to adjust to business needs

  4. Challenges • Provide Highest Quality of Service • implement new technologies • decrease the risk • Be more flexible • online changes, virtualization, dynamic provisioning • How to do more with less • automation, consolidation, monitoring

  5. CRM Application Custom Application Data Warehouse ERP Application Why Grid? Technical Benefits • Dynamically configurable infrastructure • Effective (automatic) workload management • No single point of failure • Incremental scaling • Centralised automated monitoring & management Better Quality of Service Fast response to changes Effectiveness Service Oriented Applications Mid-Tier Management Database Tier Storage

  6. Why Grid Computing with Oracle 11g • HA and DR • Real Application Clusters (RAC) • DR with real time query • Service Oriented Architecture • Resource Management • Automation and simplification • Oracle Enterprise Manager Grid/DB Control • Automatic Diagnostic Workflow. Incident Packaging Service • Online Maintenance • Change assurance • Database Replay • SQL Plan Management • Snapshot standby

  7. Grid Configuration • Hardware • 6+1 Nodes, HP BladeSystem c-Class, 2 CPU dual Core 3.2 GHz, 10GB RAM • RedHat Enterprice Linux 4 • Oracle Stack • Oracle Database 11.1.0.5 • Oracle RAC 11.1.0.5 • Oracle Clusterware 11.1.0.5 • Oracle Automatic Storage Management 11.1.0.5 • Storage • IBM DS6800 – 28 disks

  8. Big RAC environment Consolidate many Business Systems into small number of databases Single database – this is not mandatory It is possible to have different DB versions Many services per Business System – OLTP, Batch, Read Only, Test, etc. Every system/service is separate from the others Separate tablespaces Guaranteed resources – Memory, CPU, I/O, etc Our GRID implementation

  9. Many features are configured out of the box High availability Backup Disaster recovery Force logging can be enabled per tablespace Reporting instance Test System Extremely fast provisioning of new systems, System Cloning, Creation of Test Systems Services can span databases * Oracle EM 10g Grid Control can monitor 11g GRID Our GRID Implementation …

  10. BS 1 Our GRID Architecture Business systems BS 6 BS 7 BS 4 BS 5 BS 3 BS 2 SOA DR with real time query – no idle resources Resource Manager Continuous Redo Shipment and Apply Single Database – Not mandatory Open in Read Only One or more DBs

  11. BS 1 Replay Driver Fast Test System Creation Business systems BS 6 BS 7 BS 4 BS 5 BS 3 BS 2 SOA Resource Manager Process Capture Workload Single Database – Not mandatory Open in Read/Write One or more DBs

  12. Resource Management Rules to automatically assign sessions to Consumer Groups

  13. Service allocation (DG in RO mode) A – available; P – preferred; D – disabled; DG – data guard; RO – Read Only; * - implemented with tns; ** - different schema

  14. Service allocation (DG in RW mode) A – available; P – preferred; D – disabled; DG – data guard; RO – Read Only; * - implemented with tns; ** - different schema

  15. A Paradigm shift We cannot solve our problems with the same thinking we used when we created them. Albert Einstein • Start small • Test systems • Development systems • Temporary/Permanent storage for data from other systems. (ex. 1GB in Billing System means ~ 15GB storage) • Non critical production systems • Create “Atmosphere”. Fight Ignorance and Status quo • Build expertise, confidence and habits

  16. The Results • Availability 100% • Lot’s of changes, reconfigurations and experiments • Lot’s of problems, bugs, human errors • No unplanned downtime since the beginning - May 2007 • GRID is in the production since July 2007 • Oracle Database 11g 32bit beta 5 for Linux • There is a big list of new important systems waiting for Linux 64 bit production release • Mobiltel gained a lot of experience and confidence with Oracle 11g GRID computing

More Related