Database As A Service using Enterprise Manager 12c

Size: px

Start display at page:

Download "Database As A Service using Enterprise Manager 12c"

학철 창
5 years ago
Views:

1 Oracle Database Cloud Management with Oracle EM12c RaeSung Park Enterprise & Cloud Management Solutions Oracle 1

2 Program Agenda Oracle Private Cloud 전략 Database as a Service (DBaaS) Oracle EM12c for DBaaS Customer Proof Points 2

3 Everyone Is Talking About Cloud 3

4 Cloud Computing 의정의 Cloud computing is a model for enabling convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction. This cloud model promotes availability and is composed of: 5 Essential Characteristics On-demand self-service Resource pooling Rapid elasticity Measured service Broad network access Source: NIST Definition of Cloud Computing v15 3 Service Models SaaS PaaS IaaS 4 Deployment Models Public Cloud Private Cloud Community Cloud Hybrid Cloud 4

5 Cloud Computing : Oracle Perspective 적용가능하고새로운기능을검증된기술기반하에구현 효과대비잠재적이슈고려 Public cloud 와 private cloud 가혼합된형태의엔터프라이드 cloud 환경 5

Application 모두지원 Private cloud 를구축하기위한기술을제공하거나 public cloud 홖경에서서비스제공 Public

6 Cloud Computing : Oracle Strategy 엔터프라이즈급의 Cloud Computing 지원 Public cloud 와 private cloud 를모두지원 : 고객의선택존중 Private 공유서비스홖경에구성된 Application 이나 public SaaS 를 Application 모두지원 Private cloud 를구축하기위한기술을제공하거나 public cloud 홖경에서서비스제공 Public Clouds SaaS PaaS IaaS I N T E R N E T I N T R A N E T Private Cloud SaaS PaaS IaaS 사용자 6

7 Why : Enterprise Private PaaS Why Cloud? - 민첩성, 속도 - 효율성과비용 Why Private? - 보안 - 컴플라이언스 - 제어 (particularly over QoS) - 기존지식과실행력홗용 Built by user IaaS PaaS PaaS Built by user Provided by IT Why Platform? - 컴포넌트의재사용성극대화 - 어플리케이션코딩작업의최소화 - 유연성과제어능력극대화 Provided by IT IaaS 7

What : Oracle Cloud Platform for PaaS Application 1 Application 2 Application 3 Integration: SOA Suite Platform as a Service Shared Services Process Mgmt: BPM Suite Application Grid: WebLogic Server,

8 What : Oracle Cloud Platform for PaaS Application 1 Application 2 Application 3 Integration: SOA Suite Platform as a Service Shared Services Process Mgmt: BPM Suite Application Grid: WebLogic Server, Coherence, Tuxedo, JRockit Database Grid: Oracle Database, RAC, ASM, Partitioning, IMDB Cache, Active Data Guard, Database Security Operating Systems: Oracle Enterprise Linux Virtualization: Oracle VM Servers Storage Security: Identity Mgmt Infrastructure as a Service User Interaction: WebCenter Cloud Management Oracle Enterprise Manager Lifecycle Management Configuration & Compliance Application Performance Management Application Quality Management 8

Private PaaS LifeCycle 3. 어플리케이션사용 4. Scale up/down 2.

using shared components Deploy through self-service 어플리케이션개발 어플리케이션사용자 App 어플리케이션

Cloud 환경구성 IT Set up PaaS Set up shared components Set up self-service portal 공유컴포넌트

9 Private PaaS LifeCycle 3. 어플리케이션사용 4. Scale up/down 2. 어플리케이션작성 Adjust capacity based on policies Monitor via self-service Assemble app using shared components Deploy through self-service 어플리케이션개발 어플리케이션사용자 App 어플리케이션 Owner 5. Chargeback Meter usage and charge back to app owners or departments 1. Cloud 환경구성 IT Set up PaaS Set up shared components Set up self-service portal 공유컴포넌트 Oracle Fusion Middleware Oracle Database Oracle Enterprise Linux Oracle VM Self-Service Interface Oracle Enterprise Manager 9

10 Program Agenda Oracle Private Cloud 전략 Database as a Service (DBaaS) Oracle EM12c for DBaaS Customer Proof Points 10

11 Why Database as a Service? IOUG Cloud Computing Survey (2011) 통합을통한비용절감 63% 표준화를통한운영효율성으로비용절감 54% 보안과정보보호에대한더나은제어 Showback / Chargeback 새로운어플리케이션을빠르게제공하여비즈니스에민첩하게대응 39% 37% 33% 데이터베이스플랫폼에대한자동화되고최적화된서비스요청 11

