오라클데이터베이스클라우드를통한성능극대화및고가용성확보 Jinho Lee Master Principal Sales Consultant Database, Oracle Korea January 19, 2016
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. 3
Agenda 1 2 3 4 5 클라우드시장예측데이터베이스클라우드구축시고려사항클라우드성능극대화및고가용성확보방안레퍼런스및향후전략요약
2025 Cloud Market Prediction 클라우드시장예측 1 2025 년까지 80% 어플리케이션이클라우드에탑재 클라우드시장예측 2 2025 년까지 SaaS 시장의 80% 를 2 개회사가점유 클라우드시장예측 3 2025 년까지 100% 의개발 / 테스트계가클라우드구동 Total Public & Private Cloud Markets (US$ billions) 현재어플리케이션시장의 24% 가퍼블릭클라우드에서구동 새로운어플리케이션의약 85% 가 SaaS 아키텍처에준하여개발중 SaaS Market in 2025 엔터프라이즈시장에는 100 여개이상의다양한 SaaS 어플리케이션을필요로함 어플리케이션간의공유, 확장이가능해야만비용과통합복잡도를줄일수있음 New Dev/Test in Cloud 2025 년까지 100% 의개발 / 테스트계가클라우드에서구동될것으로예측함 개발 / 테스트계는전체 IT 예산의 30~40% 차지 5
2025 Cloud Market Prediction 클라우드시장예측 4 2025 년까지엔터프라이즈데이터의대부분은클라우드에저장 클라우드시장예측 5 2025 년까지가장안전한 IT 환경은클라우드환경이될것이고그중심에는오라클이서비스를제공 PBytes of Storage Installed 현재 IT 인력의약 74% 가 3 개월이상을패치적용에소비중 2014 년기준 99.9% 의인프라가 1 년간패치가미적용된채로운영중 클라우드상에서저장되는데이터가이미기하급수적으로증가하고있음 수천만 IoT 디바이스에서생산되는대량의데이터가클라우드어플리케이션에저장중 오라클은보다빠른통합패치를적용하여, 완벽히암호화된클라우드네트워크환경및패치를지원 6
엔터프라이즈데이터베이스 OLTP High Performance OLTP Data Warehouse In Memory Analytics General Purpose Dev/Test Scale-Up & Scale-Out High Availability Disaster Recovery Change Data Capture Backup 클라우드에서는 30 가지이상의연관서비스및인프라조합이필요 7
데이터베이스클라우드구축에따른문제점 클라우드전용아키텍처, 소프트웨어및스킬필요 On Premises Cloud 제한된성능의인프라 엔터프라이즈클래스서버및스토리지부재 제한된확장성 데이터베이스확장성결여 생소한데이터관리 Open Source(No-SQL, Hadoop) Cloud 용 SQL, API Cloud Vendor Lock-In 과도한클라우드로의이전비용 8
데이터베이스클라우드서비스전환전략 Multitenant 기반의 Hybrid Cloud On Premises 동일한 Hybrid 아키텍처 Cloud 동일한소프트웨어동일한스킬 Oracle Cloud 9
Oracle Database Cloud : 비즈니스규모따른확장제공 Free Multitenant & Standard Enterprise Exadata Database Development SMB & Departmental Apps Enterprise Apps Mission Critical Workloads & Database Consolidation 10
Oracle Database Cloud 성능극대화기능들 Standard Edition Enterprise Edition EE High Performance EE Extreme Performance Adds all 11g or 12c Enterprise Edition features Adds most 12c EE options Adds all 12c EE options Full database instance* Limited to 16 OCPUs Transparent Data Encryption Data Guard All standard EE features Multitenant Partitioning Advanced Compression RAC RAC One Node In Memory Advanced Security, Label Security, Database Vault Real Application Testing OLAP, Analytics, Spatial and Graph Active Data Guard Management Packs * 12c Planned for a future release. 11
오라클데이타베이스통합에따른리소스 메모리, 프로세스, 데이터베이스파일공간소모 System Resources ERP CRM DW 12
Oracle Database 12c Multitenant 아키텍처 컨테이너레벨에서의메모리와프로세스관리 System Resources ERP CRM DW ERP CRM DW 13
12c Multitenant 아키텍처의특장점 Peak 타임과여유시점의공유 Legend HR OE AP 각자구성된환경 통합환경 14
클라우드로손쉬운마이그레이션 데이터베이스를손쉽게플러그 - 아웃, 플러그 - 인수행 GL OE AP GL Master GL (Dev1) GL (Dev2) On-Premises Container Database Cloud-Based Container Database 15
Multitenant 를통한 CapEx 와 OpEx 의절감 Cloud Scale Operations Agility Software as a Service Manage many as one Rapid provisioning and cloning Instant SaaS architecture CPU and I/O management Unplug/plug databases No application changes required 16
메모리데이터베이스성능고려사항 저장방식에따라너무상이한성능효율 OLTP Row Store Database Column Store Database OLTP Analytics Analyze & Decide Analytics 17
ORACLE 의재아키텍쳐링 : Dual Format Database OLTP 와 OLAP 업무형태모두를지원하는유일한 in-memory DB Normal Buffer Cache In-Memory Format 100x 빠른질의 : Real-Time Analytics Mixed Workload OLTP Analytics Oracle Optimizer SALES Row Format 자동반영 실시간 & 일관성 SALES Column Format 빠른 OLTP Mixed Workload 처리 Transparent : 애플리케이션변경불필요 기존과동일한 Disk 기반아키텩처 Row 포맷과 Column 포맷으로동시에저장 / 관리 Oracle DB Read/Write SALES 적재 백그라운드프로세스 18
Oracle Real Application Clusters 서비스 37 년의데이터베이스혁신 수많은 Mission Critical 업무에서검증된기술들 수직성능확장 수평성능확장 (Scale Out) 엔터프라이즈고객이가장선호하는오라클데이터베이스최고솔루션인 Real Application Clusters 를클라우드에서업계최초로제공 * 기업수준의비즈니스보호 동적성능확장제공 무중단유지보수 2 노드환경제공 Extreme Performance 라이선스필요 무중단 DB 서비스 무중단 19
Oracle Database Cloud - RAC 기능요약 2 노드데이터베이스클러스터환경제공 Scale Beyond Single Instance 단일 VM processor, memory 및 IO 리소스한계극복 Database High Availability 인스턴스장애에대한서비스보호 Automated, Rolling Patching OS, 데이터베이스의무중단유지보수 Simple Provisioning 수십분내에 RAC 데이터베이스구성완료 Integrated Management 온프레미스와동일한스킬, 소프트웨어및빌트인툴 20
Oracle Database Cloud - RAC 아키텍처 기본제공아키텍처및구성환경정보 Cloud Portal (UI) EM Express or On-premise EM CC OPC Infrastructure VM RAC GI RDK VM RAC GI RDK OPC 인프라스트럭처 기존 Cloud Portal (UI) 을통한동일한관리 RAC 전용특수인프라환경에서제공 RAC 구성정보 2 개의인스턴스환경제공 11g 와 12c Database Version 제공 DB 와 GI(Grid Infra) 이미지동시제공 공유스토리지 : ASM( 공유스토리지관리 ) 과 ACFS( 데이터베이스스토리지 ) 지원 RDK (RAC Database Kit) RAC 전용 CLI(Command Line Interface) RAC 환경에서 DBaaS CLI 를대체하여제공 21
Demo 22
Demo 23
Demo 24
Demo 25
Demo 26
Demo 27
Oracle 12c Active Data Guard 최고의실시간데이터베이스재해복구솔루션 Production Site (Active) Disaster Site (Active / Read Only) Oracle Instance SGA(In Memory) Oracle Active Data Guard Oracle Instance SGA(In Memory) 높은활용도및 ROI Redo Buffer Redo Buffer 무중단재해복구 메모리의 Redo 바로전송 ( 블록오류검증및복구 ) Storage Storage 읽기전용업무에활용 스토리지복제 운영업무분할및대체 보고성업무및백업등 데이터파일 리커버리파일 많은양의변경사항복제 ( 블록오류를그대로전파 ) 데이터파일 리커버리파일 28
Oracle GoldenGate Cloud Service (GGCS) Architecture On Premise Same Architecture Same Software Same Skills GoldenGate Database as a Service GGCS Database Cloud Service Cloud Source System (On Premise) GGCS - Replication VM (OC5) Target System (Cloud) Extract Oracle GoldenGate Trail Files Pump TCP/IP Trail Files Oracle GoldenGate Replicat Lightweight Streaming API Integrated Mode OCPU 4 Transaction Log (Redo/Archive Log) GGCS Total Memory Usable Local Storage 31GB 1TB Database Cloud Service Exadata Cloud Service 29
Oracle Database Cloud MAA 빅픽처 클라우드로의재해복구환경구축및업무분산에활용 Cloud A Cloud B 향후클라우드솔루션지원 계획 RAC Data Guard Clone & Backup Active Data Guard Oracle Golden Gate Oracle Cloud Primary Database Golden Gate Backup Oracle Cloud Standby Database 서비스활용방안 서비스고가용성확보 서비스성능확장성확보 업무분리및다양한토폴로지제공 On-Premise Primary Database Reporting 30
Oracle Database Exadata Cloud Service Revenue 전세계, 전산업으로빠르게확산되어 고르게분포 RAC 이후로가장지속적으로 성장하는오라클솔루션 Customers OLTP 및 Mixed Workload 로사용 영역이확대 30% 의매출이기존고객으로부터 재발생 31
Exadata Unique Smart Platform Software Exadata 만의고유한기능들 Smart Analytics 쿼리를스토리지로 offload 자동으로쿼리를전체스토리지에걸쳐분산처리 100 배빠른분석 Smart Storage Hybrid Columnar Compression 로저장공간을 10 배늘림 Database 와최적화한 Flash Caching 기술로성능및용량을향상 Smart OLTP 최고의 InfiniBand protocol 로 lowest latency, OLTP: 250us IOs Database 에최적화한 flash logging algorithms 을사용한초고속트랜젝션 Flash Cache Writeback Smart Consolidation CPU 부터 Network, Storage 까지워크로드 priority 처리로 QOS 보장 동일하드웨어에 4 배더많은 database 수용 32
Oracle Database Exadata Cloud Service 최고의 Cloud Platform 과최고의 Database 의만남 Oracle Database 의모든옵션기능제공 최상의가용성과가장빠른성능의 Database Cloud Platform Public Cloud Exadata Service 만의장점 Oracle 전문가에의한 Infrastructure 관리 초기투자비용없이, Subscription 방식으로사용료지불 Web 을이용하여빠르고유연한 Provisioning 각업무간의완전한 Isolation 과효율적인 Resource 사용 33
Oracle Database Exadata Cloud Service Allocation Unit: Exadata X5 Quarter Rack OCPUs (min-max) 1 28-68 Total Memory PCIe Flash Usable Storage 2 Max DB size 3 1/2 TB 19.2 TB 42 TB 16.8-33.6TB 1. OCPU = Oracle CPU = 1 usable compute core 2. High-redundancy mirroring 적용. Database compression 미적용 3. DATA and RECO disk groups 제공된뒤실제공간은 local backup 공간에따라달라짐 대용량미션크리티컬업무운영가능 대규모웨어하우스, 대용량 OLTP, 통합 SNS, 클라우드상에서발생하는대용량데이터분석 Exadata Cloud Service 최소단위 28 OCPU ( 필요에따라추가가능 ) 42 TB 의 Storage 제공 Version Oracle Database 11.2.0.4 / 12.1.0.2 Grid Infrastructure 12.1.0.2 34
Oracle Database Exadata Cloud Service Spec Oracle Database Cloud Edition X5-2 Quarter Rack X5-2 Half Rack X5-2 Full Rack Exadata Extreme Performance Exadata Extreme Performance Exadata Extreme Performance Configuration Option Min Max Min Max Min Max Database Grid OCPUs (a few for Dom0) 28 68 56 136 112 272 Total Memory (GB) (256 max per node) Total 496 GB Total 992 GB Total 1,984 GB Raw Flash Capacity High Capacity 19.2 TB 38.4 TB 76.8 TB Raw Storage Capacity HC Storage 144 TB 288 TB 576 TB Usable Storage Capacity High Capacity 42 TB 84 TB 168 TB Storage Servers 3 6 12 Database Servers 2 4 8 노드또는 VM 당 248 GB 메모리제공 노드당 40% core 로최소 CPU 구성을허용함 고정된스토리지용량제공 (3 중미러링 ) 35
Oracle Database Cloud Service Portfolio 고성능, 고가용성엔터프라이레벨클라우드서비스의필요성 On-Premise find explore transform discover Business Analysis Performance Analysis Log Analysis 36
Oracle Database Cloud Complete Echo System Multitenant DevOps 3 rd -party Workload OPC PaaS/Saas Java WebLogic Oracle Workload Partitioning Advanced Compression Advanced Security, Label Security, Database Vault Real Application Testing OLAP, Analytics, Spatial and Graph Management Packs RAC RAC One Node In Memory Active Data Guard 37
Oracle Database 12c Designed for the Cloud Oracle Multitenant Database 를통한 50% 이상의 CapEx 및 Opex 절감효과 Release 12.1 252 PDBs per CDB CPU and I/O Management Fast provisioning and cloning Unplug/plug databases Instant SaaS architecture No app changes required Cloud Scale Operations Agility Software as a Service 38
Multitenant : Oracle Database 12c Release 2 Cloud Scale Operations Agility Software as a Service Release 12.1 252 PDBs per CDB CPU and I/O Management Fast provisioning and cloning Unplug/plug databases Instant SaaS architecture No app changes required Release 12.2 4096 PDBs per CDB Memory management Hot cloning and refresh Online tenant relocation Shared application objects Online tenant relocation 39
In-Memory : Oracle Database 12c Release 2 Real Time Analytics Performance Simple to Implement Release 12.1 OLTP and analytics on same data in same database Sub-second reporting and analytics No application changes, set one parameter and identify tables Release 12.2 Offload analytics to Active Data Guard standby 3X faster joins, 10X faster expressions, 60X faster JSON SQL in Silicon Dynamic data movement between storage and memory 40
SaaS, PaaS, IaaS 통합솔루션제공 엔터프라이즈레벨확장플랫폼제공 향후클라우드로의시장전환리드 CLOUD On premise는물론엔터프라이즈레벨로확장가능한클라우드서비스를제공하는유일한 IT 벤더 41