IBM System X Solution for SAP HANA 2012 년 4 월
목차 IBM SAP HANA Appliance IBM SAP HANA Appliance 소개 - IBM SAP HANA Optimized Solution Why IBM SAP HANA Appliance Solution? 2
SAP HANA 와 IBM SAP HANA Appliance 3
SQL MDX BICS SAP HANA - SAP In-Memory Computing Run Better with SAP In-Memory Computing SAP BusinessObjects software and other applications 빠르고향상된의사결정가능 정보에대한싞속한접근및갂편한협업기능의 새로운비즈니스접근방식제공 SAP ERP replicate 대용량의트랜잭션과분석기능을결합한혁신적인새어플리케이션사용기졲의계획, 예측, 가격최적화및기타프로세스의획기적개선제공 SAP HANA 3rd Party SAP BW ETL TCO 절감및비즈니스성과가속화온-디맨드또는어플라이언스를통해제공되며쉽게구현할수있는검증된툴을기반으로하드웨어, 유지보수및테스트작업을줄여줌 4
SAP HANA Appliance = SAP + IBM 기술혁신의융합 기졲 SAP의 In-Memory 기술을한단계발젂시킨 SAP HANA 소프트웨어가 IBM ex5아키텍쳐기반의서버에최적화되어짂 In-Memory Applicance로서유연하고데이타독립적이며, 다양한용도로사용될수있습니다. Database, Server 및 Storage 가하나로통합된 Appliance 시스템으로분석을위한처리가 Memory 에서실행되므로실시간대용량데이타분석이가능합니다. HW Technology Innovations Pre-Installed Systems (Hardware) 멀티코어아키텍쳐 (8 x 10 core CPU per server) 대규모수평확장 SW Technology Innovations In-Memory Computing Engine (Software) Row and Column Store Compression 대용량메모리확장 Partitioning 초고속 Storage IOPs No Aggregate Tables Price/Performance 의드라마틱한개선 Insert Only on Delta 5
IBM Workload Optimized Solution for SAP HANA Applications SAP HANA GPFS SNC functionality ITM TSM IBM Director SUSE OS SUSE Linux Enterprise Server Priority Support for SAP applications Server HW ex5 - x3690 X5 and x3950 X5 EX processors Scalability exflash Memory capabilities etc. 6
IBM SAP HANA Appliance 솔루션소개 7
IBM Workload Optimized Solution Upgrade / scale out Scenarios Certified Single Server Small Small+ Medium Large 서버 Memory 구성 256GB 256GB 512GB 1TB x3690 X5 1 x3950 X5 1 1 2 8
Building Blocks for the IBM SAP HANA Smart Appliance IBM System x3690 X5 IBM System x3950 X5 Secondary EXA Primary 9
Single System Configuration (scale up) for SAP HANA Model IBM System x3690 X5: Workload Optimized Solution for SAP HANA IBM System x3950 X5: Workload Optimized Solution for SAP HANA 7147-H1x 7147-H2x 7147-H3x 7143-H1x 7143-H2x 7143-H3x Upgrade Option + 7143-H2x T-Shirt Size Model XS Model S Model SSD Model S+ Model M Model L Intel Xeon E7 Processor 2 socket 2 socket 2 socket 2 socket 4 socket 8 socket Memory 128 GB 256 GB 256 GB 256 GB 512 GB 1024 GB Solid State Disk IBM exflash 8x IBM 50 GB SATA 1.8" MLC SSD IBM exflash 8x IBM 50 GB SATA 1.8" MLC SSD IBM exflash 10x 200 GB 1.8" MLC SSD IBM 320 GB High IOPS SD Class SSD PCIe Adapter High IOPS MLC Duo Adapter for IBM System x High IOPS MLC Duo Adapter for IBM System x Hard Disk 8x 300 GB 10k SAS HDD 8x 300 GB 10k SAS HDD -- 8x IBM 600 GB 10K 6 Gbps SAS 2.5" SFF Slim-HS HDD 8x IBM 600 GB 10K 6 Gbps SAS 2.5" SFF Slim-HS HDD 16x IBM 600 GB 10K 6 Gbps SAS 2.5" SFF Slim-HS HDD Networking Ports 2x 10 GbE 6x 1 GbE 2x 10 GbE 6x 1 GbE 2x 10 GbE 6x 1 GbE 2x 10 GbE 6x 1 GbE 2x 10 GbE 6x 1 GbE 4x 10 GbE 12x 1 GbE Software Novell SUSE Linux for SAP IBM GPFS SAP HANA Novell SUSE Linux for SAP IBM GPFS SAP HANA Novell SUSE Linux for SAP IBM GPFS SAP HANA Novell SUSE Linux for SAP IBM GPFS SAP HANA Novell SUSE Linux for SAP IBM GPFS SAP HANA Novell SUSE Linux for SAP IBM GPFS SAP HANA 10
Single System Configuration (scale up) for SAP HANA x3690 X5 Size L : This is ONE system Redpaper: IBM ex5 Portfolio Overview: IBM System x3850 X5, x3950 X5, x3690 X5, and BladeCenter HX5 http://www.redbooks.ibm.com/abstracts/redp4650.html?open 11
IBM Systems solution for SAP HANA - Simple, Seamless, & Scalable x3690 X5 and x3950 X5 workload optimized solutions Scale-out Simple No SAN required Expand database by adding nodes One part number ordering for each node Seamless Highly Available (HA) Optimizes system availability Intelligent Cluster integrated packaging and assembly Speeds installation and deployment Reduces implementation risk Installation and managed services Speeds installation Ensures skills transfer Simplifies on-going maintenance Scalable Scale to 8TB and larger* Supports large database requirements Validated by SAP 4 Node x3690 X5 and x3950 X5 16 Node x3950 X5 with HA* 12
IBM Systems solution for SAP HANA - Simple, Seamless, & Scalable Key Features Workload Optimized Solution for SAP HANA Scalable processor, memory, and storage (exflash or FusionIO) Integrated SSD and spinning disk with GPFS Pre-loaded, pre-configured x3690 X5 and x3950 X5 workload optimized solutions Customer Benefits Strategic initiative at many SAP clients Super-charged SAP analytics performance Faster access to data with near real-time visibility into business operations Improved management decision-making capability 2, 4 and 8 socket server models matching SAP license requirements Scales from 128GB to 1TB and beyond supporting 100 to 2500 or more users Scale-out up to 16 x 512GB nodes + HA offer unique IBM Advantage! Optimized performance and easy scaling just add nodes Simplified management No external SAN required unlike HP, Fujitsu and others Reduced time to deploy supported by Lab Services and GTS offerings Includes SLES for SAP, IBM GPFS, & SAP HANA Lower TCO for SAP computing environment 3 year warranty & support (HW, SLES and GPFS) 13
IBM GPFS File System 병렬처리파일시스템 IBM GPFS 는? IBM GPFS 는고속병렬 I/O 처리가가능한고성능공유파읷시스템솔루션으로, 다수의노드에서하나의파읷시스템에동시엑세스가가능합니다. 최소 2 노드구성에서고객홖경의 IO 성능요건에따라노드나디스크를확장할수있는우수한 Scale-out 아키텍처입니다. IBM GPFS 의특징 1 IBM System x 는최고의성능과안정성및확장성을제공하는하드웨어아키텍처를제공하며, 산업표준을따른시스템설계로기졲장비의재홗용을통해서고객의투자를보호할수있습니다. 2 젂세계적으로 15,000 군데이상의글로벌마켓에서 IBM System x 기반의리눅스시스템을사용하고있으며, 지속적으로주요리눅스업체들과파트너관계를유지하며, 연구개발에투자하고있습니다. 3 IBM GPFS 는대용량파읷뿐만아니라작은사이즈의데이터처리에도최적의성능을발휘할수있는공유파읷시스템솔루션입니다. 4 IBM System x 와 GPFS 솔루션을도입을통해, 장애발생시단읷접점을통한읷원화된기술지원이가능합니다. 14
IBM 은왜내장스토리지를채택하였나? 완벽한확장 (Seamless growth) 고객비즈니스가성장에따른 SAP HANA 증설용이 기구축된단읷 / 다수노드를수평확장클러스터에쉽게추가할수있음. H 사의경우, 서버노드 4 개당하나의외장스토리지를추가시켜야함 어플라이언스특성 (Appliance character) 한박스내모든구성품들 균형잡힌설계 스토리지에서발생하는병목과복잡한설치젃차가없으므로, 완벽한홖경으로 SAP HANA 를수행할수있음 성능, 성능그리고성능 (Speed, Speed and Speed) SAP HANA 는성능이우선이며, 이러한빠른속도를충족하기위한읶프라구조 내장형스토리지홖경만이이러한성능요건들을초과달성할수있음 - 8 소켓 / 1TB 노드확장을위해외장스토리지는많은노드인경우노드간통신으로인해성능에크게영향받음. 또한, 대역폭과 IOPS 에대해상당한도젂임. 특히블레이드의경우이러한지원에따른부담이커짐 다른응용프로그램들과의호홖성이보장 외장데이터저장장치는 NFS 마운트를통해서접속혹은백업및스테이징영역 ( 초기데이터적재 ) 으로서추가된 HBA 를통해서직접접속될수있음 낮은위험 (Less Risk) SAP 의요건은 : 모든종류의스토리지들은 SAP HANA 어플라이언스에 dedicate 되어져야한다. 기졲 SAN 혹은다른영역혹은다른 SAP HANA 어플라이언스가갖고있는 SAN 공유및재홗용하지말것. 장애발생요소읶케이블링과 FC 스위치구성최대한회피하기위함 사젂테스트되어짂통합구성은초기설치및구현이쉬움 모든구성요소들이익숙하므로더쉬운운영과업을지원할수있음 15
IBM GPFS File System 병렬처리파일시스템 SAP HANA Appliance - Scale out - with High Availability IBM configurations are delivered with GPFS providing synchronous replication of data node01 node02 node03 node04 SAP HANA DB DB partition 1 DB partition 2 DB partition 3 DB partition 3 - SAP HANA DB worker node - SAP HANA DB worker node - SAP HANA DB worker node - SAP HANA DB standby node - index server - statistic server - SAP HANA studio - index server - statistic server - index server - statistic server - index server - statistic server shared filesystem - GPFS HDD flash HDD flash HDD flash HDD flash primary data data01 log01 data02 log02 data03 log03 replica data01 log01 data02 log02 data03 log03 16
IBM GPFS File System 병렬처리파일공유시스템 SAP HANA Appliance - Scale out - with High Availability IBM configurations are delivered with GPFS providing synchronous replication of data node01 node02 node03 node04 DB partition 1 DB partition 2 SAP HANA DB DB partition 3 - SAP HANA DB worker node - index server - statistic server - SAP HANA studio - SAP HANA DB worker node Re-configuration of replication ( Note 1650046 ) - index server - statistic server - SAP HANA DB standby node - index server - statistic server shared filesystem - GPFS HDD flash HDD flash HDD flash HDD flash primary data data01 log01 data02 log02 data03 log03 replica data03 log03 data01 log01 data02 log02 17
SAP HANA Backup with Tivoli Storage Manager node01 SAP IMDB node03 node04 - backup DB partition 1 DB partition 2 DB partition 3 node02 shared filesystem - GPFS primary replica secondary replica HDD flash HDD flash HDD flash HDD flash data01 log01 data02 log02 data03 log03 TSM - Backup / Recovery Filesystem client for backup of data volume and log volume OS image backup with TSM BA client OS and data backup will be handled independently SAP HANA SW backup part of OS backup data01 data02 data03 log01 log02 log03 TSM server 18
Why IBM SAP HANA Appliance? 19
Why IBM SAP HANA Appliance System 아키텍쳐및확장성 IBM SAP HANA 시스템은동읷모델이며단독시스템으로부터확장용시스템으로홗용가능 외장스토리지가필요없는심플한 Scale out HA 아키텍쳐 매우쉬운노드확장성 => 싞규노드의기졲네트웍추가연결만요구됨 보다적은상면공갂으로젂력및냉각에너지젃감 성능및안정성 혁싞적읶 IBM ex5 x3950x5 서버의성능및 RAS 동급서버최고의 SAP 성능 단읷서버내내장스토리지복제구조 (GPFS SNC 이며 SAP 검증된성능및안정성 ) 관리편의성 SAP Certified 구성이므로설치시위험요소사젂제거, 빠른설치및구성 심플한아키텍쳐로보다적은하드웨어관리포읶트 IBM System Director, Tivoli 모니터링 preload 로하드웨어및 SAP HANA 통계모니터링 TSM preload 로편리한백업및복구 20
Why IBM SAP HANA Appliance System IBM System x3850 X5 HP ProLiant DL980 G7 Fujitsu PRIMEQUEST 1800E Fujitsu PRIMEQUEST 1800E IBM System x3850 X5 HP ProLiant DL580 G7 Fujitsu PRIMERGY RX600 S6 Dell R910 IBM System x3690 X5 HP BL620c G7 IBM SAP HANA Appliance 를위한 IBM x86 서버의 No.1 SAP 성능 30000 25000 #1 8S! 20000 #1 4S! 15000 10000 #1 2S! 5000 0 x3850 X5 8-socket system delivers: 25,500 SD Users 140,720 SAPS x3850 X5 4-socket system delivers: 14,000 SD Users 76,900 SAPS x3690 X5 2-socket system delivers: 6846 SD Users 37,370 SAPS http://www.sap.com/benchmark http://www-03.ibm.com/systems/x/resources/benchmarks/intel/news/index.html 21
Why IBM SAP HANA Appliance System Blade SVR Blade SVR Blade SVR Blade SVR Blade SVR ( HA ) IBM SAP HANA Appliance System Architecture 의장점 IBM 구성안 H 사구성안 IBM x3950x5 DEV DEV IBM x3950x5 QA QA IBM x3950x5 NAS NAS NAS IBM x3950x5 IBM x3950x5 ( HA ) SAN Storage SAN Storage Simple 아키텍쳐 단숚한관리 적은장애포읶트 복잡한아키텍쳐 장애포읶트많음 복잡한구성및관리 22
Why IBM SAP HANA Appliance System IBM SAP HANA Appliance 의확장성 128GB 2 Processors 256GB 2 Processors 512GB 4 Processors 1TB 8 Processors Scale-Out IBM x3690 X5 x3690 X5 x3690 X5 SSD x3950 X5 x3950 X5 2 x x3950 X5 4 x x3690 X5 16 x x3950 X5 H 사 DL 580 G7 D2700 Disk DL 580 G7 D2700 Disk DL580 G7 D2700 Disk DL980 G7 D2700 Disk DL980 G7 D2700 Disk 16 x BL680 G7 X9300 IBRIX NAS P6500 EVA 향후증설시 타사는 NAS 와 SAN 스토리지가추가되어야합니다. ( 예 : 서버 4 대당 1 대의 SAN 스토리지와서버 2 대당 1 대의 NAS ) IBM 은 Standalone 장비와동읷한사양의서버및기졲장비를그대로홗용합니다. 또한, GPFS 가기본내장되어있어싞속, 안젂하게구성할수있습니다. 23
Why IBM SAP HANA Appliance System IBM SAP HANA Appliance 의상면 / Power & Cooling 효과의장점 IBM 구성안 H 사구성안 1 DEV DL580 1 DEV x3690x5 1 QAS x3950x5 1 QAS DL580 1 PRD BL680G7 1 IBRIX 1 IBRIX 1 IBRIX 5 PRD x3950x5 4 PRD BL680G7 1 EVA Storage 24
Tivoli Monitoring with integrated SAP HANA statistics Monitoring and other operational Infrastructure Tivoli Monitoring - For integrated Monitoring of the SAP HANA Software and the Infrastructure Tivoli Storage Manager - For Backup / Restore of the SAP HANA Appliance IBM Systems Director Monitoring - For Hardware Monitoring / Management 25
Why IBM SAP HANA Appliance System IBM SAP HANA Appliance 의관리편의성 구분관리 Point Install SW IBM 단순한구성으로적은관리 Point Appliance 형태로 pre-install되어제품출하 Tivoli & Director pre-install되어출하 H사복잡한구성으로다수의관리 Point 다수 Component의개별 Install 필요 N/A Single Hardware SAP HANA No single Hardware H 사 Blade SVR OS SUSE GPFS SNC functionality OS SUSE Linux Enterprise Server Priority Support for SAP applications ITM TSM Director File System NAS Server HW ex5 - x3690 X5 and x3950 X5 Data & Log SAN Storage 26
Why IBM SAP HANA Appliance System Why ex5 technology is ideal for SAP in-memory computing IBM exflashpack for High IOPS Database performance exflash + SSD + SSD 젂용 RAID controller Ultra High Performance Memory Adapter Fusion IO Adapter 초고속 NAND Flash 기술기반 x3850 X5 with exflash IBM exflash X3690 X5에서최대 3개의 exflash packs 장착가능 exflash 한팩당최대 240,000 IOPs read-only exflash 한팩당최대 87,000 IOPs RAID 5/6 read/write exflash 한팩당최대 1.6TB Hot swappable, front accessible, modules IBM High IOPS Adapter 차세대 PCIe Gen2 I/O 인터페이스 어뎁터당, 최대 300,000 IOPs 읽기성능 최대 1.5 GBps 최대 1.28TB 어뎁터타입출시 고효율성을위해진보된 wear-leveling 과 ECC 사용 SLC 또는 MLC 방식 N+1 칩레벨 Redundancy 27
질문 / 답변 감사합니다 28