Database as a Service Database as a Service 제공내용 데이터베이스서비스를전개할수있는공유되고통합된플랫폼 셀프서비스모델기반으로제공 데이터베이스자원에대한탄력적인 scale out 및 scale back 데이터베이스사용량에기반한

12 Database as a Service Database as a Service 제공내용 데이터베이스서비스를전개할수있는공유되고통합된플랫폼 셀프서비스모델기반으로제공 데이터베이스자원에대한탄력적인 scale out 및 scale back 데이터베이스사용량에기반한 Chargeback Database as a Service 홗용사례 개발이나프로젝트에서 seed 데이터포함여부에관계없이새로운데이터베이스서비스요청 QA 짂행시로드테스팅을위한데이터베이스전체제공 QA 수행시개별적인기능테스팅을위한부분데이터를포함한복수개의데이터베이스제공 12

13 Database as a Service : 활용사례 1. Seed 데이터를포함하거나포함하지않은상태의새로운데이터베이스서비스요청 서비스요청자가필요한데이터베이스를가상머신혹은물리적인장비에전개 Pros: Resource isolation, ideal for enterprise applications like ERP Cons: VM and database sprawl, administrative overheads, compliance challenges 서비스요청자가데이터베이스내에데이터베이스스키마를전개 Pros: High consolidation, minimal administrative and maintenance overhead Cons: Limited isolation 2. 테스팅을위해기존데이터베이스복제에대한서비스요청 서비스요청자가데이터베이스에대한전체복제수행 Pros: Ideal for load-testing with significant data updates Cons: Time and space consuming 서비스요청자가데이터베이스에대한부분복제수행 ( Copy On Write ) Pros: Minimal additional space, instantaneous cloning, ideal for functional testing Cons: Reduced benefits in case of significant data updates 13

14 Database as a Service : 핵심요소 1. Consolidation 공통인프라상에서데이터베이스워크로드를통합 2. Standardization 다양한구성요건을수용하여표준화된데이터베이스체계로정립 3. Automation 요청에빠르고자동적으로대응하여데이터베이스서비스를제공 4. Showback/Chargeback 사용량을측정하고관리 14

15 Program Agenda Oracle Private Cloud 전략 Database as a Service (DBaaS) Oracle EM12c for DBaaS Customer Proof Points 15

16 DBaaS : 1. Consolidation Oracle Enterprise Manager 제공기능 통합대상자원자동파악및현재사용량기준에대한다양한데이터 physical-to-physical, physical- to-virtual 그리고 physical-to-exadata consolidation 에대한가이드제공 기술적인측면과기능적 / 비즈니스적인측면의고려사항포함 다양한통합사용모델제공 Shared Server, Shared Cluster 그리고 Shared Database Shared Cluster 와 Shared Database model 에는 Exadata 로의물리적통합모델에대한추가가이드제공 16

ERP CRM OS OS Hypervisor OS OS OS OS OS Dedicated VM Shared pool of hypervisors 비교 - Amazon

17 DB DB DB DB DB DB DB DBaaS : 1. Consolidation 모델 Infrastructure Cloud Database Cloud Database Cloud DW CRM ERP DW ERP CRM DW ERP CRM OS OS Hypervisor OS OS OS OS OS Dedicated VM Shared pool of hypervisors 비교 - Amazon EC2 Dedicated Database Shared pool of servers/clusters 비교 Amazon RDS Oracle Public PaaS 통합정도 Dedicated Schema Shared Database Schema 레벨통합 ( 주로업무통합성프로젝트 ) 17

18 DBaaS : 1. Consolidation 모델 Dedicated VM (Shared pool of hypervisors) Dedicated database (Shared pool of servers/clusters) 구현난이드쉬움쉬움 Dedicated schema (Shared Databases) 어려움 (DB 및 OS 버젼표준화 ) 적용대상어플리케이션 일부모두 Home grown 어플리케이션 독립성뛰어남좋은편임낮음 집적도 낮음 ( 서버, 스토리지 ) 높은편임 ( 서버, 스토리지, OS) 가장높음 ( 서버, 스토리지, OS, DB) ROI 낮음높은편임가장높음 관리편의성용이용이복잡 18

19 DBaaS : 2. Standardization Oracle Enterprise Manager 제공기능 자원풀기능을통해동일한구성을가짂데이터베이스들을묶음 자원의통제관리기능강화 (Governance) - 사용용도및구성에기반한관리정책 - 접속제어, 할당량, 제거정책 데이터베이스서비스카달로그를제공하기위한워크플로우가이드 19

