hybrid cloud transformations - az-ora.org · hybrid cloud what the hybrid cloud mean to you?...
TRANSCRIPT
1
Hybrid Cloud Transformations
Feb 13, 2020
Copyright © 2019 Oracle and/or its affiliates.
Charles Kim
@racdbaCEOViscosity North America
Roman Delino
Regional ManagerOracle Corporation
What’s Keeping You Awake Late At Night?Globally, Business and Technology objectives …
#2 Meeting business goals and objectives
#3
#4 Being over budget
#5
#1 Delivering consistent and stable IT performance to the business
Chasing outages
Keeping up with technology
#6 Retaining the right expertise
Hybrid CloudWhat the Hybrid Cloud mean to you?
• Viscosity’s internal discussion on what our consultants should know about Oracle Cloud
• Viscosity’s response to VMC on OCI and AWS
• Cloud driven
• Health Care customer with a new CIO who mandated that their Exadata workload must go to AWS
• Hybrid Cloud challenges
• Cloud changes every 3-6 months
• Private Cloud • Engineered Systems innovations
• Virtualization improvements• Converged and Hyper-converged
infrastructure
Cost Concerns of going to the cloud• Refresh technology stack every 3-5 years
• Updating antiquated software and hardware
• Training employees• Retaining employees
• Managed Services is a popular model
• Cost of cloud adoption• 3-5 year TCO and ROI• Hidden costs of cloud• Cloud connectivity cost• Egress traffic costs• Multi-Cloud integration
• Migrating to the cloud vendor
@ViscosityNA
Why You Should Consider
Upgrading to Oracle19c
11.2 Premier Support Ended: December 2018
12.1.0.2 Premier Support Ended: July 31, 2019
@ViscosityNA
Oracle 19c - Oracle’s Recommended Roadmap
• Oracle is currently recommending that customers upgrade their databases to Oracle Database 19c
• 19c is the terminal release of Oracle Database 12c Release 2
• 19c is the long-term support or extended support will only be offered on this version
• Customers are still hesitant
• At this time, 19c is still new
• Viscosity does not recommend making this jump yet to our customers
• If you are currently running 11.2.0.4, 12.2.0.1, or 18c, please upgrade to 19c before the error correction grace period
expires
• Extended support will not be available for 12.2.0.1or 18c releases.
• Oracle Database 19c will have premier support up to March 31, 2023.
• Extended support will be provided until March 31, 2026.
• As a reference, always check MOS Note 742060.1 for the latest schedule
@ViscosityNA
RISK OF NOT UPGRADING TO ORACLE 18C
ORACLE 12.2.0.1 (WHAT WE ARE REFERRING TO 12.2)
• Oracle Database version 12.2.01 Premier Support ends at the
end of November 2020
• Oracle will not provide any patches or bug fixes after November
2020
• Oracle will not offer extended support for Oracle Database
version 12.2.01
@ViscosityNA
Upgrade PlansUpgrade to Oracle 19c?
• Factoids
• 19c is the Terminal Release of Oracle 12
• E-Business Suite (EBS) 12.1 and EBS 12.2 is
officially certified to Oracle Database19c
• Business Suite customers have 12.1.0.2
support until 2020 though
• Oracle 19c is out now! What’s next?
• What is your plans for the upgrade ?
• N-1
• So what is the delimma?
12.2
18c
19c
Multitenant
• Container managed database virtualization
• Manage Many as one (Great!)• Patching, Backup, Security, Online
Cloning, Online Relocation
21
Oracle 12c Oracle Database 18c/19c
• Per-PDB Switchover
• Transportable Backups
• Snapshot Carousel
• Faster Upgrades
18cOracle
Database
19c PDB Consolidation for Cost ContainmentStandardize in consolidating multiple customers into a single container
19cProductionContainer
CM
SPR
OD
AR
PR
OD
CM
SUA
T
AR
UAT
OD
SUAT
OD
SPR
OD
PDB Complete IsolationMeets Compliance & Regulatory Requirements
19c PDB Consolidation for Cost ContainmentConsolidate databases into a single container
PR
OD
QA
DEV
Not a recommended deployment
model
Can put PROD, QA and DEV on a
single container
PDB Complete Isolation
Meets Compliance & Regulatory Requirements
19c PDB DatabaseHigh Availability
19cZero downtime migration• Simplified Administration
• Simplified Upgrade
• Simplified Patching• Simplified Resource Management
19c
19c PDB DatabaseBusiness Justification
19cMigrate databases for hardware maintenanceMigrate databases for OS upgrades
Migrate databases for …Changes how we do patchingChanges how we do upgrades
19c
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.27
OracleODA.com = ODA Partner of the yearQuery 10TB of data in seconds!!! Viscosity is the ODA Partner of the Year!!!
1 TB
with HCC compressionOnly with 18c
10 TB of user data
Requires 10 TB of IO
100 GB
with partition pruning
X7-2 HA ODA
With 2 Trays of SSD
Data is 10x Smaller, Backups are 10x Smaller
Seconds
On ODA
@ViscosityNA
Autonomous Transaction Processing (ATP)Beta Program Partner
Community Evangelists
Data Driven and Data Focused
Experts in Engineered Systems and Cloud
Read Viscosity's white paper on Dedicated (ATP-D) and Oracle Database 19c
Environment
• By Senior Enterprise Database Architect, Oracle ACE Director, Jim
Czuprynski.
• http://bit.ly/2lYXvT9
Viscosity Partner Spotlight on our ATP Performance Benchmarking and
Automatic Indexing
• http://bit.ly/OracleATP2019
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.33
Query 10TB of data in milliseconds!!! How?
1 TB
with compression
10 TB of user data
Requires 10 TB of IO
100 GB
with partition pruning
X7-2 HA ODA
With 2 Trays of SSD
Data is 10x Smaller, Backups are 10x Smaller
Subsecond
On ODA
@ViscosityNA
#1 One Throat to Choke
@ViscosityNA
Simplified Maintenance and Upgrade
18.5 Changed Patching on ODA
ODA Successes
• UP story
• US Renal Care story
• Meridian story
• AR Homes Story
• NeoSystems Story
• Zeus Industrial
• College of American Pathologists
35
Recent Successes
• McClatchy
• Texas A&M
• iTrade
• Envestnet
@ViscosityNA
Great Virtualization PlatformODA In-A-Box
@ViscosityNA
ODA In-A-Box SolutionGreat Virtualization Platform
• EBS in a Box
• JDE in a Box
• Banner in a Box
• Have a customer with 5VMs on ODAs X7-2 HA
• Have another customer running mission critical EBS on ODAs
• Have another customer running 2 VMs on the ODA
– It is getting more popular
• KVM and OVM Virtualization
• ODA S and M only support KVM
• Middleware License Containment
• Database Options Containment
37
@ViscosityNA
Engineered Systems Are Cloud Ready
Now they are even cloud driven …
@ViscosityNA
Cloud Ready
• Oracle runs the same servers on the Cloud
• Same OCICLI gets migrated to ODACLI
• You can migrate to Oracle Cloud ….
• True Life & Shift
40
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
41
Swingbench Benchmark Test Results X7
Summary
Test Results
–Transaction Performance
•OLTP Workload: 36,003 (transactions per second)
•DSS Workload: 32,353 (reports in 30 minutes)
–IOPS/MBPS Performance
•IOPS: 1,620,000 (Single-shelf), 2,250,000 (Dual-shelf)
•MBPS: 15,590 (Single-shelf), 22,250 (Dual-shelf)
•Resource Consumption
–CPU: Maximum of <62% of available capacity for OLTP workload and <75% for DSS workload
–IO Capacity: Not saturated
@ViscosityNA42
Swingbench Benchmark Test Results X8
Summary
AT 61% AVAILABLE CAPACITY FOR OLTP
80% UTILIZATION FOR DSS
Test Results
–Transaction Performance
–IOPS/MBPS Performance
•IOPS: 1,640,200 (Single-shelf), 2,161,600 (Dual-shelf)
•22 GBPS (Dual-shelf)
@ViscosityNA
@ViscosityNA
Copyright © 2012, Oracle and/or its affiliates. All rights reserved.45
HCC - Hybrid Columnar CompressionHighest Capacity, Lowest Cost
▪ Data is organized and compressed by column– Dramatically better compression
▪ Speed Optimized Query Mode for Data Warehousing– 10X compression typical– Runs faster because of Exadata offload!
▪ Space Optimized Archival Mode for infrequently accessed data– 15X to over 50X compression typical
Qu
ery
Faster and Simpler
Backup, DR, Caching,
Reorg, Clone Benefits Multiply
@ViscosityNA 46
Storage Tiering &Compression Tiering
@ViscosityNA
ADO Examples
ALTER TABLE orders ILM ADD POLICY
COLUMN STORE COMPRESS FOR QUERY HIGH SEGMENT
AFTER 30 DAYS OF NO MODIFICATION;
ALTER TABLE orders ILM ADD POLICY
COLUMN STORE COMPRESS FOR ARCHIVE HIGH SEGMENT
AFTER 90 DAYS OF NO MODIFICATION;
ALTER TABLE orders ILM ADD POLICY tier to low_cost_store;
47
Thanks for your undivided attention!
To receive the slides for this presentation, please contact Charles Kim at
Facebook.com/ViscosityNA
Linkedin.com/company/Viscosity-North-America
@ViscosityNA
Viscosity North America
Facebook.com/ViscosityNA
@Viscosity_NA
Follow Us Online!
49