Novinky v Oracle Exadata Database Machine

(1)

Novinky v Oracle Exadata Database Machine

Gabriela Hečková

ORACLE PRODUCT

LOGO

(2)

Agenda

• Exadata – vývoj riešenia

• Nové vlastnosti

• Management riešenia

(3)

Agenda

• Exadata – vývoj riešenia

• Nové vlastnosti

(4)

Slabé miesta súčasných systémov

Obmedzená dátová priepustnosť medzi storage a DB servermi Úzke miesto

(5)

Priebeh a spracovanie dotazu:

Využitie tradičného úložiska

Aký bol náš včerajší predaj?

SUM

Databázový server

Tradičný Storage Array

Načíta celú tabuľku

SALES SELECT

príkaz

Storage posiela 1TB

(6)

Ako riešiť obmedzenú priepustnosť?

• Viac „kanálov“

• Širšie „kanály“

• Posielať menej dát cez „kanály“

(7)

Priebeh a spracovanie dotazu:

Využitie Oracle Exadata

Aký bol náš včerajší predaj?

SUM

SELECT

príkaz Spracuje

príkaz Oracle Database Grid

Storage server prehľadá 1 TB a na server pošle 1 GB Storage Grid

(8)

Exadata Architektúra

Kompletný systém: server, storage, networking

Database Cluster

Intel-based database servers Oracle Linux or Solaris 11 Oracle Database 11g

10 Gig Ethernet (to data center) Storage Grid

Intel-based storage servers Up to 504 terabytes raw disk 5.3 terabytes Flash storage

Exadata Storage Server Software InfiniBand Network

Internal connectivity ( 40 Gb/sec )

(9)

Exadata Evolution

• Exadata Introduced

• V2 CPU Refresh

• 40 Gb InfiniBand

• PCI Flash Cards

• X2-2 CPU Refresh

• X2-8 64-core Servers

• Sparc SuperCluster

• 3TB Disks

• Smart Flash Cache

• Storage Index

• Columnar Compression

• Smart Scan

• InfiniBand Scaleout

• Smart Memory Scan

• Parallel Memory Affinity

• Enterprise Manager 12c

• Hardware DB Encryption

• Automatic Service Request

• Data Mining Offload

• Storage Expansion Rack

• X2-8 CPU Refresh

• 2TB DRAM per node

• Solaris x86

• Reverse Offload

• Smart Flash Logging

State-of-the-Art, Scale-out Hardware

Unique Software Integration

Future Optimizations

• In-Memory Optimized Compression

• Memory-to-Memory InfiniBand Messaging

• Flash Cache for Writes

2008 2009 2010 2011 2012

(10)

Agenda

• Exadata – vývoj riešenia

• Nové vlastnosti

(11)

Exadata Innovations

• Intelligent storage

– Scale-out InfiniBand storage – Smart Scan query offload

+ + +

Hybrid Columnar Compression

10x compression for warehouses 15x compression for archives

Smart PCI Flash Cache

Accelerates random I/O up to 30x Triples data scan rate

Data remains compressed for scans and

in Flash

Benefits Cascade to Copies

compress

primary DB

standby

test dev

backup uncompressed

(12)

Exadata for SAP

Certification announced June 10, 2011

(13)

SAP Applications with Oracle Exadata

SAP

Instances

SAP ECC 6.0

SAP BW 7.x

Presentation Application Database SAP

Instances

SAP

Instances

(14)

Exadata Storage Expansion Rack

Big Data for Less

• Expands storage capacity of existing Exadata Database Machines and SuperCluster

• Available with either 600GB High Performance disks or 3 TB High Capacity disks

• Essentially Database Machine with database servers replaced by more Storage Servers

• For Unbalanced Applications that need more space but not more compute

• On-disk Backups (up to 27 TB/hour)

• Historical or Archive Data

• File Data, LOBs, XML Data, Documents

• Images, and other large unstructured data

(15)

Exadata Storage Expansion Racks

Expand Database Machine Storage Capacity Online

Full Rack Half Rack

Quarter Rack

Up to 648 TB Disk 6.75 TB Flash

18 Storage Servers 216 CPU cores Up to 324 TB Disk

3.4 TB Flash 9 Storage Servers 108 CPU cores Up to 144 TB Disk

1.5 TB Flash

4 Storage Servers 48 CPU cores

Multi Rack

InfiniBand Connected

8+ Racks

Database Backups, Historical Data, Files, Images, XML

(16)

Exadata X2-2 Memory Expansion Kit

• Optional kit for X2-2 customers who consolidate large numbers of databases and require more memory

• Changes memory configuration of the X4170 M2 database server from 96Gb (12 x 8 GB) to 144 GB (18 x 8 GB

• Minor reduction in performance due to lower memory bandwidth

• Adding memory drops the memory frequency from 1333 MHz to 800 MHz

• Available for X2-2 Full, X2-2 Half, and X2-2 Quarter Racks

(17)

Exadata Smart Flash Log

Accelerate Transaction Response Times using Flash

• Uses Flash for Database Logs in a clever way

• Flash is fast but has slow outliers

• Erase cycles, wear leveling, etc.

• Smart Flash Log feature transparently uses Flash as a parallel write cache to disk controller cache

• Whichever write completes first wins (disk or flash)

• Better response time and more throughput

• Uses almost no flash capacity (0.1% of capacity) Default (on left)

- Choppy response - High Outliers Smart Flash Log - 3x faster response - Much lower outliers

Transaction Response Times

Smart Flash Log Enabled

Automatic and Transparent

(18)

Agenda

• Exadata – vývoj riešenia

• Nové vlastnosti

• Management riešenia

(19)

Oracle Enterprise Manager for Exadata Management

Integrated View of Hardware and Software

• Hardware view

• Schematic of cells, compute nodes and switches

• Hardware components alerts

• Software/system view

• Performance, availability, usage by databases, services, clusters

• Software alerts db, cluster, ASM

• Topology view of DB systems/clusters

• Configuration view

• Version summary of all components along with patch recommendations

(20)

Exadata Aware SQL Monitoring

Real time monitoring of application SQL

I/O performance graphs with Exadata information

• Cell offload efficiency

• Cell smart scan Rich metric data

• CPU

• I/O requests

• I/O throughput

• PGA Usage

• Temp Usage

(21)

Storage Cell Management

• Storage Cell monitoring and administration support

– Cell Home page and performance pages

– Actions supported: Start/stop Cell, verify connectivity, setup SSH

• Automatic discovery of Exadata cells

• Management by Cell Group – All cells used by a database

automatically placed in a group – Cell Group level administration

operations (batch job monitoring)

(22)

Q&A

(23)

(24)