Polyserve Matrix Server - PowerPoint by cpb17381

VIEWS: 171 PAGES: 50

Polyserve Matrix Server document sample

More Info
									Oracle on Linux

Northwest Chicagoland Linux Users Group
at Harper College
July 2, 2002
Robert Stackowiak
Sr. Director, E-Business Intelligence
Enterprise Technology Center
Oracle Corporation
email: Robert.Stackowiak@oracle.com

   Brief Oracle background
   Oracle - Dell - Red Hat
   Oracle database on Linux
   Oracle Real Application Clusters
   Where to find more information
Oracle Corporation

   $11 Billion Revenue
   250,000 Customers
   145 Countries
   40,000+ Employees
Oracle9i Products

                     9i Database
                     9i Application Server
                     9i Developer Suite
   Key Development Focus Areas for

                         Internet Content
  Scalability &
                             B2C and B2B


 Security                  Intelligence
    Oracle9i Release 2
    New Features
 Oracle9iDB Release 2                     Oracle9iAS Release 2
    –   XML DB – Native XML                   –   Clustering – High availability
        database functionality                    and load balancing
    –   Cluster File System –
                                              –   Web Services Enabled –
        simplified cluster computing on
        Windows and Linux                         with support for SOAP 1.1,
                                                  WSDL 1.0, and UDDI 2.0
    –   Data Guard – Standby
        Database always available for         –   J2EE 1.3 support – the
        reporting, back-up, ad-hoc                fastest and most complete
        query                                     Java platform
    –   Complete and Integrated               –   Zero Planned Downtime –
        OLAP – scalable analytics                 complete online maintenance
        where the data lives
    –   Table Compression – cut
        data warehouse disk space
        requirements by 50%
Oracle9i Application Server
Oracle9iAS Release 2 New Features
HTTP Server                       Portal
   Integration: OC4J, OEM, SSO      New Builder                             Discoverer
   Proxy Plug-In                    New Component Portlets                     Portlets, Scheduling
   High Availability                 Integration: Wireless                      Aggregation enhancements
   Java Object Cache                Performance & Scalability                  Connection Management
   Diagnostic Logging                                                           Integration: Web Cache, Reports
OC4J                                 Push & SMS,
   J2EE 1.3                         PIM & Email
                                                                                 Pluggable Notifications, Engines &
                                                                                  Data Sources
   Stack Integration                SDK
   3rd Party: JMS, JDBC,            Advanced Customization
                                                                                 Event based publishing
                                                                                 Enhanced Bursting
                                  Web Cache                                      Integration: Portal
   Manageability
                                     Clustering, Partitioning                Personalization
Web Services                         Multiple Virtual Hosts                     Stack Integration
   J2EE/PLSQL                       XSLT Support
   WSDL Generation                  Validation-based caching
                                                                              Clickstream Intelligence
   UDDI, SOAP 2.0                   ESI Language & Portal Extensions           Brand New
   EAR file deployment           Oracle9i File System                        Internet Directory
   Stream Processing                Portlet                                    User Authentication via SSO, OID
BC4J                                 Integration: Wireless, Web Cache, OEM      Delegated and Self Admin
                                                                                 Single, central user definition
   9iDB Support                  InterConnect
   Web Services Support             Application & Technology Adapters       OEM
Forms                             Unified Messaging                              Lightweight HTML Admin UI
   Listener Servlet, SSO            SMPT Server & Authentication
                                                                                 User Administration
   Remote Debugging                 Voice Mail, SMS Notification
                                                                                 End-to-end 9iAS Admin & Monitoring
   Java Importer, Java API          Local Delivery Rules Engine
                                                                                 OC4J monitoring, deployment &
                                                                                 configuration
    Internationalization             Web Calendar, Resource Scheduler
  Oracle E-Business Suite

        Supply Chain

