Transcript презентацию

Эффективность и
производительность
Pavel Shaternik
Senior consultant
Complete. Open. Integrated.
Интеграция технологий для эффективности решения бизнес задач
 Производительность
 Надежность
 Безопасноть
 Управляемость
 Качество
Optimized Solutions Positioning in the Oracle Portfolio
High Performing Application-to-Disk Solutions from a Single Vendor
HIGH
Engineered Systems
EFFICIENCY
Oracle’s Optimized
Solutions
Applications
Fusion Middleware
Database
Oracle Solaris/Linux &
V12N
Compute,
storage, network,
software
Server
Storage
Manageability & Simplicity
© 2010 Oracle Corporation
HIGH
Классические компоненты - классические решения
Серверы
x86
SPARC T/M
Blade
High-End
Системы хранения
SSD
Unified
SAN
Tape
Инфраструктура
Ethernet
© 2010 Oracle Corporation
SAN
Infiniband
Оптимизированные решения
Site: http://www.oracle.com -> Solutions -> Technology solutions -> Oracle Optimized Solutions
© 2010 Oracle Corporation
Оптимизированные решения – Oracle Database
Site: http://www.oracle.com -> Solutions -> Technology solutions -> Oracle Optimized Solutions
© 2010 Oracle Corporation
Engineered Systems & Appliances
Cloud Built In
General Purpose
Purpose Built
Exadata
Exalogic
Big Data
SPARC
SuperCluster
Database Appliance
© 2010 Oracle Corporation
Exalytics
Классический подход, стандартные компоненты
в составе локально-интегриуемых решений
Наибольшие преимущества от аппаратных компонент
применяемых совместно с програмным обеспечением
Oracle on Oracle
Технологические преимущества
Бюджетные преимущества
Тестирование и сертификация
Документирование и поддержка
Полнота и простота интеграции
Гарантии развития
Уменьшение рисков
© 2010 Oracle Corporation
Engineered Systems & Appliances
Cloud Built In
General Purpose
Purpose Built
Exadata
Exalogic
Big Data
SPARC
SuperCluster
Database Appliance
© 2010 Oracle Corporation
Exalytics
Oracle Database Appliance
The Best Database System for
Small to Mid-size payloads
© 2010 Oracle Corporation
Oracle Database Appliance X3-2
Base Configuration Details
More Processing Power
•
•
2 x 1RU x86 Servers. Each Server
Contains:
–
2 x 8-core Intel Xeon Processors E5-2690
–
256 GB RAM (16 x 16 GB)
–
2 x 600 GB Boot Disks (mirrored)
–
1 x Internal SAS HBA
–
2 x External SAS HBAs
–
Redundant 10 GbE Interconnects
–
4 x 1/10 GbE Base-T External Networking
1 x 2RU Storage Shelf – Direct-Attached
–
4 x 2.5” 200 GB SSD for Redo
–
20 x 2.5” 900 GB HDD for Data
© 2010 Oracle Corporation
<Insert Picture Here>
Exadata
Основы технологии
© 2010 Oracle Corporation
Как обычно работает СУБД Oracle
SGA
SELECT customer_id
FROM calls
WHERE amount > 200;
SQL
Трафик между
сервером и
дисковым
массивом
Результат
Блоки
данных
(4..32КБ)
© 2010 Oracle Corporation
Кеширование данных на твердотельных накопителях
SGA
SQL
Результат
Флэш-память
(SSD)
Блоки
данных
© 2010 Oracle Corporation
Oracle Exadata Database Machine X4-2
Что внутри?
●
8 серверов баз данных
●
●
●
●
Два 12-ядерных (2.7 ГГц) Intel Xeon E52697v2, 256/512 ГБ ОЗУ, 4 SAS-диска
600 ГБ, 2 QDR (40Гб) IB-порта, 4x10GbE
Oracle DB EE, RAC и Partitioning
Три 36-портовых коммутатора InfiniBand
14 дисковых серверов (Exadata Storage)
●
●
●
Два 6-ядерных Intel Xeon CPU, 96 ГБ
ОЗУ, 12 дисков (15K RPM или 7.2K
RPM),
3.2 ТБ флэш-памяти, 2x QDR (40Гб) IB
Oracle Enterpise Linux
Oracle Exadata Storage Server Software
© 2010 Oracle Corporation
SPARC SuperCluster T4-4
Engineered to Work Together
Extreme Performance
Breakthrough Innovation
Virtualization
Low Overhead
10x compression for Data Warehouse queries
10x OLTP Response time
2x better performance against IBM and HP
Ease of Deployment
High Availability
Integrated Hardware and Software
Built in
Deploy in days not months
99.999% Uptime
Streamlined Management
Fast & foolproof upgrades
Secure by Design
SPARC/Solaris Built-in Encryption &
Compression
5x faster security than IBM
Power7, 3x faster than x86
© 2010 Oracle Corporation
Resource Management
2.2 minutes vs 24 minutes
Performance Workload Management
On the fly performance adaptation
to your business needs
SPARC SuperCluster Architecture
Best infrastructure solution for enterprise applications
Exadata Storage Servers
• 256 CPU cores
• 4 TB DRAM
SPARC T5-8 Compute Nodes
ZFS Storage Appliance
InfiniBand Switches
• Up to 288 TB Hard Disk
• 80TB Unified storage
• 33 TB Flash
• 1.2M IOPS
• 42 GB/sec Storage Bandwidth
• 896 Gb/sec InfiniBand Interconnect
© 2010 Oracle Corporation
SPARC SuperCluster Management
Converged Hardware Management
• Unified management of Servers,
Storage, and Network Fabric
• Simplified management of virtual
infrastructure for easy application
consolidation
• Instant Network and Storage
provisioning
• Automated update of all firmware
and software components
• Direct connection to Oracle
knowledge-base speeds problem
resolution
© 2010 Oracle Corporation
<Insert Picture Here>
Обзор серверов
Oracle SPARC Server
T-series
SPARC Enterprise Servers
Более 20 лет работы в области критически важных
вычислений
• Производительность оптимизирована
для работы приложений
• Надежность, готовность, обслуживаемость
и безопасность
• Консолидация и виртуализация
SPARC T4-4
• Высокий уровень
SPARC T5-4
SPARC T5-8
масштабируемости
SPARC T4-2
SPARC T5-2
SPARC T4-1
SPARC T4-1B
SPARC T5-1B
© 2011 Oracle Corporation
M8000
M9000
M5-32
M6-32
Пять поколений процессоров
1. UltraSPARC T1 — 8 cores / 32 threads
2. UltraSPARC T2 — 8 cores / 64 threads
3. UltraSPARC T2+ - 8 cores / 64 threads + cocherence links
4. T3 — 16 cores / 128 threads
5. T4 — 8 cores / 64 threads + single thread improvements
6. T5 — 16 cores / 128 threads
© 2011 Oracle Corporation
Новые рекорды производительности
3000GB
© 2011 Oracle Corporation
Новые рекорды производительности
http://www.spec.org/jEnterprise2010/results/jEnterprise2010.html
© 2011 Oracle Corporation
Multi-core factor
© 2011 Oracle Corporation
Multi-core factor
© 2011 Oracle Corporation
SPARC Enterprise Servers
Maximizing Results
5 Year Trajectory
Cores
Threads
Memory Capacity
Database TPM
Java Ops Per Second
4x
32x
16x
SPARC
1-64 Sockets
+2x Throughput
+1.5x Single Strand
40x
10x
M-Series
16-64 Sockets
+2x Throughput
T-Series
1-4 Socket
+ 2x Throughput
M-Series
1-64 Socket
+ 20%
Solaris 10
Update
2010
© 2011 Oracle Corporation
T-Series
1-4 Sockets
+3x Single Strand
Solaris 11
2011
M-Series
Sockets8-64
+6x Throughput
+1.5x Single Strand
Solaris 11
Update
2012
T-Series
1-8 Sockets
+3x Throughput
Solaris 11
Update
2013
Solaris 11
Update
2014
2015
SPARC T5 Processor
●
Click to edit the outline text format
–
Second Outline Level
●
Third Outline Level
–
Fourth Outline Level
Fifth Outline Level Integrated I/O
● Sixth
Outline
– 16 S3 cores, 16-128
Strands
@ 3.6GhzLevel – Double I/O bandwidth over T4
– SingleOutline
or multi-threaded
operationtoper
– 2text
x8 Lane
PCIe 3.0 @ 8GT/s
Seventh
LevelClick
edit Master
styles
 Features
