advance from dba to cloud administrator - rainfocus · 2019-06-27 · advance from dba to cloud...
TRANSCRIPT
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Advance from DBA to Cloud Administrator
Confidential – Oracle Internal/Restricted/Highly Restricted
Erik Benner, MythicsVP Enterprise Transformation, Mythics
Moe Fardoost, Timothy Mooney Oracle
October 04, 2017
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Safe Harbor StatementThe 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.
Confidential – Oracle Internal/Restricted/Highly Restricted 2
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Program Agenda
User Survey Preview
The Role of a DBA and The Cloud
1
2
Confidential – Oracle Internal/Restricted/Highly Restricted 3
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
User Survey PreviewIOUG, AOUG, Quest Survey Says;
Confidential – Oracle Internal/Restricted/Highly Restricted 4
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal/Restricted/Highly Restricted 5
Competitiveness hurt by spend on systems of record
66%
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal/Restricted/Highly Restricted 6
1st alert of issues comes from users/customers
85%
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal/Restricted/Highly Restricted 7
How Are Alerts Coming In?
Alerts for IT Issues 2009 2014 2017
System management alerts 39% 60% 67%
From senior management 21% 26% 32%
From customers/end users 78% 85% 85%
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal/Restricted/Highly Restricted 8
Cloud will play a key role in ERP, core enterprise apps, database in the next 3 years
57%
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal/Restricted/Highly Restricted 9
Cloud Concerns; Security, Loss of control
63%
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
What If You Had A Cloud Service
• Bring your whole stack of system data together• Analyze all the data automatically• Display in Intuitive, double-clickable dashboards• Always available for IT Ops, Development, Security, …
Confidential – Oracle Internal/Restricted/Highly Restricted 10
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 11
Our Vision
Complete, integrated suite of systems management solutions
Designed for heterogeneous applications and infrastructure
Rapid time to valueOn Premise
Application PerformanceMonitoring
LogAnalytics
IT Analytics
Infrastructure Monitoring
Configuration & Compliance
Orchestration
Security Monitoring & Analytics
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 12
Adaptive, Intelligent Platform and Cloud Services
INTELLIGENT, UNIFIED PLATFORM
POWERED BY MACHINE LEARNING
INFORMED BY A COMPLETE
DATA SET
HETEROGENEOUS AND OPEN
APPLICATION
MIDDLE TIER
DATA TIER
VIRTUALIZATION TIER
INFRASTRUCTURE TIER
END USER EXPERIENCE / ACTIVITY
Unified Platform
Global threat feedsCloud access identity
Real usersSynthetic users
App metricstransactions
Server metricsDiagnostics logs
Host metricsVM metricsContainer metrics
CMDB/ComplianceTickets alerts
Security events
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
• OMC is a next-generation suite of management and monitoring services
• OMC is designed for heterogeneous environments, across on-premise, Oracle Cloud and non-Oracle clouds
• OMC services leverage a unified big data platform to provide deep insights across technical and business data
• EM is a traditional active management and deep diagnostics solution, highly tailored for the Oracle red stack
• EM is deployed on-premise to manage Oracle private, public or hybrid clouds
• EM data is harvested and uploaded to the OMC data platform
13
Oracle Management Cloud Oracle Enterprise Manager
Using Oracle Management Cloud With Enterprise Manager
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Published Author RAC Attack Ninja Linux since 1992 Solaris since 1996 DB 12c BETA user Prelaunch ODA “comet” First Version of Oracle…7 in 1994 ZFS since “Thumper”OEM 12c since Product LaunchOAUG EM for Apps SIG co-chairOEM12c CAB Member IOUG Solaris SIG Leader
Erik BennerVP Enterprise [email protected]
@erik_benner
TalesFromTheDatacenter.comMythics.com/blog
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 15
Modern Application and Infrastructure Topologies
On Premise
Multiple Clouds
Polyglot Development
New Methodologies
• Agile• DevOps• SRE• Continuous Delivery
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 16
The role of the “DBA”
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 17
The role of the DBA is changing
• Servers• Storage• Network• Applications
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 18
The role of the “Developer” is changing as well
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 19
Not just the Software
• Databases• Performance• Disaster Recovery
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 20
Database ManagementSystems!
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Threshold monitoring is broken!
• High or low, does not always point to a problem• Too many false alarms• Sometimes it’s still useful• What if you could get alerts on problems?
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Machine Learning is key
• Systems learn normal patterns• Alert of items when they are outliers
• DB tractions are higher or lower than expected• Network I/O is lower than expected• App server errors align with database errors
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Correlation of events globally
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 25
On-Premise or in the Cloud
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 26
Infrastructure
CPU
Database
App Server
Storage
Load Balancer
Monitor the entire ecosystemIdentify Outliers, not numbersRCA faster and more accurate
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 27
Multiple Targets
• Windows, Linux, Solaris• WebLogic• MySQL• NoSQL• DB EE and SE!!• ASM• OHS• Microsoft SQL• MongoDB• Apache• Docker• Traffic Director• F5 loadbalancers• And more• And even more!
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 28
Enterprise View
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 29
Host
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 30
Database
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 31
Database Alerts
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 32
Log Analytics
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 33
Extracting Information from Logs is Challenging…
Log data is scattered• Infrastructure, server, database, application• Containers, VMs, Micro Services
Log data is huge• Proprietary and growing over 40% every year
Log data is diverse• Multiple formats• Different locations• Difficult to analyze
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 34
Extracting Insights
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Efficient Troubleshooting
Find egregious log events rapidly• Across the entire application deployment
Reduce number of log events• Identify log events with similar structures• Change in trends of specific type of events• Temporal relationships
Find anomalies and outliers• Variable faceting
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 36
Rapidly Identify Issues
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Efficient Troubleshooting
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 38
What do Users care about?
SQL Performance
RMAN BackupsASM Redundancy
Encrypted Communications?
CPU Performance
CPU Model? Where it’s hosted?
Execution Plans
Tablespaces
FIlesystemsIndexes Heap Managementhttp
Garbage Collectionsar
top
$CLASSPATH
Operating system
ssl
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 39
Application Performance Monitoring
Visibility across Silos
Automatic Infrastructure Discovery
Integrated Log Analytics and Application Topology
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 41
See all the session!
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 42
Drill down to a single session
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 43
App Server Performance
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 44
Synthetic Transactions
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 45
Discover Topology
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |
Call-to-Action slide• Sign up for a free 30-day trial • Download data and instructions • Learn more about OMC (oracle.com/managementcloud) • Checkout the OOMC Booth in Moscone West #003
• Check out the Mythics Booth in Moscone South #2617• Mythics Consulting can help accelerate your deployment
Confidential – Oracle Internal/Restricted/Highly Restricted 46
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 47
Erik Benner@erik_bennerTalesFromTheDatacenter.comMythics.com/[email protected]