Procurement            Customers,
                       & Everything            Service

         HR                              Order
                  Financials          Management
  Oracle on Linux Recent Certifications

 Oracle9i release 2 RDBMS
 Oracle9iAS release 2
 Oracle 11i Applications 11.5.7

  All certified on:
    –   Red Hat 2.1 Advanced Server
    –   SuSE Linux Enterprise Server 7
  Oracle9i Database: Most Popular on Linux
                      Progress Other   Oracle9i      market to
             Informix   4.1%   1.4%                  grow from
                                                     $63.9 million
                                                     in 2001 to
      IBM                                            $5.1 billion by
     17.3%                                           2006,
                                                     IDC, eWeek

             Open Source
                                                  Editor’s Choice Award
                                                        April, 2002

Source: IDC, October 2001
Survey of Linux Developers
Which Application Server do you most commonly use?

             Linux Developer Survey Vol. 1, 2002,
                     Evans Data Corp.

             25                                     IBM
  Percent of 15                                     ColdFusion
 Programmers 10                                     Jrun
              0                                     Other
  Oracle – Dell – Red Hat

 “Dell has worked extensively with Oracle to
  deliver the first Oracle9i Database Certified
  Configuration running Red Hat Linux and the
  first Oracle clustering certification on Dell /
  EMC storage”
    –   Dell press release, 4/29/2002
 Oracle Direct Support
 June 5, 2002

 Oracle provides direct support for Red Hat
  Linux Advanced Server
   –   First and only operating system that Oracle
       supports directly
Typical Customer Quotes in the
 “(In the past,) no one could point to a version of
  Linux with Enterprise support…. With Oracle
  supporting it, that is a huge advantage.”
    –   David Brown, Sr. Emerging Technologies Architect,
        Vector SCM, eWeek 6/10/2002
 The Linux-on-Intel combination should give
  businesses a lower-cost alternative to running
  Oracle on Unix systems
    –   Bernard Havlik, IT director of Menasha Corp.,
        (InformationWeek, 6/10/2002).
  Typical Reactions by Analysts
 Gartner Group
    –   "None of the other databases Linux supports have the shared,
        concurrent scaling potential of Oracle9i RAC."
 Meta Group
    –   Senior Analyst Mark Shinman said: “…customers running
        Oracle9i Database on Red Hat Linux only have to work with one
        vendor to receive support, such as bug fixes and patches. This
        is actually giving some validity for Linux in the enterprise."
 Giga Information Group
    –   Analyst Stacey Quant said: "The potential price-performance
        with Oracle on Red Hat will be much more preferable over
Oracle Using Linux Extensively

 Oracle plans to deploy all Oracle9iAS used
  internally on Linux by the end of 2003.
   –   Larry Ellison, June 2002
    Oracle9i RDBMS Background
    Continuous Performance Innovation

   Cost-based optimizer (Oracle7)
   64-bit SMP and NUMA support (Oracle7)
   Static bit-map indexing (Oracle7)
   Parallel bit-mapped star joins (Oracle8)
   Materialized Views (Oracle8i)
   Real Application Clusters (Oracle9i)
   Dynamic run-time memory allocation (Oracle9i)
   OLAP Services (Oracle9i)
   ETL enablement features (Oracle9i)
