simplify it: oracle supercluster
DESCRIPTION
How SuperCluster can help for Database and aplication consolidatonTRANSCRIPT
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
SuperCluster
Simplificación IT:Oracle on Oracle
Fran NavarroPrincipal System Sales consultant
Oracle Iberia Nov 2014
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Safe Harbor Statement
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
2
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Operational Inefficiencies
Resources Spent Supporting IT Services Already Deployed
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Typical IT Expenditure Distribution
Focus on ongoing expenses, not purchase price.
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Operational Costs Continue to SoarServer virtualization has flattened CAPEX at the expense of OPEX
‘96 ‘97 ‘98 ‘99 ‘00 ‘01 ‘02 ‘03 ‘04 ‘05 ‘06 ‘07 ‘08 ‘09 ‘10 ‘11 ‘12 ‘13
10
30
50
70
InstalledServers(M)
$250
$200
$150
$100
$50
0
CustomerSpending($B)
Power&CoolingExpense
Management&Administra on
ServerSpending
LogicalServerInstalledBase(M)
PhysicalServerinstalledBase(M)
RUN|MAINTAIN
Ref
: ID
C W
hit
epap
er -
4/2
01
2
“IDC Business Value customer research shows that [...] It is vital for system administrators, IT managers, and datacenter managers to consider the overall TCO, especially the often-overlooked management costs, before choosing server and virtualization solutions. IT organizations should take a holistic approach to datacenter efficiency.. “
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Horizontal platform strategies aren’t always the answer
1 128 2,187 16,384
78,125
279,936
823,543
1 2 3 4 5 6 7
Number of Possible Variants
Number of Different Best-of-Breed Options per Layer
• Data Warehousing
• Transaction Processing
• Business Analytics
• Mission-critical Packaged Applications
• Custom Applications & Development
The Future of IT Platforms
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Servers Storage Software Networking Management
ENGINEERED TO WORK TOGETHER
7
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Engineered Systems
Performance │ Efficiency │ Cloud Ready
ExalyticsVirtual Compute Appliance
ExalogicElasticCloud
Big Data Appliance
Database Appliance
Exadata Zero Data Loss Recovery Appliance
SuperCluster
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
1
2013 Integrated Stack Systems Market Share Rankings*
Oracle Engineered Systems Lead the Industry
50%13%
5%2
3 Source: Gartner, Inc., Market Share Analysis: Data Center Hardware Integrated Systems, Worldwide, 2013, Adrian O'Connell, 31 July 2014.
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Enterprise Cloud Platform for Application and Database Consolidation
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Application and Database ConsolidationSuperCluster Runs Applications and Database with In-memory Performance
11/5/2014 Oracle OpenWorld
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle SuperCluster T5-8 and M6-32 ArchitectureComplete | Optimized | Standardized
Integrated Enterprise NAS Storage
– System storage (system images, logs, test/dev databases, backup)
Unified Ultra-Fast Network
– InfiniBand internal I/O backplane
– Ethernet data center connectivity
Database & Application Servers
– T5-8: 16 CPU (16 cores), 4TB RAM– M6-32: 32 CPU (12 cores), 32TB
RAM
Exadata Storage Servers
– Optimized for Oracle Database
– Intelligent scale-out storage gridFully Redundant
Active Components
Fully RedundantActive Components
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
• Intelligent, scale-out storage grid for Oracle DatabaseQuery processing
OLTP
Compression
ExadataSuperCluster
Exadata Storage Server
Oracle ExadataIntelligent Scale-out Storage Grid
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Exadata Storage Technology Innovations
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
ExadataSuperCluster
Oracle
Exadata or SuperCluster
Oracle
Exalytics
Oracle Big Data Platform
Stream Acquire Organize Discover & Analyze
Oracle Big Data
Appliance
Oracle
Big Data
Connectors Optimized for Analytics & In-Memory Workloads
“System of Record”Optimized for DW/OLTP
Optimized for Hadoop, R, and NoSQL Processing
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
ExadataSuperCluster
Oracle
Exadata or SuperCluster
Oracle
Exalytics
Oracle Big Data Platform
Stream Acquire Organize Discover & Analyze
Oracle Big Data
Appliance
Oracle
Big Data
Connectors Optimized for Analytics & In-Memory Workloads
“System of Record”Optimized for DW/OLTP
Optimized for Hadoop, R, and NoSQL Processing
Oracle Enterprise
Performance Management
Oracle Business Intelligence
Applications
Oracle Business Intelligence
Tools
Oracle Endeca Information
Discovery
Hadoop
Open Source R
Applications
Oracle NoSQLDatabase
Oracle Big Data Connectors
Oracle DataIntegrator
In-D
atab
ase
An
alyt
ics
DataWarehouse
Oracle
Advanced
Analytics
OracleDatabase
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database as a Service
Manufacturing
Marketing
Human Resources
Engineering
Sales
Service
IT/OperationsFinance and Accounting
Flexible creation of DB environments of all sizes while retaining in-memory performance for all
Real-time dynamic resource allocation
Optimized for mixed workloads, including key application components
Runs multiple database versions concurrently
Maximally secure, serviceable, reliable
SuperCluster
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Simple, Automated Database Self-provisioning
• Simple self-service User Interface for platform tenants
• Tenants select from a catalog of database types
• One-click provisioning and deployment of databases
• Metering and chargeback/showback
• Role based access control, quota management App. DBA
Tenant
IT Dev/Test Tenant
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Catalog of Standardized Database Options for Tenants
SMALL MEDIUM LARGE XL
$$$$ $$$$$ $$$$$$ $$$$$$$
$$$ $$$$ $$$$$ $$$$$$
$$ $$$ $$$$ $$$$$
$ $$ $$$ $$$$
19
Security, Performance& Availability
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database + Application Virtualization Technologies
SuperCluster
Physicalserver Domain Domain
PhysicalDomain
Oracle VM for SPARC
Oracle VM for SPARC
Oracle VM for SPARC
Oracle VM for SPARC
Oracle VM for SPARC
DB 12cZone
App.Zone
DB 10gZone
DB 11gZoneDB 12c
Zone
DB 10gZone
1. Instance consolidation
• Multiple Databases running on same Solaris Operating System
• Each Database has direct access to shared resources
• Each Database is unique
12
2. Pluggable Database
• In Database Virtualization
• Reduction in overhead
• High performance, high density consolidation
• Isolation of virtualized database
3. Schema-level database consolidation
• Shared Database
• Minimizes management entities
• Minimize resource overhead
PDB PDB
DB Instance
SCH SCH
3DB
InstanceDB Instance
DB 11g
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Database Appliance X4-2
ExadataX4-2
ExadataX3-8
SuperClusterT5-8
SuperClusterM6-32
Good for Turn-key, Small Enterprise DB Excellent Good No No NoOLTP, DW & DB Consolidation Standard Excellent Excellent Excellent ExcellentIn-memory Workload Support No Good Very Good Very Good UnbeatableVirtualization-based Multitenant Limited No No Yes YesDatabase Versions Supported 11g/12c 11g/12c 11g/12c 9i/10g/11g/12c 9i/10g/11g/12cAlso Runs Applications Yes No No Yes YesSub-capacity Software Licensing* Yes Yes (CoD only) Yes (CoD only) Yes YesSAN connectivity No No No Yes YesOracle Solaris Support No Yes No Yes YesOracle Linux Support Yes Yes Yes No NoEntry Level Sizing Very Small Small Large Medium LargeSecure Legal Entity Multi-tenancy No Limited Limited Yes Yes
Choosing the Right Database MachineDifferent Database Machines Optimized for Different Deployment Types
*Exadata Capacity on Demand provides limited sub-capacity licensing, SuperCluster and ODA provide full hard partitions support
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 22
Exabus is at the Center of Exalogic’s System Software
Exabus is Exalogic’s High-speed I/O Backplane Comprised of Hardware + Software
IPoIB SDP Native IB
User
Kern
el
Hard
wa
re
High-speed IB fabric,
no application change
required
Bypass TCP/IP layer to get
even higher performance
Highest performance,
native IB support
SDP
IB Core
HCA Driver
TCP
IP
IP over IB
IB Core
HCA Driver
TCP
IP
NIC Driver
Ethernet NIC
Applications
Middleware
Applications
Middleware
IB HCA IB HCA IB HCA
Applications
Middleware
Exalogic
Traditional
Applications
Middleware
Pro
du
ct Focu
s Area
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
SPARC’s Delivered Performance Over Time
Oracle InvestmentIn SPARC
OracleAcquires Sun
34x
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
The Ultimate Software Optimization:https://www.youtube.com/watch?v=anT99OvEpNg
Revolution, Not Evolution!
Software in Silicon
Performance
DB In-Memory Acceleration Engines
Reliability/Security
Application Data Integrity
Capacity
Compression Engines
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Software-in-Silicon Features
Name Description Use Case(s)
Database Query Acceleration
Offload queries Speed-up queries and reduce CPU load
Data Decompression Decompress operations on vector data
Reduce memory footprint of data warehouse without performance loss
Application Data Integrity
Detect invalid memory accesses Detect invalid memory references in SGA;hardware assisted, faster and higher quality code development
Low Latency Clustering Move data/messages between physical domains
Speed-up for Oracle RAC inter-node communication (message passing and remote memory access)
Java Optimization Multi-core Scalability Makes data parallelism explicit
Encryption HW assisted encryption of data Secure network and database transactions
Oracle Confidential – Restricted 26
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Decompress at memory speed >120 GB/sec
Software in Silicon: Accelerating Oracle Database 12c
One step 10X
faster
DecompressMore than Doubles data size
ReadSoftware
scanRea
d
Write
Wri
te
Rea
d
DA
X
Wri
te
Multiple steps
SQL:SELECT count(*)…WHERE lo_orderdate = d_datekey…AND lo_partkey = 1059538AND d_year_monthnum BETWEEN 201311 AND 201312;
t
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Up to 170 Billion rows per second
Stupendous Performance with Fewer Cores
QueryThroughput
Legacy Approach
UseableMemory
Legacy Approach
Frees 64 cores for decompress and frees 32 cores for query
Comparing current systems with equivalent CPU core counts and physical memory
Oracle Software in Silicon 10x
Oracle Software in Silicon 3x
Over
More
Up to
Higher
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle SuperCluster
11/5/2014 Oracle OpenWorld
• Oracle's Most Powerful Engineered Systems – World Record Oracle Database and
Application Performance & Scalability
– Software Defined Secure Multi-tenancy
– Outstanding Affordability and ROI
• Oracle’s Hottest Technology– Exadata Storage Servers
– Oracle M6 and T5 Microprocessors
– 24-Terabit Silicon Network
– Oracle VM and Solaris Virtualization
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 30