Exadata Database Machine

(1)

Extreme

Extraordinary

Exciting

By Craig Moir of MyDBA March 2011

(2)

Exadata & Exalogic

What is it?

It is

Hardware and Software engineered to work together It is

Extreme Performance Application-to-Disk Solution It is

World’s fastest Data Warehouse and OLTP server It is

The highest performance/lowest cost Solution

(3)

Massive Processing Power Shattering I/O Bottlenecks

Extreme Performance Massive Scalability

Ground breaking Technology Fastest tpmC at Lowest $/tpmC

Significant reduction in Cost of Ownership Massive R&D investment

Very Green Footprint

Flattering Industry Feedback

No adjective can suitably describe the capabilities of the Exadata Database Machine

(4)

Massive Processing Power

Maximum configuration

X2-2

Database Server

X2-8

Database Server

CPU’s 128 (2.93 GHz) 128 (2.26 GHz)

Core’s 768 1,024

Memory 6 Terabytes 16 Terabytes

Flash Storage 42 Terabytes

High Performance Disk or

High Capacity Disk

800 Terabytes (SAS) or

2,688 Terabytes (SATA)

Disk throughput 25 GB/s

Flash throughput 50 GB/s

Flash I/O’s per second 1 Million

(5)

Shattering I/O Bottlenecks

Typically I/O is the bottleneck for Data Warehouses and OLTP systems alike.

Exadata machine smashes through the I/O barrier.

And here is how:

1. Exadata Smart Flash Cache

Up to 100X faster than disk

1 million I/O’s per second

5 Terabytes of flash per storage server

Intelligently managed flash

Assign tables to flash storage via SQL statements

2. Exadata Intelligent Storage

• Data intensive processing moved to Storage Grid

• Up to 10X less data sent to Database servers

(6)

Shattering I/O Bottlenecks

And here is how continued:

3. Exadata Hybrid Columnar Compression

Column based organization and compression

A 10X compression ratio typically achieved

15X to 50X archival mode compression

Benefit from faster I/O, cache, backups, DR, Clone, Reorg

Massive disk storage reduction

4. Exadata Storage Index

In-memory storage indexes

Maintains summary information about table data (column MIN and MAX values)

5. InfiniBand Network

• High-speed interconnect architecture - low latency and high throughput

• Unified server and storage network

• RAC interconnect over InfiniBand

(7)

Extreme Performance

tpmC – 30 million transactions per minute.

43 Trillion transactions per day (0.5 second average response time).

Up to 50,000 Disk IOPS (I/O’s per second).

Up to 1,500,000 Flash IOPS.

12X faster for Internet apps, to over 1 Million HTTP requests per second.

4.5X faster for Java messaging apps, to over 1.8 Million messages per second.

4X to 50X compression ratio delivered.

Up to 75 GB per second of raw I/O bandwidth.

10X to 50X query performance improvement for Data Warehouses.

Up to 12 TB/Hour data load rate.

Near zero encryption overhead for hundreds of Gigabytes per second

transfer.

(8)

Massive Scalability

Connect ½ to ½ rack , ½ to full rack, full to full rack X2-2 Database Machine

Quarter Rack

Half Rack

Full

Rack 2 to 8 Full Racks

(9)

Massive Scalability

X2-2

¼ Rack

CPU 4

Core 24

RAM 192

GB

Database

Servers 2

Storage

Servers 3

Flash 1.1 TB

Disk (Perf or

Cap)

9 TB or 31TB

InfiniBand

Switches 2

X2-2

½ Rack

CPU 8

Core 48

RAM 384

GB

Database

Servers 4

Storage

Servers 7

Flash 2.6 TB

Cap)

22 TB or 75 TB

InfiniBand Switches 3

X2-2 Full Rack

CPU 16

Core 96

RAM 768 GB

Database

Servers 8

Storage

Servers 14

Flash 5.3 TB

Cap)

45 TB or 150 TB

InfiniBand

Switches 3

X2-2 Full Rack

CPU 128

Core 768

RAM 6 TB

Database

Servers 64

Storage

Servers 112

Flash 42 TB

Cap)

360 TB or 1200 TB

InfiniBand

Switches 3

8X

Connect ½ to ½ rack , ½ to full rack, full to full rack

X2-2 Database Machine

(10)

Massive Scalability

Scale to 8 Racks by “Just Adding Cables”

X2-8 Database Machine

Full

Rack 2 to 8 Full Racks

(11)

Massive Scalability

X2-8 Full Rack

CPU 16

Core 128

RAM 2 TB

Database

Servers 2

Storage

Servers 14

Flash 5.3 TB

Disk (Performance

or Capacity)

100 TB or 336 TB

InfiniBand

Switches 3

8X

X2-8 Full Rack

CPU 128

Core 1024

RAM 16 TB

Database

Servers 16

Storage