Oracle9i RDBMS Background
Continuous Management Innovation

 Oracle Enterprise Manager (Oracle7)
 Oracle Parallel Server high availability (Oracle7)
 Range (Oracle8), Composite Partitioning (Oracle8i)
 Adaptive Degree of Parallelism (Oracle8i)
 Resource Manager: CPU (Oracle8i)
 List Partitioning (Oracle9i)
 Resource Manager: query governor, automatic queuing,
  reprioritization (Oracle9i)
 Memory allocation at query time (Oracle9i)
 Row level label security (Oracle9i)
 Table compression (Oracle9i)
    Oracle RDBMS on Linux Architecture
 Process based
     –   Background tasks include
         database writers, log writer,
         process monitors                               SGA
     –   Foreground tasks include
         incoming client connections
     –   Each process gets own memory
            8 TB of address space on
             64-bit systems              USER   DBWR SMON PMON RECO LGWR ARCH
 Linux filesystem (ext2) & raw file
 64-bit I/O support
     –   Maximum database file size 64
         GB                              Database                 Log Files
     –   Maximum database with 16KB       File(s)
         blocks is 4 petabytes
 Oracle & Red Hat Performance &
 Scalability Enhancements

 I/O Subsystem
   –   Asynchronous I/O in Linux kernel enabling
       thousands of simultaneous I/O requests with a
       single call
   –   Eliminated multiple copies of memory buffers
       while writing to disk
   –   Reduced contention for kernel locks
         Spin locks for fine-grained locking
 Oracle & Red Hat Performance &
 Scalability Enhancements

 Virtual Memory Subsystem
    –   Linux kernel capacity limits increased tenfold on Intel 32-
        bit platforms
           Red Hat Advanced Server 2.1 smp kernel supports 4
            GB RAM; enterprise kernel supports 64 GB RAM
           Enables larger SGA up to 62 GB, more data cached
    –   Configurable process mapped base and Page Table
        Entries (PTEs) in the highmem and bigpages features

 Future 64-bit Linux Support on Itanium 2
 Oracle & Red Hat Reliability &
 Manageability Enhancements

 Kernel “breakpoints” identified
    –   Enhancements to I/O, memory management, networking,
        process scheduling to improve stability under high loads
 Improved tools
    –   Oracle “lsraid” utility for RAID storage management
    –   Additional Red Hat crash dump analysis and bug
        resolution tools
    –   Future Cluster File System from Oracle
Linux Cluster Strategy
 Faster Software
    –   Run Database on Clusters of Linux Computers
 Faster Computer
    –   More Processors – 2x16 or 8x4
    –   Faster Processors – 4 @ 900 MHz
 Linux Operating System
    –   Red Hat Linux Advanced Server
 No Single Point of Failure
 Lowest Cost
Oracle9i Cluster Reliability
  No Single Point Of Failure
  More Reliable
 Clustered    Clustered      Clustered     Clustered
Web Caches   Web Servers   J2EE Servers    Database

 Linux        Linux         Linux          Linux
Oracle9iAS   Oracle9iAS    Oracle9iAS      Oracle9iDB
                                          Oracle9i RAC
No Single Point of Failure

 Real Application Clusters
    –   Exploits clusters for very high availability
    –   Overcomes the limitations of traditional failover
        solutions by providing:
          Concurrent processing
          Load Balancing
          Fast time to recovery
 No single point of failure
    –   Network, Storage
    –   CPU, OS
Real Application Clusters Manageability

   Single system Image
      –   Single Oracle Database
      –   One virtual system to configure and manage
      –   Single management console
   Cluster-wide monitoring and diagnostics
    Oracle9i RAC Cost Savings

   Groups of low cost computers
   Lower cost Linux
   Failover computer isn’t idle
   System availability 24 hours a day
    regardless of human presence
RAC Runs Real Applications
 Real Application Clustering is Real
    –   SAP Certification
    –   600 Customers
 Real Application Clustering is Economical
    –   Red Hat Linux
    –   Intel IA32 & IA64
 Real Application Clustering is Committed to Linux
    –   Major kernel enhancements to Red Hat Advanced Server
    –   Cluster File System contributed to Open Source
        Database Cluster Types
 Shared Disk                     Shared Nothing and Federated
  Runs Real Applications           – Limited Use
   – Oracle9iDB                      –   IBM DB2 UNIX & Windows
    –   IBM DB2 for Mainframes       –   Microsoft SQL Server

             All                     Data   Data   Data   Data
            Data                    Subset Subset Subset Subset
  Real Application Clusters

Centralized                  Network                      Users

                    Low Latency Interconnect   No Single
High Speed             VIA or Proprietary
Switch or
                                               Point Of Failure

Database Servers

Hub or
Switch                                           Storage Area Network
                                               Drive and Exploit
Mirrored Disk                                  Industry Advances in
Subsystem                                      Clustering
Out-of-the-Box Transparent
Application Scalability

 In the past clustered databases scaled well
  for specific types of applications
   –   Data Warehouse
   –   Parallel-enabled OLTP
 Oracle Real Application Clusters with Cache
  Fusion is a breakthrough in parallel
  database technology delivering transparent
  scalability to all types of applications
