ioug collaborate 2014 dbaas in a dbas world

DBaaS in a DBAs WorldKellyn Pot’VinConsulting Member of EM Technical TeamStrategic Customer Program


Oracle Confidential

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.


Program Agenda

Why Database as a Service

What is DBaaS

Understanding the DBaaS environment– Infrastructure as a Service

– Platform as a Service

– Database Templates and Profiles


What is DBaaS?

Database as a Service (DBaaS) is an architectural and operational approach enabling DBAs to deliver database functionality as a service to internal and/or external customers

Including: Customer side provisioning and management of database instances

available to the customer via a self-service portal. Automation of many manual tasks that remove the DBA from work to

provide more value to the business and to the DBA. Added features such as automated schema refresh, “Snapclone” features

and chargeback for cloud environments.

Database as a Service is full featured!


It Can’t Possibly Happen…

http://petewhodoesnottweet.com/2013/11/01/em-hits-a-million/

http://petewhodoesnottweet.com/2013/11/01/em-hits-a-million/


Why DBaaS?

DBaaS standardizes and optimizes the platform requirements which eliminates the need to deploy, manage and support dedicated database hardware and software for each project’s multiple development, testing, production, and failover environments.


DBaaS Architecture

DBaaS architecture is inherently designed for elasticity and resource pooling. They deliver production and non-production database services that support average daily workload requirements and are not impacted by:

Resource Limitations Time Sensitive Projects Hardware limitations/budgets


The Time is Now

"Database as a Service (DBaaS) is arguably the next big thing in IT. Indeed, we project an astounding 86% cumulative annual growth rate, with annual revenues from DBaaS providers rising from $150 million in 2012 to $1.8 billion by 2016.” - 451research.com


Embracing DBaaS as a DBA

The Great DBA…

• Automates everything

• Desires new learning opportunities

• Desires a secure, controlled setup for a self-service portal

• Approaches challenges and answers with simple, robust options to answer.

• Needs a feature set that supports various platforms.

DBaaS OFFERS THIS!..


Services Options in DBaaS


Summary of Moving Parts

How much do you already use in your everyday DBA work

How can this be used to create a new and better way to automate resource allocation so the DBA can do more with less?

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 1217 17

How Much You Can Do With DBaaS

Schema as a Service, (SaaS) New Optimizations with Real Application Testing Ability to add data-masking Ability to automate preliminary and post scripting options. Full-feature chargeback scenarios


Schema as a Service

Datapump of Schema


Schema as a Service

Datapump of Schema

Target Database

Service Template

Import with Objects, no data


Schema as a Service

Datapump of Schema

Target Database

Service Template

Import with Objects and Data

Service Template

Import with Objects, no data


Schema as a Service

Need a schema refresh? Need a copy of a schema, no data?

All of this can be requested with the creation of a template made available to the self-service portal!


Making a DBaaS Snapclone


The Self Service Portal


Self Service Storage Use

• Storage Allocated• Memory Used of Total Allocated• Databases Allocated• Schemas Allocated

All in easy to scan dashboard in main page.


Database View


Submitting a Request


Completed Request, Ready to Submit

Request a copy of a database? A simple request via a DBaaS profile and template with the EM12c and

Database as a Service!


Self Service Template View


Snapclone “Flashback”

• Scan forward, backwards in Snapshot view.

• Choose what snapshot you wish to restore, click on restore or remove from environment.


Storage View


Database Drilldown


Space Hogs

Data Resource Consumption Traditional Cloning Methods vs. Snapclone DBAs no longer the ones requesting storage so often.


Licensing

There are licenses that are required as part of the DBaaS as a service product. • Cloud Management Pack for Database• Database lifecycle Management Pack• Storage Licenses

• Depending on what storage that you choose to house your DBaaS storage pools/IZone will decide what licensing will be required.

• Oracle Database 12c Multi-Tenant Option• If you are using PDB DBaaS, (Pluggable Database, and Database as

a Service) then you will need to license the pluggable databases.• Your Oracle Sales representative can offer the most up to date information

on licensing and pricing.


Plug-ins

Oracle Consolidation Planning and Chargeback(oracle.sysman.emct) Oracle Storage Management Framework(oracle.sysman.smf) Oracle Cloud Application(oracle.sysman.ssa) Oracle Vitualization(oracle.sysman.vt) Oracle Exadata(oracle.sysman.xa) Oracle Database Pluggable DB(oracle.sysman.db)


Database Cloud

From the Middleware and Database Cloud Home:• Create PaaS Infrastracture

Zone to use IaaS


Rapid Start Kit

The DBaaS Rapid Start Kit simplifies the creation steps for the database pools, zones, service templates and self-service users.

The Rapid Start Kit consists of a set of Python scripts which call EMCLI commands and a setup of XML config files.

The kit includes a complete solution for setting up an Out of the box DBaaS platform and allows administrators to integrate their DBaaS setup with scripts and third-party solutions with ease.


Manual Design of Storage, (PaaS/IaaS)

1. Registering Storage

2. Creating the Platform as a Service, (PaaS)

3. Utilizing PaaS to create the PaaS Infrastructure Zone, (I Zone)

4. Rapid Start, (aka, Zero to Cloud) is recommended to use instead.


EM12c- Setup Menu


Step 1- Register Storage


Storage Registration


Settings for Storage

• Setting up IaaS Storage• Allocate amount of space required for DBaaS environment


Self Service Portal Settings


Database Profile- Control is in Your Hands


Request Settings


Quotas for Requestor

Quotas dictates how many resources overall a user of the Self Service Portal has.Allocated by Role and assigned to user-• Memory• Storage• CPU• How many Databases at a given time• How many schemas


DBA Controls Quotas

Quotas can be edited at any time and set to any configuration.


A Closer Look- DBaaS Catalog


A Closer Looks- Templates


Control of Template Resources

Set Parameters Turn on Auditing Configure values for memory, recovery and undo Decide if the SSA Admin has ability to edit values


Custom Script Option

Run Custom scripts as part of templates*This is also part of Schema as a Service


EM12c- Enterprise Menu


Chargebacks

Chargebacks allows Information Operations to charge for IT resources

utilized by a consumer.


Plans for Chargebacks


Monitoring Chargebacks

Monitoring Dashboard for the Cloud Administrator Charge Plan Setup


Cloud Administrator’s Interface

The DBA or “Cloud Administrator” is offered a robust and clean view of DBaaS resource usage as part of EM12c.


The Future

Using VMs from third party vendors, create large, private clouds for use with DBaaS.

Simplify Development, Test, QA requests for database refreshes, new environments

Simplify cloning procedures for any environment Supply afterhours support and maintenance automation.


You can find me at….

Twitterhttp://twitter.com/dbakevlar

Linked Inhttp://linkedin.com/in/kellynpotvin

My bloghttp://dbakevlar.com

About Mehttp://about.me/dbakevlar

[email protected]

http://twitter.com/dbakevlar

http://twitter.com/dbakevlar

http://www.linkedin.com/in/kellynpotvin/

http://dbakevlar.com/

http://about.me/dbakevlar

ioug collaborate 2014 dbaas in a dbas world

Documents