aws april 2016 webinar series - rds for oracle - quick provisioning. easy management. reduced cost

© 2016, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Chris Richardson, Amazon RDS for Oracle

April 26th, 2016

Amazon RDS for OracleQuick Provisioning. Easy Management. Reduced Cost

What to expect from this Webinar

Overview of AWS and Amazon RDS for Oracle Benefits of Managed Relational Database Services Minimizing Costs and Using Your Oracle Licenses

Introducing Amazon Web Services

“Amazon Web Services is the overwhelming market share leader, with over 10 times more cloud IaaS compute capacity in use than the aggregate total of the other 14 providers.”

Magic Quadrant for Cloud Infrastructure as a Service

Gartner “Magic Quadrant for Cloud Infrastructure as a Service,” Lydia Leong, Douglas Toombs, Bob Gill, 18 May 2015. This Magic Quadrant graphic was published by Gartner, Inc. as part of a larger research note and should be evaluated in the context of the entire report.. The Gartner report is available upon request from Steven Armstrong (asteven@amazon.com). Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

AWS Pace of InnovationNew Service Announcements & Updates

2014201320122011

280

1598261

2010

515

722

2015

The AWS Global Infrastructure

12 Regions WorldwideGeographic areas where AWS services are available

33 Availability Zones (AZs)Multiple, isolated locations within a region

Choose which regions and availability zones to deploy your workloads in.

AWS Services to use when deploying Oracle

If you host your databases on-premises

Power, HVAC, net

Rack & stack

Server maintenance

OS patches

DB s/w patches

Database backups

Scaling

High availability

DB s/w installs

OS installation

App optimization

you

If you host your databases in Amazon EC2

Power, HVAC, net

Rack & stack

Server maintenance

OS patches

DB s/w patches

Database backups

Scaling

High availability

DB s/w installs

OS installationApp optimization

you

If you host databases on Amazon RDS

Power, HVAC, net

Rack & stack

Server maintenance

OS patches

DB s/w patches

Database backups

App optimization

High availability

DB s/w installs

OS installation

Scaling

you

Choosing the right solution for your needs

Amazon RDS for Oracle We recommend you consider

RDS first Focus on tasks that bring value to

your business Focus on high level tuning tasks

and schema optimization Lack of in-house expertise

managing databases

Oracle on Amazon EC2 You need full control over the DB

instances Control over backups, replication

and clustering Use features and options not

available in Amazon RDS Size and performance needs

exceed Amazon RDS offering

Fast provisioningMultiple ways to start and manage your Amazon RDS for Oracle resources

Amazon RDSManagement

Console

AWS Command Line Tools (CLI)

AWS SDKs AWS CloudFormation

templates

Fast provisioning: AWS Management Console

Select Oracle Edition

Tell us your use case

Specify DB Details

Configure Advanced Settings

You’re Done!

Fast provisioning: AWS Command Line Interface

aws rds create-db-instance \--db-instance-identifier ORA-DB-01 \--allocated-storage 200 \--db-instance-class db.m4.4xlarge \--engine oracle-se1 \--license-model license-included \--master-username awsuser \--master-user-password mypassword

Fast provisioning: AWS CloudFormation Templates{ "AWSTemplateFormatVersion" : "2010-09-09", "Resources" : { "DBInstance" : { "Type": "AWS::RDS::DBInstance", "Properties": { "DBInstanceIdentifier" : “ORA-DB-01", "Engine" : “oracle-se1", "LicenseModel" : "license-included", "DBInstanceClass" : "db.m4.4xlarge", "AllocatedStorage" : "200", "MasterUsername" : "awsuser", "MasterUserPassword" : "mypassword" } } }}

Scaling compute and storage on Amazon RDS

ComputeCapabilities

vCPUs

MemoryCapabilitiesGB of RAM

NetworkPerformance

MB/s (Throughput)

StoragePerformance

I/O Throughput

RDS DB Instance Class RDS Storage Type

Range of DB instance classes:From: 1 vCPU and 1 GB of RAMTo: 40 vCPU and 244 GB RAM

Instance class families:General Purpose (M1,2,3,4)Memory Optimized (R3)Burstable Capacity (T2)

Storage types:MagneticProvisionedGeneral Purpose

Simple and fast compute scaling on Amazon RDS

Storage system I/O performance in AWS

Amazon RDS Amazon EC2Type Size Performance Size Performance Burst Capacity Pricing Model

Magnetic Storage 10 GiB–3 TiB ~100 IOPS 1 GiB–1 TiB ~ 100 IOPS Yes, several hundred IOPS

Allocated storage; I/O operations

General Purpose (SSD)

10 GiB–6 TiB(min. 100 GiB advised)

3 IOPS/GiB 1 GiB–16 TiB 3 IOPS/GiB for volumes 1 TiB or less, up to 10,000 IOPS for larger volumes