Oracle9i Cache Fusion Architecture

  Full Cache Fusion
     –   Cache-to-cache data
     –   Shared cache
         slow I/O
     –   Enhanced IPC
  Allows flexible
   and transparent
 Cache Fusion Manages
 Inter Instance Block Requests

 Readers and writers
  accessing instance A     Request     Lock Status
  gain access to blocks    for Block     Block in
  in instance B’s buffer   Cache A      Cache B
  cache                    Read         Read
 All types of block
  contention and access    Read         Write
 Coordination by Global   Write        Read
  Cache Service &          Write        Write
  Global Enqueue
 Benefits of Cache Fusion

                   Without Cache Fusion

(milli-                    With
seconds)                  Cache

             Block in      Block in      Block
           local cache   remote cache   on disk
FAA Command Center
Herndon, Virginia

 Operations data re-deployed to 12 Dell PowerEdge
  rack servers
 Oracle9i RAC
 Red Hat Linux

“Our goal is to try to minimize the different types of operating systems
  and vendors that we’re dealing with, and the Oracle9i Real
  Application Clusters Certified Configuration for Dell is allowing us
  to do that. The environment allows us a lot more flexibility in
  hardware and increased cost savings.”
        John Kelly, Project Manager, KENROB & Associates
 Total Cost of Ownership (TCO)

 TCO study comparing databases on a single
  RISC server vs. an Intel-based Linux cluster
   –   Includes hardware and software license prices
       (including typical discounts)
   –   Includes maintenance fees, support staff costs,
       cost of money
Hardware Pricing
 RISC based single server
      • 16-way Sun E6500
      • 8 Sun Sbus Fibre Channel Network HBAs
      • 2 EMC Clarrion FC4500 disk arrays (576 GB disk)
 Intel based with RAC
      • 8 Dell PowerEdge 1550 2-way Pentium III 1.13 GHz
        rack servers, 2 GB RAM each
      • 8 Qlogic Fibre Channel QLA2200f
      • 2 EMC Clarrion FC4500 disk arrays (576 GB disk)
Software Pricing
 For single Sun server, Oracle9i Enterprise
  Edition & Veritas
 For Dell - Linux cluster, Oracle9i Enterprise
  Edition with Real Application Clusters option,
  PolyServe Matrix Server
    –   See http://www.polyserve.com for more
        information on PolyServe cluster file system for
 Time of Purchase Costs

 With RAC, purchase servers as needed,
  reducing cost of capital
   –   Quantifiable cost-of capital benefit
   –   Unquantifiable benefit from increased capital
       and infrastructure flexibility
   –   Later purchase may benefit from Moore’s Law
 Human Support Costs

 Support costs grow as size of cluster grows
 Slightly higher rate for RISC system
  administrators and DBAs
       Total Cost of Ownership

                     Intel/Linux Matrix   RISC

Linux solution is 22.8% less expensive than RISC solution.
High Availability Benefits?

    Real Application Clusters provide a higher
     level of availability than a single machine
       –   Hot standby
       –   Rapid failover
Cost of Downtime
 Gartner Group estimates downtime costs
 Standby configuration delivers 99.9% uptime
 Cluster delivers 99.999% uptime
 8.5 hours more downtime with single
Cost of Preventing Downtime
 To match availability characteristics, add a
  standby database server for the RISC
   Total Cost of Ownership







                       Intel/Linux Matrix   RISC

Linux solution is 53.1% less expensive than RISC solution.
 Oracle recognizes potential of Linux
 Oracle customers recognize growing
  potential of Linux
 Oracle is forming partnerships to address
  support needs of enterprise customers
 Oracle R&D is
   –   Leveraging strong UNIX history
   –   Helping to grow the capabilities of Linux
Where to get more Information
 http://www.oracle.com
    –   Product Information

 http://otn.oracle.com
    –   Software downloads
    –   Technical papers
 A N S W E R S

To top