●
core
– System scalability to 8 sockets
 SPARC Core S3
– 1-8 Strand Dynamically Threaded Pipeline
– ISA-based Crypto-acceleration
 8MB Shared L3$
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
 System Scalability
– 7 Coherence Ports for scalability to 8S
 Power Management
– Dynamic Voltage Frequency Scaling
– Downclock, Overclock
M5/6 Processor
Click to edit the outline text format
● 6(12 for M6) S3 cores @ 3.6Ghz
–
–
Single or multi-threaded operation per core
–6-48Second
total strandsOutline
Level
 SPARC S3 Core
Third Outline Level
–
●
1-8 Strand
Dynamically Threaded Pipeline
–
Vertically Threaded 2-decode, Out-of-Order
–
(OoO) 2-Issue
–
16KB 4-way L1 I$
–
16KB 4-way L1 D$
Fourth Outline Level
Fifth Outline Level
● Sixth Outline Level
– 128KB 8-way L2$
– ISA-based
Crypto-acceleration
Seventh
Outline
LevelClick to edit Master text styles
●
 Shared 48MB L3$
 Memory Controllers
–
2x Dual Channel DDR3L MCU's
–
Cascadable Buffer-on-Board (BoB)
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
 Integrated I/O
–
2 x8 Lane PCIe Gen3 @ 8GT/s
–
32GB/s IO Bandwidth per processor
 System Scalability
