•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: sales@emerasoft.com

Email: federico.pagnozzi@emerasoft.com Q&A ?

@

WWW

Segui i nostri canali …

www.emerasoft.comsales@emerasoft.com

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