36
• Emerasoft srl • Mission • Vision • Market & Solutions Monica Burzio Federico Pagnozzi Guido Levi
| Date post: | 11-Jan-2017 |
| Category: |
Software |
| Upload: | emerasoft-solutions-to-collaborate |
| View: | 118 times |
| Download: | 1 times |
•Emerasoft srl•Mission•Vision•Market & Solutions
Monica BurzioFederico PagnozziGuido Levi
Agenda
• La Continuous Delivery per il database• Le principali barriere e criticità• Il business value generato dall’automazione del DB• La soluzione
Mini-seminario: “Mai sentito parlare di Continuous Delivery per il database? Ecco come e perchè”
maggio 2016
18
Data di nascita: 2005
Dove siamo:
via Po, 1 – Torinovia del Poggio Laurentino, 118 - Roma
“Il nostro impegno è nella costante ricerca della migliore soluzione per il cliente, garantendo eccellenza nella qualità di servizi e prodotti proposti. La nostra promessa è di svolgere il nostro lavoro con costanza e passione”
DevOpsIoT
Testing
ALMSOA
Business Intelligence
SecurityDigital Publishing
Training
ALM+PLM
traceability
standard compliance
Open Source
Big DataUser Experience
SS4B
Enterprise Mobilityagile
IoDUniversity
Usability
APIBPM
DevOpsIoT
Testing
ALMSOA
Business Intelligence
SecurityDigital Publishing
Training
ALM+PLM
traceability
standard compliance
Open Source
Big DataUser Experience
SS4B
Enterprise Mobilityagile
IoDUniversity
Usability
APIBPM
The pain–Fortune 1000 by IDC
Application Downtime Cost
$2B/YDeployments/
month 2x Growth
Accelerate Delivery by 20%
Compliance & Audit
Enforcement
Infra Failure Hourly Cost
$1M
IDC DevOps Best Practices metrics: Fortune 1000 Survey, December 2014
Loss of Reputation
Only 13% are actually performing basic CD practices for the DB!Manual work:
cant scale, cant match CD frequencynot repeatable, prone to error
Continuous Delivery is big and getting bigger, but...
Only 13% automate… the rest do manual steps…
Media Coverage
Business Value Proposition 10X Faster time to market
Accelerate the overall application release process by automating the database which is currently the slowest/weakest link
15% Increase in team efficiency & productivity Deliver more new database driven business applications with the same # of developers Significantly reduce the time spent on writing and revising database scripts Manage the growing volume and increased frequency of changes
80% Reduction in application downtime due to human errors Leverage Impact Analysis of database changes in order to identify & resolve conflicts Automatically create database update scripts to eliminate human errors
100% Control, 100% Compliance - control and audit who, does what, when and why!
Enforced Version/Source Control Enhanced security through Roles & Responsibilities segregation Audit trail
What is the problem?▪Root Causes for issues:
− Challenging manual source control process− Static deployments code overrides and configuration drift− Dynamic deployments tools unaware of version control− No release automation red-flags – don’t know when to stop
the line…
File Version Control Process Today: Two isolated processes
DBDevelopment Process
Check-Out Script
Modify Script
Get updated
Script from DB
Check-In Script
Compile Scriptin DB
Debug Scriptin DB
?
??
?
A
A’
Version control is out of sync from the database and cannot act as a Single Source of
Truth
X1.11.1.11.11.21.31.41.51.61.7
Int QA Stage Prod
Database Deploy Script
DevDev
DevModel
1.1 1.2
1.2 1.3
1.3 1.4
1.4 1.5
1.5 1.6
1.6 1.7
1.11.11.41.7
1.1 1.2
1.2 1.3
1.3 1.4
1.4 1.5
1.5 1.6
1.6 1.7
1.1 1.2
1.2 1.3
1.3 1.4
1.4 1.5
1.5 1.6
1.6 1.7
Out of Process Change
XX
XXX
? 1.1.1
X
Challenge with static scripts…
Configuration drift…
Safe to automate?Sure… (?)
Challenge with ‘Compare & Sync’
Safe to automate?No. Requires manual inspection…
Challenge with ‘Compare & Sync’
A compare & sync tool:Is unaware of any changes that occurred before the time it ranHas no knowledge of changes that took place at the target environment
Does not leverage version control for more informationUnable to deal with conflicts & merges between different teamsRequires manual inspection Requires detailed knowledge regarding each change as part of the process
So…no automation… We fear for automating problems
into production and a major risk!!!
Challenges
The Solution to the challenges
Database EnforcedSource Control
Enhanced Security andRegulatory Compliance
Database Merge andBuild Automation
Database ReleaseAutomation
The Solution
Modern VC integrated DB process
Revision history
Actions
Standard IDE
Change Management
Enforced and integrated to existing process
LeverageVersion control knowledge
intoDeployment decisions
1.11.21.31.41.51.61.7
*
Int QA Stage ProdDev
DevDev
Model
1.1 1.2
1.2 1.3
1.3 1.4
1.1 1.7
1.1.1 1.7
1.1 1.1 1.11.41.7
Out of Process Change
1.1.11.7 1.1.11.7
Validate
1.4 1.5
1.5 1.6
1.6 1.7
Configuration Drift prevention / conflict identification and Validated execution
1.4 1.5
1.5 1.6
1.6 1.7
OR
Baseline aware analysis
Validated execution / Build & deploy on demand
Validate
Understand the nature of the changesRaise red flags on conflicts Support out-of-process changesUtilize baseline aware analysis
Safety Net Deployment Automation
If we had the index in the baseline (previous version) and no longer in Dev (i.e. - removed) => we should take it down from production…
(Deploy Change)
Deploying changes if neededDevelopment Baseline
Previous Label /Production Golden Copy
Production
Development BaselinePrevious Label /
Production Golden Copy
Production
BUT… If no index in baseline => someone else added it to Production…we should protect the NEW index on production!!!
(Protect Target)
Or protecting target environment…
Dealing with conflicts => merging changes
Conflict Resolving – Meta Data/Content
Continuous Delivery Pipeline Builder
Define a process Automate the process Prevent/Alert out of process
changes
Raise red flags to stop the line…if requires human intervention
Impact Analysis! Not Damage Control…
Security & Compliance
Monitor unauthorized change attempts
Alert security monitors Use for compliance reports
Selected Customers
Integrated CD world…
Contenuti disponibili su:
Canale slideshare di Emerasoft
Canale Youtube Emerasoft
Visita il nostro sito emerasoft.com
What’s next
Contattaci: [email protected]
Email: [email protected] Q&A ?
@
WWW
Segui i nostri canali …
Emerasoft Srl
via Po, 1 – 10124 Torinovia del Poggio Laurentino, 118 – 00144 Roma
T +39 011 0120370 T +39 06 87811323F +39 011 3710371
Grazie…
Contatti