20 DBaaS : 2. Standardization Governance 표준데이터베이스서비스를제공하기위해동일플랫폼을가짂인프라자원을 Pool 로구성 전개정책및 Pool 에대한권한정의 CPU, Storage, 배치가능한 DB 수량등에기반한 Quota 설정및역할연계 소멸정책관리 (1 개월동안미사용시등 ) 20

21 DBaaS : 2. Standardization Service Catalogue Workflow 서비스템플릿작성 참조시스템을통해골드이미지생성및전개정책에기반한프로세스작성 서비스템플릿별권한사용자할당 사용될서비스템플릿을서비스카달로그로제공 21

22 DBaaS : 3. Automation Oracle Enterprise Manager 제공기능 셀프서비스전개기능을위한 Out-of-box 화면 DBAs, Developers, QA, Project Owner 등의요구에맞게적용 빠르고간편하게전개작업수행 단순데이터베이스전개나개발자를위한스키마전개 업그레이드사전테스팅을위한전체데이터베이스전개 수분이내에많은분량의서브셋데이터복제 RESTFUL API 제공을통해외부툴과의연계제공 22

23 DBaaS : 3. Automation Self Service Provisioning 커스터마이징이용이한 Out-of-box 화면 Self-Service 로 DB 및 Schema Provisioning Schema-as-a-Service 구현 RMAN 을통한 Full database cloning 스토리지의 copy-on-write 기술을홗용한 Database Snap Clone 기능 모니터링, 백업, 패치등을포함하는통합데이터베이스라이프사이클관리 23

Placement 서비스제공에가장적합한대상자동지정 single instance

전개대상데이터베이스 DB/Schema 요청 Current Load Current

DB DB CPU 사용량및메모리할당량확인 (Schema 전개시스토리지사용량확인 )

24 DBaaS : 3. Automation Intelligent, transparent Service Placement 서비스제공에가장적합한대상자동지정 single instance database 용 host multi-instance RAC 용 node schema 전개대상데이터베이스 DB/Schema 요청 Current Load Current Population Placement Policy Constraints 가장적합한대상 DB DB CPU 사용량및메모리할당량확인 (Schema 전개시스토리지사용량확인 ) 데이터베이스별 DB 서비스혹은 Oracle Home 별데이터베이스인스턴스갯수확인 CPU, 메모리, 인스턴스 / 서비스갯수에대한제약조건검증 Host1 Host N Database Pool 24

25 DBaaS : 3. Automation Cloud Service Monitoring 개별클라우드서비스스택에대한모니터링 클라우드서비스사용현황모니터링및관리 서비스시작 / 정지 리소스흐름, 테넌트, 정책위반등추적 요청및실패모니터링, 리소스및용량홗용도관리 25 25

26 DBaaS : 3. Automation Database Cloud Service Monitoring 직관적인성능뷰 짂단보고 리소스사용현황 규제준수 작업관리 경보, 인시던트관리 실시간 SQL 모니터링 26 26

27 DBaaS : 4. Showback/Chargeback Oracle Enterprise Manager 제공기능 다양한과금정책의설정 : 구성홖경에기반한과금정책 ( 파티셔닝여부, RAC 여부등 ) 서버 / 데이터베이스자원사용량에기반한변동과금정책 LDAP 구조를사용한자동 rollup 사용자편의성을고려한역할별 Out-of-box 리포팅 Billing 시스템연계 API 제공 과금정책의설정 과금정책적용 Cost Center 설정 자동과금 27

28 DBaaS : 4. Showback/Chargeback Chargeback Plan Extended Charge Plans 생성 플랜이름입력 파티션옵션조건추가 추가과금내역입력 28

29 DBaaS : 4. Showback/Chargeback Metrics for Chargeback Host VM Dedicated Database Shared Database Fixed Base Charge Base Charge Base Charge Backup Charge Base Charge OS CPU Count Edition / Version Edition / Version Configuration CPU Count Memory Allocated Memory Allocated Storage Size RAC Node Count Option Storage Usage RAC Node Count Option Memory Usage CPU Utilization CPU Utilization CPU Time and Utilization DB Time Per Svc. Usage Memory Used Disk Usage Network I/O Disk Operations CPU Time and Utilization Per Svc. Disk Operations Per Svc. SQL Executes SQL Executes Per Svc. User Transactions User Transactions Per Svc. 29

