Exadata Database Machine Morana Kobal Butkovic Senior Sales Consultant Oracle Hrvatska - PowerPoint PPT Presentation

Loading...

PPT – Exadata Database Machine Morana Kobal Butkovic Senior Sales Consultant Oracle Hrvatska PowerPoint presentation | free to download - id: 4b766e-YzUzN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Exadata Database Machine Morana Kobal Butkovic Senior Sales Consultant Oracle Hrvatska

Description:

Morana Kobal Butkovi Senior Sales Consultant Oracle Hrvatska * * * Others argue that a specialized hardware or software platform is needed for each application or ... – PowerPoint PPT presentation

Number of Views:108
Avg rating:3.0/5.0
Slides: 36
Provided by: combisHra
Learn more at: http://www.combis.hr
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Exadata Database Machine Morana Kobal Butkovic Senior Sales Consultant Oracle Hrvatska


1
Exadata Database MachineMorana Kobal
ButkovicSenior Sales ConsultantOracle Hrvatska
2
Exadata Goals
  • Ideal Oracle Database Platform
  • Best Machine for Data Warehousing
  • Best Machine for OLTP
  • Best Machine for Database Consolidation
  • Unique Architecture Makes it
  • Fast and cost efficient

3
Exadata in the Marketplace
  • Launched in Fall 2008
  • Seeing rapid adoption in all geographies and
    industries

4
Agenda
  • Hardware Architecture
  • Key Technologies
  • Consolidation Protection

5
The ProductsExadata Storage Server Database
Machine
  • Exadata Storage Server
  • Storage Product Optimized for Oracle Database
  • Extreme I/O and SQL Processing performance
  • Combination of hardware and software
  • Exadata Storage Server Software
  • Exadata Database Machine
  • Pre-Configured High Performance
  • Balanced performance configuration
  • Takes the guess work out of building an Oracle
    deployment
  • Exadata Storage Server Software
  • Oracle Database 11.2

6
Exadata Storage Server Building Block
  • Hardware by Sun
  • Software by Oracle
  • Uses high performance components
  • 12 disks - 600 GB 15K RPM SAS 2.0,
    or 2TB 7200 RPM SATA
  • 2 Xeon quad-core processors with PCI 2.0
  • Dual ported 40 Gb/sec InfiniBand
  • 4 96 GB PCI Flash Cards
  • Runs at full disk and flash bandwidth

7
Exadata Hardware Architecture
  • Scalable Grid of industry standard servers for
    Compute and Storage
  • Eliminates long-standing tradeoff between
    Scalability, Availability, Cost

Database Grid
Storage Grid
  • 8 compute servers (1U)
  • 64 Intel cores
  • 14 storage servers (2U)
  • 112 Intel cores in storage
  • 100 TB SAS disk, or336 TB SATA disk
  • 5 TB PCI Flash
  • Data mirrored across storage servers

InfiniBand Network
  • Redundant 40Gb/s switches
  • Unified server storage net

8
Database Server Hardware
Dual-redundant, hot-swappable power supplies
72 GB DRAM (18 x 4GB)
4 x 2.5 146GB Disk Drives
2 Quad-Core Intel Xeon E5540 Processors
  • Installed Software
  • Oracle Enterprise Linux
  • Oracle Database 11.2 Software
  • Drivers

9
Start Small and GrowField Upgradeable
Full Rack
Half Rack
Quarter Rack
Balanced Incremental Scaling for OLTP and DW
10
Scales to 8 Racks by Just Adding CablesFull
Bandwidth and Redundancy
11
Exadata Database MachineProduct Family
Quarter Rack Half Rack Full Rack 2-8 Full Racks
Database Servers 2 4 8 16-64
Exadata Storage Servers 3 7 14 28-112
Total Disk Capacity SAS 21 TB 50 TB 100 TB 200 800TB
Total Disk Capacity SATA 70 TB 168 TB 336 TB 336 2688TB
User Data (uncompressed SAS) 6 TB 14 TB 28 TB 56 224 TB
I/O Throughput (disks SAS) 4.5 GB/sec 10.5 GB/sec 21 GB/sec 42 - 168 GB/sec
I/O Throughput (flash) 11 GB/sec 25 GB/sec 50 GB/sec 100 - 400 GB/sec
Flash IOPS 225,000 500,000 1,000,000 1M 8M
Racks 1 1 1 2-8
12
Standardized and Simple to Deploy
  • All Database Machines are the same
  • Delivered Tested and Ready-to-Run
  • Highly Optimized
  • Highly Supportable
  • No unique configuration issues
  • Identical to config used by Oracle Engineering
  • Runs existing OLTP and DW applications
  • Full 30 years of Oracle DB capabilities
  • No Exadata certification required
  • Leverages Oracle ecosystem
  • Skills, knowledge base, people, partners

