![Page 1: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/1.jpg)
DevOps 101 for DBAs and Database
DevelopersClay JacksonSr Sales Engineer
![Page 2: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/2.jpg)
2 quest.com | confidential
Agenda
• What is DevOps?• Why DevOps?• DevOps Definitions• I’m a DBA/Database Developer – What’s in this for me?• Tools for Database DevOps• Q & A
![Page 3: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/3.jpg)
What is DevOps
![Page 4: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/4.jpg)
4 quest.com | confidential
![Page 5: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/5.jpg)
5 quest.com | confidential
![Page 6: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/6.jpg)
6 quest.com | confidential
Three Ways of DevOps – Gene Kim - 2012
• System Thinking– Break down silos
• Feedback Loops– Get closer to your customer
• Culture of Experimentation and Learning– You can’t hit if you don’t swing
![Page 7: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/7.jpg)
Why DevOps02
![Page 8: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/8.jpg)
8 quest.com | confidential
DevOps Increases
• Innovation speed– Shorter development cycles– Continuous Delivery
• Communication and Collaboration– Team Performance– Continuous Integration
• Efficiency– Scalable Infrastructure
![Page 9: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/9.jpg)
9 quest.com | confidential
DevOps Decreases
• Development time– Shorter cycles
• Failures– Deployment– Time to recover
• Costs– Less IT Staff– Less Overhead
![Page 10: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/10.jpg)
10 quest.com | confidential
The Challenge of Agile Database DevelopmentThe Challenge of Agile Database Development
![Page 11: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/11.jpg)
DevOps Definitions03
![Page 12: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/12.jpg)
12 quest.com | confidential
The DevOps “Figure 8”
ItPedia
![Page 13: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/13.jpg)
13 quest.com | confidential
Test Driven Development
• AKA Design Driven• Write tests first!• Designers write tests• Iterative
– Design– Write tests– Code– Test– Repeat
![Page 14: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/14.jpg)
14 quest.com | confidential
Regression Testing
• Testing to be sure new features don’t break• Supports Continuous Integration and Continuous Delivery• Must be automated• Must be designed• Must be deliberate• Don’t just test “old bugs”
![Page 15: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/15.jpg)
15 quest.com | confidential
Microservices
• Wiki – A variant of Service Oriented Architecture– Small– Single Function– Built to facilitate automated testing– Elastic– Composable– Complete
![Page 16: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/16.jpg)
16 quest.com | confidential
Continuous Integration
• AWS – Developers merge their code changes into a central repository– Automated– Tested– Pass/Fail– If pass, ready for Continuous Delivery
![Page 17: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/17.jpg)
17 quest.com | confidential
Continuous Delivery
• AWS – Automatic build, test and prepare for production– Automated– Repeatable– Pass/Fail– PREPARE for production– Part of a pipeline
![Page 18: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/18.jpg)
18 quest.com | confidential
(Build) Automation
• Automatic Tasks– Optimization at the task level
• Build Automation– Check out code– Compile Code– Execute Tests– Summarize Results
![Page 19: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/19.jpg)
19 quest.com | confidential
(Release) Orchestration
• Orchestration vs Automation– Automation – Tasks– Orchestration – Processes– Enables Process Optimization– WorkFlows can be Orchestrated
• Release Orchestration– Use of tools to manage releases– Essential for Continuous Integration/Continuous Delivery
![Page 20: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/20.jpg)
20 quest.com | confidential
Provisioning
• Preparing <something>– Usually Servers– Might be networks or switches– Virtual
• Not to be confused with Configration– Provisioning does NOT make ready for a specific use– Configuration is the next step
o Addresses
![Page 21: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/21.jpg)
21 quest.com | confidential
Configuration Management
• NetApp – Automated methods to maintain software and systems in a known state
• Manages changes– But more than just change management
• Most often applied to software– Build the same thing twice– Automated versioning– Difference reporting– Automation is the key
![Page 22: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/22.jpg)
22 quest.com | confidential
Canary Release
• AKA Phased Rollout
• Deploy to subset of users
• Allows for capacity evaluation
• Quick Go/No Go
• Easy rollback
• Planning is key
– Don’t loose data with rollback
– Consistent functionality
![Page 23: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/23.jpg)
23 quest.com | confidential
Dark Release
• Like Canary Release• Shhhh – Don’t tell anyone• USUALLY deploy to subset of users• Planning is still key
– Don’t loose data with rollback– Consistent functionality
![Page 24: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/24.jpg)
I’m a DBA – What’s in it for me? 04
![Page 25: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/25.jpg)
25 quest.com | confidential
What If You Could…
Monitor and identify performance issues throughout your DevOps pipeline?
Develop and deploy higher quality database changes faster, together with application changes, without making compromises?
Automatically replicate production changes in near real-time to other database
environments?
![Page 26: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/26.jpg)
Tools for Database DevOps05
![Page 27: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/27.jpg)
27 quest.com | confidential
Foglight Toad for Oracle
SharePlex Toad Data Point
Toad DevOps Toolkit
Achieving Continuous Database Operations with Quest’s Database Solutions
![Page 28: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/28.jpg)
28 quest.com | confidential
Quest’s DevOps Infrastructure Solution
![Page 29: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/29.jpg)
Questions?
![Page 30: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/30.jpg)
30 quest.com | confidential
Resources• Quest website (quest.com/products/toad-for-oracle)
– On-demand webcasts (Cloud, IDC)– Toad Agile Cookbook (3-part series)– Database DevOps Solutions
• Toad World Community (community.toadworld.com/products/toad-for-oracle)– Featured videos– Evaluation resources
• Support website (support.quest.com/toad-for-oracle)– Knowledge Base– Video tutorials and free training courses– Technical documentation
![Page 31: DevOps 101 for DBAs and Database Developersevdbt.com/wp-content/uploads/2018/10/DevOps101.pdf · DevOps 101 for DBAs and Database Developers Clay Jackson SrSales Engineer](https://reader036.vdocuments.us/reader036/viewer/2022062311/5ececd95510079189a2ed8d1/html5/thumbnails/31.jpg)
Thank [email protected]