–
Up to 8-socket glueless
–
32-socket Systems via scalability links
New l SPARC M6 Servers
32-Socket
●
Click toHigh-End
edit the outline
Datacenter
text format
Server
–
Second Outline Level
 Compute
–
–
Third Outline Level
Up to ●32x SPARC M6 12 core 3.6GHz CPUs
Up to 1024x DDR3 DIMMs for max memory of up to 32TB
 I/O and storage
–
–
Fourth Outline Level
32x 2.5” SAS-2 internal drives
●
64x PCIe Gen3 low profile internal slots
Fifth Outline Level
● Sixth
Outline Level
 Scalability and investment
protection
– Upgradable with M6 processor
Seventh
Outline LevelClick to edit Master text styles
–
 Availability and management
–
–
–
Advanced RAS with redundant and hot swap of key components
Extensive virtualization with Oracle VM Server for SPARC + hard partitions
Integrated Oracle ILOM system management
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
Плюс к сказанному о дальнейшем развитии
SPARC
Software in Silicon
• Security: Enhanced cryptography
• Oracle numbers Arithmetic Acceleration
• Hardware Decompression
• In Memory Columnar Database Acceleration
• Memory Versioning
• Low Latency Clustering
© 2010 Oracle Corporation
Oracle's Sun – виртуализация на всех уровнях
Hard Partitions
App
Server
Database
Identity
Server
Virtual Machines
File
Server
Web
Server
Mail
Server
OS Virtualization
Calendar
Server
Databas
e
Web
Server
Resource Management
SunRay
Server
Database
App
Server
App
OS
Server
Multiple OSs
Trend to flexibility
Dynamic System
Domains
> Very High RAS
> Very Scalable
> Mature Technology
> Ability to run different OS versions
© 2011 Oracle Corporation
Single OS
Trend to isolation
Oracle VM
Solaris Containers
(Zones + SRM)
(LDoms and Xen)
Solaris Trusted
VMware
Extensions
Microsoft
Virtual Server
Solaris Containers for
Linux Applications
Solaris Resource
Manager
(SRM)
> Very scalable and low overhead
> Single OS to manage
> Fine grained resource management
Портфолио систем хранения Oracle
Engineered for Oracle Software
ZFS Storage
Appliance
SAN
Storage
NAS Storage
6000/2500
series
Storage Software
Flash Storage
Storage Management: OEM, ASM, DTrace Analytics, CAM, ACSLS, ELS
Automated Tiering: Partitions, SAM QFS, Hybrid Storage Pools, VSM
Data Reduction: 11g ACO, EHCC, RMAN, ZFSSA Dedup/Comp
Data Protection: Data Guard, RMAN, OSB, ZFSSA Snap/Rep, MaxRep
Security/Encryption: ASO, Oracle Key Manager, Disk/Tape Encryption
SSD
© 2011 Oracle Corporation
F20
F5100
Инновационные системы
хранения
Axiom 600
© 2011 Oracle Corporation
<Insert Picture Here>
Pillar Axiom 600
Модульная архитектура: основные строительные блоки
Storage Controllers – Slammer (1 to 4 per Axiom)
Active-Active SAN or NAS control units
• 48GB Cache
• SAN: 4x 8Gbps FC, 4x 4Gbps FC, 8x 1GbE iSCSI
• NAS: 4x 10GbE, 8x 1GbE
• Redundancy for High Availability
•
Storage Enclosure – Brick (1 to 64 per Axiom)
•Dual RAID controllers
•Embedded RAID-5 and RAID-10
•SATA, Fibre Channel and SSD drives
•Built in hot spare
•Hot-swappable drives and RAID Controllers
Management Controller - Pilot (1 per Axiom)
Dual control units
• Active/Standby - High Availability Cluster
• (2) Hard drives for Configuration and Log Cache
• (6) 10/100/1000 Base-T Ethernet
•
© 2011 Oracle Corporation
Модульная архитектура - Axiom 600 Architecture
Масштабируемая производительность
© 2011 Oracle Corporation
Pillar Axiom Storage System
Интеграция с ПО Oracle
•
•
•
•
•
•
© 2011 Oracle Corporation
Hybrid Columnar Compression
Integration with Oracle Database 11g
Integrated with OracleVM Storage
Connect
Integrated with Automatic Storage
Management (ASM)
Integrated with Oracle Enterprise
Manager
Integrated with Sun Storage Archive
Manager
Optimized Solutions for Oracle
Applications
Hardware | ZFS Storage Appliance: ZS3-4
Oracle Confidential – Exclusive Partner and Sales Discussions
•
High Availability, High Performance Tier 1 Storage
•
Ideal for performance-intensive, large data set
workloads, including performance database, BIDW,
server virtualization, and large-scale, high
performance file sharing
•
Full set of data services, including optional
Replication and Cloning to facilitate DR and test/dev
•
1GbE, 10GbE, FC, and IB connectivity options
•
Powerful Single or Dual Controller
•
1TB DRAM per controller head
•
40 CPU cores per controller
•
Up to 4x1.6TB Read SSDs per controller
•
Up to 36 expansion trays
ZFS Storage Appliance: Controller Options
●
Click to edit the outline text format
ZS3-2
ZS3-4
ZS3-BA
4x10 core
4x10 core
1 TB
1 TB
4 SSDs
4 SSDs
Base units ship with 1 per
controller; allow up to 4
through x-options
384*
864
860
4
7
7
PCIe Version
3.0
2.0
2.0
Form Factor
2U (4U HA)
3U (6U HA)
6U
–
CPU Cores
Second Outline
Level
2 X 8 core
DRAM
Max Read Flash
●
256 GB
Third Outline
Level
Fourth Outline Level
Max Write Flash
64 SSDs*
144 SSDs
144 (HC) or 132 (HP)
● Fifth Outline Level
HC and HP systems come
HA Option
Yes
Yes
clustered
● Sixth Outline Level
# Data HDDs in-head
0
0
0
Seventh Outline LevelClick
to edit
Subtitle
Max # Disk Enclosures
16*
36
36
Max # Drives
# Open PCIe Slots
–
* ZS3-2 specs at release are half that indicated (8 DE, 32 Write Flash, etc.)
ZFS
The Hybrid Storage Pool
© 2011 Oracle Corporation
Software | Hybrid Storage Pools
Oracle’s Hybrid Storage Pool Considerations
Component
Memory
(RAM)
Read Cache
(Flash SSD)
Write Cache
(Flash SSD)
Disk
High Capcty
High Perf
• Memory (RAM)
●
●
Storage ZS3-2
512 GB
Up to 12TB
Up to 64*
1.5 PB*
345TB
Storage 7420M2
2,048 GB
Up to 12 TB
Up to 144
3,456 TB
777 TB
Storage ZS3-4
2,048 GB
Up to 12 TB
Up to 144
3,456 TB
777 TB
Storage ZS3-BA
2,048 GB
3.2TB
standard
Up to 140 (HC)
or 132 (HP)
3,440 TB
774 TB
• Read Cache Flash SSD
•
•
•
© 2012 Oracle Corporation – Proprietary and Confidential
© 2011 Oracle Corporation
2nd fastest after Memory (RAM)
Start with 2 Read Flash devices
Add additional devices based on Analytics data
• Write Cache Flash SSD
•
•
* ZS3-2 at initial release will support 8 disk-shelves for 768GB capacity and 32 write cache devices.
Within 6 months, 16 disk-shelves will be supported for 1.5PB capacity and 64 write cache devices.
Best for Read performance
Maximize first, before Read Flash.
Most applications have a mix of writes
Start with 4 devices for every 4 shelves
Функциональность, без дополнительных затрат*
●
●
●
●
●
●
●
●
●
●
Data
Data
Additional
Protocols
Services
Management
NFS v2,v3 and v4
CIFS
iSCSI
HTTP
WebDAV/HTTPS
FTP
NDMP
SFTP
Infiniband
FC-target
© 2011 Oracle Corporation
• Log/Write Flash
Acceleration
• Read Flash Acceleration
• RAID-Z DP (6)
• Triple-parity
• Mirroring
• Striping
• Active-active Clustering
• * Remote Replication
• Antivirus
• * Snapshots (r/o,r/w,
unlimited)
• Compression
• Shadow migration
• User quotas
• De-dup
• Analytics
• Simple out-of-the-box
setup
• Secure Browser UI and
CLI
• Advanced Networking
• NIS, LDAP, and AD
• NTP
• Users, Roles, RBAC
• Dashboard
• Alerts
• Phone Home
• SNMP
• Scripting
• Simple Upgrade
Отзывы заказчиков — Storage Magazine
Data
Services
© 2011 Oracle Corporation
Ленточные накопители
Entry-Distributed
Midrange
Enterprise
midrange*
Enterprise*
No offers!*
SL150
SL3000
SL8500
30
SL500
300
200
SL3000
1000
* - другие вендоры
© 2011 Oracle Corporation
Количество слотов
5000+
SL8500
70,000