Ready- to-Run
Deploy in Days, Not Months
13
Agenda
  • Hardware Architecture
  • Key Technologies
  • Consolidation Protection

14
Keys to Speed and Cost Advantage
15
Exadata Intelligent Storage GridMost Scalable
Data Processing
  • Data Intensive processing runs in Exadata Storage
    Grid
  • Filter rows and columns as data streams from
    disks
  • Example How much product X sold last quarter
  • Exadata Storage Reads 10TB from disk
  • Exadata Storage Filters rows by Product Date
  • Sends 100GB of matching data to DB Servers
  • Scale-out storage parallelizes execution and
    removes bottlenecks

16
Simple Query Example
What were my sales yesterday?
Exadata Storage Grid
Optimizer Chooses Partitions to Access
Oracle Database Grid
Scan compressed blocks in partitions Retrieve
sales amounts forSept 24
Select sum(sales) where Date24-Sept
SUM
10 TB scanned 100 GB returned to servers
17
Exadata Intelligent Storage
  • Exadata storage servers also run more complex
    operations in storage
  • Join filtering
  • Incremental backup filtering
  • I/O prioritization
  • Storage Indexing
  • Database level security
  • Offloaded scans on encrypted data
  • Data Mining Model Scoring
  • Smart File Creation
  • 10x reduction in data sent to DB servers is
    common

18
Exadata is Smart Storage
  • Storage Server is smart storage, not a DB node
  • Storage remains an independent tier
  • Database Servers
  • Perform complex database processing such as
    joins, aggregation, etc.
  • Exadata Storage Servers
  • Search tables and indexes filtering out data that
    is not relevant to a query
  • Cells serve data to multiple databases enabling
    OLTP and consolidation
  • Simplicity, and robustness of storage appliance

Compute and Memory Intensive Processing
Data IntensiveProcessing
19
Exadata Hybrid Columnar Compression
  • Data is organized and compressed by column
  • Dramatically better compression
  • Speed Optimized Query Mode for Data Warehousing
  • 10X compression typical
  • Runs faster because of Exadata offload!
  • Space Optimized Archival Mode for infrequently
    accessed data
  • 15X to 50X compression typical

Query
Faster and Simpler Backup, DR, Caching, Reorg,
Clone
Benefits Multiply
20
Exadata Hybrid Columnar CompressionHow it works
Compression Unit
  • Tables are organized into sets of a few thousand
    rows
  • Compression Units (CUs)
  • Within CU, data is organized by column, then
    compressed
  • Column organization brings similar values close
    together, enhancing compression
  • Useful for data that is bulk loaded and queried
  • Update activity is light
  • Exadata servers offload filtering, projection,
    etc. for scans on compressed data
  • Return compressed blocks to database so buffer
    cache benefits from compression

Column 2
Column 3
Column 1
Reduces Table Size 4x to 40x
4x to 50x Reduction
21
Compression Ratio of Real-World Data
  • Compression Ratio varies by customer and table
  • Trials were run on largest table at 10 large
    companies
  • Average Query Compression ratio was 13x
  • On top of Oracles already highly efficient format

22
Hybrid Columnar Comparisons
Uncompressed
Uncompressed
Pure Columnar Cliff
OLTP Compress
OLTP
Hybrid
Hybrid
Pure Column
Pure Column
Table Size
Scan Time
Row Lookup Time
  • Exadata Hybrid Columnar Compression is a second
    generation columnar technology combining the best
    of row and column formats
  • Best compression matching full columnar
  • Excellent scan time Compression provides 10x
    speedup
  • After 10x I/O reduction, most queries become CPU
    bound
  • Good single row lookup no full columnar cliff

23
Exadata Smart Flash CacheBreaks the Disk Random
I/O Bottleneck
  • Trade-off between traditional disks drives and
    Flash
  • Disk drives are cheap, high capacity but low I/Os
    per second
  • Flash is expensive, lower capacity but can
    support tens of thousands of I/Os per second
  • Ideal Solution - Exadata Smart Flash Cache
  • Keep most data on disk for low cost
  • Transparently move hot data to flash
  • Use flash cards instead of flash disks to avoid
    disk controller limitations
  • Flash cards in Exadata storage
  • High bandwidth, low latency interconnect

