aujourd’hui la consolidation de bases de données oracle c’est quoi ?

Database as a Service

Emiliano Fusaglia Principal Consultant LS-IMS

The next generation of database infrastructure

#SDF16

Agenda

1. IntroductionWhat is Database as a ServiceDBaaS vs Traditional Database Architecture

2. DBaaSOption 1 - VirtualizationOption 2 - Grid Infrastructure & Multitenant Database

3. ConclusionDBaaS Takeaway

#SDF16

Introduction

#SDF16

What is Database as a Service?

DBaaS is a Cloud base approach to manage databases, the database functionality is delivered as a service to one or more consumers, masking all complexities.

A successful implementation has to satisfy the following characteristics:

Flexible, scalable, secure and on-demand platform, oriented to the self-service.

Consolidated database environment with mutualized HW & SW resources .

The Platform Governance among other functionalities includes: Lifecycle management, Capacity Planning and Capacity Management.

Industrialization and automation of the repeatable tasks.

Optimized Time-to-market.

Cost Efficiency.

#SDF16

DBaaS vs Traditional Database Architecture

Major differences between the two solutions.

#SDF16

Traditional DB Strategy VS DBaaS

DBaaS vs Traditional DB Architecture

Sales ERP CRM

HRDWH Web

Commodity HW leveraged by SW redundancy and HW consolidation

Expensive dedicated Servers offeringHW redundancy

#SDF16


DBaaS vs Traditional DB Architecture – Handling Resource

Sales ERP CRM

HRDWH Web



#SDF16

DBaaS vs Traditional DB Architecture – Handling Failure

Sales ERP CRM

HRDWH Web




#SDF16

CRM

WWWCRM

Not ScalableArchitecture

ScalableArchitecture

80% busy

80% busy

DBaaS vs Traditional DB Architecture – HW Scalability


#SDF16

DBaaS

#SDF16

DBaaS Option 1Virtualization

#SDF16

DBaaS on Virtualized Environment

Shared Storage

#SDF16

DBaaS on Virtualized Environment

Pros ConsStandard architecture for all SW components.

Licensing restrictions with Oracle products.

Native scalability, flexibility and high availability.

I/O performance degradation for high demanding databases.

Rapid VM provisioning operations.

Increased troubleshooting complexity.

Suitable to industrialization and automation.

DBAs delegate to System Admins critical database tasks: resource management, high availability, scalability and capacity planning.

#SDF16

DBaaS Option 2Grid Infrastructure & Multitenant Database

#SDF16

Grid Infrastructure Overview

Oracle offers great native features to build a DBaaS platform:

Grid Infrastructure: ASM & CRS provide solid storage and clustering foundation to the database infrastructure at no-additional-cost.

RAC & RAC One Node: introduce high availability, scalability and operation flexibility.

Resource Manager and Instance Caging: guarantee capped resource consumption, and performance stability.

Quality of Service: real time performance analysis, prioritizing the most strategic services and assuring predictable performance for consolidated applications.

Multitenant: designed for high consolidation density and cloud environments.

#SDF16

Grid Infrastructure Overview

#SDF16

Oracle Multitenant Database – Many as One

11

PMON SMON LGWR DBW0 DIAG …

SYSTEM SYSAUX REDO CTLUNDOCDB$ROOT

[RW]

TEMP

SYSTEM SYSAUX TEMP

PDB$SEED [RO]

CRM01 [RW]

SYSTEM SYSAUX TEMP

FA01 [RW]

SYSTEM SYSAUX TEMP

CRM DBA

CDB

DBA

FA DBA APP DBA

Application Tablespaces

Application Tablespaces

Source: Trivadis Course Oracle 12c New Features

#SDF16

Local PDB Provisioning

11


CDB$ROOT[RW]

PDB$SEED[RO]

CRM[RW]

COPY

Local Copy of PDB$SEED

CDB$ROOT[RW]

CRM01[RO]

COPY

CRM02[RW]

Local Copy of Application PDB

#SDF16

Remote PDB Provisioning

11


CDB$ROOT[RW]

CRM02[RW]

FA02[RW]

CDB$ROOT[RW]

CRM01[RW]

FA01[RO]

COPY via Oracle Net Services

CDB 1 CDB 2

#SDF16

Local PDB Provisioning with Snapshot Copy

11



CDB$ROOT[RW]

Local Copy of Application PDB using Snapshot Copy (available on ACFS, ZFSSA and NetApp). …SQL> CREATE PLUGGABLE DATABASE crm02 FROM crm01 SNAPSHOT COPY;Pluggable database created.

SQL> ALTER PLUGGABLE DATABASE crm02 OPEN READ WRITE;Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE crm01 CLOSE;Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE crm01 OPEN READ WRITE;Pluggable database altered.

CRM01[RO]

CRM02[RW]

Snapshot COPY

#SDF16

Grid Infrastructure & Multitenant improve IT efficiency 1/2

Database storage consumption on most of today’s enterprises.

Production DR

Backup

Reporting UAT Test Development

Data production copy available for reporting

…

Backup Each database requires8x of DB Storage Space

Anonymized Production data

#SDF16

Grid Infrastructure & Multitenant improve IT efficiency 1/2

Optimization of database storage consumption using Oracle DBaaS setup.

Production DR

Backup

Reporting UAT Test Development

Snapshot Copy of production data accessed for reporting

…

Backup

Snapshot Copy of UAT

Snapshot Copy of UAT

Each database requires 3x of DB Storage Space +DB Snapshots

Anonymized Production data

#SDF16

Conclusion

#SDF16

DBaaS Takeaway

From the provisioning phase to the decommissioning one, the DBaaS offers great advantages:

The consolidated platform permits all applications benefitting of the same features, reducing time-to-market and increasing efficiency, performance and availability.

No waste of resources avoiding fragmentation and low level of utilization.

Great vertical and horizontal scalability.

Ideal setup to enforce standardization, industrialization, security and automation.

The DBaaS platform offers “engineered & built once, use many”.

Pay-as-you-Grow Architecture.

#SDF16

Emiliano FusagliaPrincipal Consultant

#SDF16

Confirmez votre présence et évaluez la session avec ce QRC. Un vol en montgolfière à gagner !

aujourd’hui la consolidation de bases de données oracle c’est quoi ?

Data & Analytics