copy data management

Paresh Motiwala

Copy Data Management

Copy

Dat

a M

anag

emen

tBI Data Points

1.Developer2.DBA3.Infrastructure Manager4.CIO5.Finance Manager

Paresh Motiwalacirclesofgrowth.com

781 254 4096PareshMotiwala@gmail.com

: @PareshMotiwala

: Paresh Motiwala : Paresh Motiwala

• From DBA to a PM in 75 minutes• Why are DBAs afraid of tools?• Digital Forensics• Database Forensics• SSRS• SSIS• Time Management• Discrimination• Network or Perish• SQL Best Practices Document

Copy

Dat

a M

anag

emen

t

Copy

Dat

a M

anag

emen

t

Copy

Dat

a M

anag

emen

tWho Should attend:

1.DBAs2.Infrastructure folks3.Systems, DB, Infrastructure

Managers, IT Directors, CIOs4.Network Admins5.Anyone who doesn’t have a life

Copy

Dat

a M

anag

emen

tAgenda for the day

1.What is Copy Data2.DevOps3.Copy Data Sprawl4.Methods of Getting Copy Data5.Copy Data Virtualization6.Compare Multiple Methods7.Summary8.Bibliography9.Q&A

Copy

Dat

a M

anag

emen

tWhat is Copy Data

1. Copy of Production Database for DR2. Copy of Production Database for DevOps3. Copy of Production Database for BI4. Copy of Production Database for Archiving

Copy

Dat

a M

anag

emen

tCopy Data Sprawl

CopiesPurpose Size (TB)1Production 11Backup 11Remote Backup 12Replicated 21DR 1

365Archived Copies 3656Devops 6 Total 377

Copy

Dat

a M

anag

emen

tMethods of Getting Copy Data

1. Replication2. Transaction Log Shipping3. Mirroring4. Snapshot5. Block Level Replication6. Tapes

Copy

Dat

a M

anag

emen

tMethods of Getting Copy DataReplication

Feature Pros Cons

Setup Easy Can’t repair

Trouble Shooting - Tough

Space Same amount

Network Bandwidth Low -

Repointing Apps if for DR DNS switch -

Devops Yes/no Yes/no

Time Minimal Lag

Cost -- Difficult to maintain

DaAS Yes/No Yes

Copy

Dat

a M

anag

emen

tMethods of Getting Copy DataTransaction Log Shipping

Feature Pros Cons

Setup Easy Easy to restart, if within reason

Trouble Shooting Easy -

Space - Same amount or more

Network Bandwidth Low -

Repointing Apps if for DR DNS Switch -

Devops - No

Time Depends Can be heavy lag

Cost - Difficult to maintain

DaAS - No

Copy

Dat

a M

anag

emen

tMethods of Getting Copy DataMirroring - Deprecated

Feature Pros Cons

Setup Easy Easy to restart, if within reason

Trouble Shooting Easy

Space Same amount

Network Bandwidth Low -

Repointing Apps if for DR DNS Switch -

Devops - No

Time Instant

Cost Disk Space -

DaAS - No

Copy

Dat

a M

anag

emen

tMethods of Getting Copy DataSnapshot

Feature Pros Cons

Setup Easy -

Trouble Shooting Easy -

Space Same amount

Network Bandwidth Low -

Repointing Apps if for DR DNS Switch -

Devops Yes -

Time Initial Buildup

Cost Disk Space

DaAS Yes -

Copy

Dat

a M

anag

emen

tCopy Data Virtualization

Production

Master Copy of Backup

Clone

D

E

V

O

P

S

Methods of Getting Copy Data

Copy

Dat

a M

anag

emen

tMethods of Getting Copy DataCopy Data Virtualization

Feature Pros Cons

Setup Fairly Easy -

Trouble Shooting Easy -

Space Virtually none extra -

Network Bandwidth Low -

Repointing Apps if for DR DNS Switch -

Devops Yes -

Cost - Expensive to start with

DaAS Yes -

Copy

Dat

a M

anag

emen

tComparing Multiple Methods

Feature TXN Repl SnapShot Mirror BLR CDV

Setup Easy Not the easiest Easy Easy Easy Vendor Driven

Trouble Shooting

Easy Not the easiest Easy Easy Easy Easy

Space Same as prod

Same as prod Same as prod

Same as prod Same as prod

Almost zero

Network Bandwidth

Medium Medium N/A Medium High Almost Zero

Repointing Apps if for DR

DNS Switch

DNS Switch DNS Switch DNS Switch or automated

DNS Switch

Devops yes No(sort of) Yes No Yes

Cost No new tech

No new tech No new tech No new tech MIE HIE

Time Lag Lag No Lag Little Lag Little Lag Almost Instant

DaAS MayBe Yes Yes No No Yes

Copy

Dat

a M

anag

emen

tSummary

1. What is Copy Data 2. DevOps3. Copy Data Sprawl4. Methods of Getting Copy Data5. Copy Data Virtualization6. Summary Compare

Copy

Dat

a M

anag

emen

tBibliography

1. http://www.delphix.com/2015/08/20/new-research-reveals-data-issues-represent-the-biggest-challenge-to-devops-initiatives/

2. www.actifio.com3. www.rubrik.com

Copy

Dat

a M

anag

emen

tQ&A

1.Thank You2.Remember, Paresh

for President 2016