300 I/O per Sec
Tens of Thousands of I/Os per Second
24
Sun FlashFire in Exadata Sun Flash Accelerator
F20 PCIe Card
  • Cell cache on the storage cells
  • Write-though cache, transparently used to
    accelerate reads
  • 4 x Cards (384GB/cell) used to create a cache on
    the cell
  • Database Machine has 5 TB of flash storage
  • Able to pull 3.6GB/sec total bandwidth from each
    storage cell, for Full Rack
  • 50GB/sec total from flash
  • 21GB/sec from SAS disk, 12Gb/sec SATA disk
  • Up to 50,000 Disk IOPS SAS or Up to 20,000 Disk
    IOPS SATA
  • Up to 1,000,000 Flash IOPS

25
Exadata Smart Flash Cache
  • Performance
  • Use PCIe cards instead of SSDs to avoid slow disk
    interface
  • Capacity
  • Efficient Compression increases effective
    performance and capacity by up to 10X
  • Smart Caching
  • Caches data intelligently to maximize Flash usage
    for frequently read data
  • Automatically skips caching of infrequently read
    objects or avoid caching data that will not fit
    in the cache
  • Database awareness enables caching only data
    likely to be accessed again
  • User can further optimize caching policies by
    specifying whether or not to cache specific
    database objects

26
Exadata is Architected for Flash
  • Traditional storage arrays now offer optional
    flash disks

Exadata Flash Architecture
Scale-Out Storage No bottlenecks to scaling flash I/O
InfiniBand Highest throughput, lowest latency
Intelligent Storage Key to using full flash bandwidth Even InfiniBand cant send 50GB/sec
PCI Flash Avoids disk controller bottlenecks. Cards in storage enable HA, RAC
Compression Multiply flash capacity 10x Also multiplies data scan rates
Flash Cache Speed of flash, cost of disk Optionally specify table placement
27
Exadata Storage IndexTransparent I/O Elimination
with No Overhead
Table
Index
  • Exadata Storage Indexes maintain summary
    information about table data in memory
  • Store MIN and MAX values of columns
  • Typically one index entry for every MB of disk
  • Eliminates disk I/Os if MIN and MAX can never
    match where clause of a query
  • Completely automatic and transparent

A B C D
1
3
5
5
8
3
Min B 1 Max B 5
Min B 3 Max B 8
Select from Table where Blt2 - Only first
set of rows can match
28
Benefits MultiplyExample
100 GB with partition pruning
1 TB with 10x compression
10 TB of user data Normally 10 TB of IO
Seconds On Exadata
50 GB with Storage Indexes
Scan 50GB in Flash 10 GB returned after Exadata
Filtering
Data is 10x Smaller, Scan is 2000x faster
29
Agenda
  • Hardware Architecture
  • Key Technologies
  • Consolidation Protection

30
Unified Hardware, Specialized Software
  • Exadata enables a single hardware architecture
    for all database needs
  • Massively parallel hardware, InfiniBand, Flash
    for all DB applications and workloads
  • Enables Strategic building block approach to IT
  • Domain specialization is in software, not
    hardware
  • Analytics
  • OLAP, Statistics, Spatial, Data Mining, etc.
  • Warehousing
  • Flexible Partitioning, Bitmap Indexing, Join
    indexing, Materialized Views, Result Cache
  • Data
  • Relational, XML, Objects, Secure Files
  • OLTP, Security, HA

31
Platform for Database Consolidation
  • Consolidation is key to reducing costs
  • Administration, hardware, software, data center
  • Many databases can be consolidated on Exadata
  • Multiple small databases within a node
  • Large databases can span nodes using RAC
  • Exadata serves as farm/cloud for databases
  • Exadata delivers performance for complex
    workloads that mix OLTP and DW
  • Complex OLTP with batch and reporting
  • Complex Warehousing with thousands of users
  • Multiple databases running different applications

32
Consolidate Database Storage
  • Exadata and ASM allow all storage servers to be
    shared across databases
  • Shared Configuration
  • Advanced ASM data striping spreads every database
    across all storage servers
  • Eliminates hot-spots and captive unused space
  • Full storage grid performance available to all
    databases
  • Predictable Performance
  • Exadata I/O resource manager prioritizes I/Os to
    ensure predictable performance
  • At user, job, application, or database level
  • No need for isolated storage islands

33
Consolidate Database Servers
  • Many databases can run on Database Machine
    servers
  • Shared Configuration
  • Applications connect to a database service that
    runs on one or more database servers
  • Services can grow, shrink, move dynamically
  • Large databases can span nodes using RAC
  • Multiple small databases can run on a single node
  • Predictable performance
  • Instance caging provides predictable CPU
    resources when multiple databases run on the same
    node
  • Restricts a database to subset of processors

ERP
CRM
Warehouse
Data Mart
HR
34
(No Transcript)
35
Resources
  • Oracle.comhttp//www.oracle.com/exadata
  • Oracle Exadata Technology Portal on OTN
    http//www.oracle.com/technology/products/bi/db/e
    xadata
About PowerShow.com