30 DBaaS : Oracle Enterprise Manager 12c 기능 Self-service provisioning of dedicated databases Self-service provisioning of shared databases Self-service provisioning of schema Full database clone Snap Clone of databases Metering and Chargeback 적용대상 OS 레벨의독립성, 손쉬운배포 데이터베이스레벨독립성, ERP 같은엔터프라이즈어플리케이션용도에적합 통합성이뛰어남, 관리부담감소 업데이트가빈번하거나, UAT 홖경구성에적합 기능테스트를위한데이터베이스복제홖경구성에적합 사용에대한비용및예산책정 30

31 Program Agenda Oracle Private Cloud 전략 Database as a Service (DBaaS) Oracle EM12c for DBaaS Customer Proof Points 31

Proof of Value: 10X Faster Provisioning Multi-Customer Study By Crimson Consulting With Oracle Enterprise Manager 12c we cut the time required to provision our RAC systems in half.

32 Proof of Value: 10X Faster Provisioning Multi-Customer Study By Crimson Consulting With Oracle Enterprise Manager 12c we cut the time required to provision our RAC systems in half. Oracle DBA, telecommunications firm Standardized builds based on Enterprise Manager templates are a massive plus you get fewer error s, lower downtime, fewer infrastructure issues, and Main point faster application development. Oracle DBA, broadcast and telecommunications firm I can give a set of business resources to a business segment and they can be responsible for the capa city that they stand up. Infrastructure team manager, computer tech firm Hours Provisioning Time Before EM12c (hrs) Provisioning Time With EM12c (hrs) DBaaS DBaaS + MWaaS Full App Stack 32

If Database infra not available time taken If Database infra available time taken Post DBaaS implentation using EM 12c Case Study : HDFC Bank Challenges 표준화되지않은수많은데이터베이스 증가및혺재 새로운서비스에대응하기위한

33 If Database infra not available time taken If Database infra available time taken Post DBaaS implentation using EM 12c Case Study : HDFC Bank Challenges 표준화되지않은수많은데이터베이스 증가및혺재 새로운서비스에대응하기위한 데이터베이스준비지연 다양한워크로드에적합한하드웨어 자원의최적화된사용의어려움 해결책 EM 12c 와 Exadata 를홗용한 DBaaS 마우스클릭몇번으로수분이내에필요한데이터베이스준비 300GB 크기의데이터베이스준비소요시간 : 3 시간 Sno List of activity during New DB infra requirement 1 IT team fill tech questionnaire and submit for discussion Discussion and TCO in 3 days from discussion Floating of funding proposal based on TCO Approved funding raising PO for infra procurement Delivery of server and infra structure Asset code allocation and movement to DC OS and other infra configuration Identify server (compute+ memory ) Storage allocation and publishing for new DB instance Database installation and database creation Database restoration OEM or monitoring configuration Total time taken in days /hour Day 56 Day 3.5 Hour 3 10X Fast App Rollout Rapid Consolidation Easier Management 33

Cloud Orchestration Blueprints Oracle Enterprise Manager 12c IaaS DBaaS

정책기반의자원 scale o ut 및 scale back Live migration 및 power management Host 와

통합데이터베이스라이프사이클관리 데이터베이스서비스에대한 Chargeback Schema-as-a-Service Snap Clone

어플리케이션레벨의 s cale out 및 scale back Java 어플리케이션라이프사이클관리 Java 서비스에대한 Ch

34 Cloud Orchestration Blueprints Oracle Enterprise Manager 12c IaaS DBaaS Java-aaS TaaS Oracle VM 에대한 VM template 전개 Assembly 를통한다계층어플리케이션전개 정책기반의자원 scale o ut 및 scale back Live migration 및 power management Host 와 VM level charge back Seed 데이터베이스에대한 Self-Service Provisioning 통합데이터베이스라이프사이클관리 데이터베이스서비스에대한 Chargeback Schema-as-a-Service Snap Clone RMAN 을이용한 Full Cl one Java application 에대한 Self-Service provisi oning 어플리케이션레벨의 s cale out 및 scale back Java 어플리케이션라이프사이클관리 Java 서비스에대한 Ch argeback 테스트수행과정의통합운영 테스트홖경에대한 Se lf-service provisioning 다양한모니터링기능및짂보된분석 Chargeback 및 Meteri ng 34

35 35

Service-Oriented Architecture Copyright Tmax Soft 2005

Service-Oriented Architecture Copyright Tmax Soft 2005 Service-Oriented Architecture Copyright Tmax Soft 2005 Monolithic Architecture Reusable Services New Service Service Consumer Wrapped Service Composite