Servers 112

Flash 42 TB

Disk (Performance

or Capacity)

800 TB or 2688 TB

InfiniBand

Switches 3

X2-8 Database Machine

Scale to 8 Racks by “Just Adding Cables”

(12)

Ground breaking Technology

Hardware and Software engineered as one.

Unified InfiniBand Server/Storage/RAC Network.

Consolidate OLTP and DW on same server.

Exadata Intelligent Storage Grid.

Hybrid Columnar Compression.

Smart Flash Cache.

Flash/Disk storage allocation manageable via SQL.

Exadata Storage indexing.

Encryption moved from software to hardware level.

10 year O/S binary compatibility guarantee.

(13)

Fastest tpmC at Lowest $/tpmC ORACLE

10 Million 20 Million 30 Million

IBM

Rank 1

2

5

ORACLE IBM

tpmC – Transactions per Minute

$1 $2 $3

tpmC – Cost per tpmC

Oracle is 3X faster

Oracle is 36% cheaper

Rank 5

2

1

(14)

Significant reduction in Total Cost of Ownership

Eliminates vendor integration and component regression testing.

One Patch for software, hardware, firmware.

One Vendor – Hardware & Software perfectly compatible and tuned.

One Vendor implementation - No teams from multiple vendors.

Reduced capital investment through consolidation (OLTP, DW and mixed work loads on same systems).

Pre-packaged, pre-configured and pre-optimized.

Building block scalability by just connecting cables.

Reduced change management risk.

(15)

Massive R&D Investment

Oracle investing $4.3 Billion in research and development.

Oracle to invest more in developing SPARC than Sun did.

Oracle to invest more in developing Solaris than Sun did.

Oracle investing heavily in hardware and software integration.

(16)

Very Green Footprint

3 Racks of Exadata replaced 60 racks of Teradata kit– Softbank, Japan.

Upgraded and replaced 11 racks with 1 rack of Exadata - Turkcell, Turkey.

90% reduction in database size – Turkcell, Turkey.

60% reduction in power consumption – Turkcell, Turkey.

88% reduction in power consumption – LinkShare, USA.

Typically gives a 10X disk footprint reduction.

(17)

Flattering Industry Feedback

“24 hour query runs in 30 minutes” – Allegro, Christiaan Maar, CIO.

“10X to 72X performance improvement” – Mtel.

“30 minute query completed in under 60 seconds” – Grant Salmon, CEO, LGR Telecommunications.

"Improved Performance by 17x with Oracle Exadata“ - BNP Paribas.

“From 10X to 400X performance improvement” – Turkcell, Turkey.

“Exadata is BETTER that what was sold to us”.

“It has outperformed our expectations”.

“Exadata exceeded all Sales Hype”.

(18)

MyDBA is an Oracle Gold Partner Specialized in the following:

Oracle Database 11G

Oracle Performance Tuning 11G

(19)

MyDBA Consulting Services

For more information on Exadata or to enquire about MyDBA’s consulting services please contact us on:

[email protected]

0861 911 DBA +27 11 808 6451

http://www.mydba.co.za/

Disclaimer: This document is provided for information purposes only. While MyDBA has taken care to ensure that the content on this document is accurate, the information is provided "as is" and is not warranted to be error-free. Your use of and reliance on the information is entirely at your own risk.

This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the prior written permission of MyDBA.

(20)

References

http://www.oracle.com/exadata

http://www.oracle.com/technology/products/bi/db/exadata

http://www.oracle.com/technology/products/bi/db/exadata/pdf/exadata-technical-whitepaper.pdf

http://www.oracle.com/technology/products/bi/db/exadata/pdf/migration-to-exadata-whitepaper.pdf

http://www.oracle.com/us/products/database/database-machine/index.html

http://www.oracle.com/technetwork/database/exadata/exadata-technical-whitepaper-134575.pdf

http://www.cdrinfo.com/sections/news/Details.aspx?NewsId=28408

http://www.fors-europe.com/portal/page?_pageid=105,260779&_dad=portal&_schema=PORTAL

Oracle Magazine March/April 2011

http://en.wikipedia.org/wiki/Data_warehouse_appliance

http://www.oracle.com/us/038563.pdf

http://www.amcis2010.org/home/documents/Oracle_Exadata.pdf

http://www.theregister.co.uk/2010/09/16/oracle_q1_f2011_numbers/

http://www.managingautomation.com/maonline/news/read/Oracle_Completes_Sun_Acquisition__Lays_Out_St rategy_33252

http://www.enterprisestorageforum.com/article.php/3910406/Oracle-Exadata-in-the-Real-World.htm

http://www.slideshare.net/jarodwang/oracle-exadata-version-2?src=related_normal&rel=5881994

http://ferhatsengonul.files.wordpress.com/2010/10/turkcell-exadata-oow2010.pptx