Yes, up to 3000 IOPS per volume, subject to credits (< 1 TiB in size)

Allocated storage

Provisioned IOPS(SSD)

100 GiB–6 TiB(min. 200 GiB for Standard edition)

Ratio: 3 to 10 IOPS/GiB, up to max. 30,000 IOPS

4 GiB–16 TiB Up to 20,000 IOPS; ratio: 3 to 30 IOPS per GiB

No, fixed allocation

Allocated storage; Provisioned IOPS

High Availability via Amazon RDS Multi-AZAmazon RDS Multi-AZ

Few clicks or One API call

Do It Yourself Oracle

Potentially ~100+ Manual steps

Set up Oracle RAC clusters

Alternatively, set up primary and standby instances using Active Data Guard

Create and manage DNS entries

Detect instance failure conditions

Detect network failure conditions

Detect storage failure conditions

Decide when to fail-over….

Re-establish primary secondary connections.

Taking care of backups and maintenance

Automated or manual backups Restore any backup to a point in time Automated patch management

Cross-Region Disaster Recovery in AWSChoose cross-region snapshot copy for even greater durability, ease of migration Copy a database snapshot to a different AWS Region Restore in the case of a regional disaster Or use it to migrate a database to a different region

Cross-Region Disaster Recovery in AWSReplicate Data Across Regions to have a warm standby ready to fail over to.

Logical replication supported by RDS includes:

AWS Database Migration Service

Oracle GoldenGate

Minimizing Costs and Using your Oracle Licenses

Optimize your Amazon RDS for Oracle spend

Region

Instance Class

Storage type

Multi-AZ

Workload Pattern

Bringing your own license?

Workload Hours Used Per Day

Amazon RDS pricing models compared

Workload Hours Used Per Day

On-Demand Pay by the hour No term commitment

Reserved Instances No-upfront Partial-upfront All-upfront RIs

Reserved Instances (RIs) available for 1 and 3 year termsSave up to 60% over on-demand costs

Pay only for what you useExample: XLarge Oracle dev/test instance used 10 hours each workday

Assumes DB instance accessed only from Amazon EC2Further details at http://aws.amazon.com/rds/pricing/

= $87 / month= 215 hrs * $0.35/hr + 100 GB * $0.115

Monthly Bill

= +

100 GB General Purpose

(SSD)

4 vCPUs 16 GiB RAM

db.m4.xlarge; Oracle EE-BYOL; Oregon; Single-AZ;

On-Demand

Pay only for what you useExample: XLarge Oracle dev/test instance used 24x7

Assumes DB instance accessed only from Amazon EC2Further details at http://aws.amazon.com/rds/pricing/

= $263 / month= 720 hrs * $0.35/hr + 100 GB * $0.115

Monthly Bill

= +

100 GB General Purpose

(SSD)

4 vCPUs 16 GiB RAM

db.m4.xlarge; Oracle EE-BYOL; Oregon; Single-AZ;

On-Demand

Pay only for what you useExample: XLarge Oracle Production instance used 24x7

= $527 / month

= 720 hrs * $0.35/hr * 2 + 100 GB * $0.115 * 2

Monthly Bill

= +

100 GB General Purpose

(SSD)

4 vCPUs 16 GiB RAM

db.m4.xlarge; Oracle EE-BYOL; Oregon; Multi-AZ;

On-Demand

Price includes a High Availability Multi-AZ configuration Assumes DB instance accessed only from Amazon EC2Further details at http://aws.amazon.com/rds/pricing/

Optimize costs by reserving capacityExample: XLarge Oracle Production instance used 24x7

Price includes a High Availability Multi-AZ configuration + 1Y No Upfront Cost Reservation

= $340 / month

= 720 hrs * $0.22/hr * 2 + 100 GB * $0.115 * 2

Monthly Bill

= +

100 GB General Purpose

(SSD)

4 vCPUs 16 GiB RAM

db.m4.xlarge; Oracle EE-BYOL; Oregon; Multi-AZ; 1y No Upfront RI

Oracle License Portability to AWS

All Oracle Software licenses are fully portable to Amazon Web Services EC2 and RDSEnterprise License Agreement (ELA)Unlimited License Agreement (ULA)*Business Process Outsourcing (BPO)Oracle Partner Network (OPN)

Processor & Socket Licensing:Standard Edition Licenses

• 0.25 core multiplier = 1 license for 4 virtual cores (8 vCPUs)Enterprise Edition Licenses

• 0.5 core multiplier = 1 license for 2 virtual cores (4 vCPUs)Standard named user plus licensing applies, including countingthe minimums where applicable

Learn more:Oracle Cloud Licensing Policyhttp://www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdfAWS Virtual Core Tablehttp://aws.amazon.com/ec2/virtualcores/

Thank you!