PTW045: Replication Options Explored

1
PTW-045 Replication Options Explored

• Brian Bowman
• Product Manager, Data Management Group
• bowman_at_progress.com

2
Agenda Slide

• Introduction
• Why does a business need Replication?
• Exploring Replication Options
• Comparing the Alternatives
• Summary

3
Fact
Replication is the process of sharing information
between databases (or any other type of server)
to ensure that the content is consistent between
systems.
Source about.com
4
ReplicationDoesnt Have To Be Hard
5
There Are Many Choices Out There
Veritas
SAN Providers
Probkup Prorest
NetApp
EMC
4GL Triggers
HP
Sonic
Legato
Fathom Replication
After Imaging
IBM
Solaris
6
Agenda Slide

• Introduction
• Why does a business need Replication?
• Exploring Replication Options
• Comparing the Alternatives
• Summary

7
Cost of Doing Business
Private-sector preparedness is not a luxury it
is a cost of doing business in the post 9/11
world. It is ignored at a tremendous potential
cost in lives, money and national security.
9/11 Commission Final Report
8
Why Does A Business Need Replication?

• Business Requirements 24x7, 9x5, etc.
• BC / DR Planning
• Compliance and regulations
• Sarbanes Oxley, HIPAA, Basel II
• Insurance Regulations
• Peace of Mind

9
Agenda Slide

• Introduction
• Why does a business need Replication?
• Exploring Replication Options
• Comparing the Alternatives
• Summary

10
Some Things Should Be Replicated
The Speyside Region
Databases
A Good Golf Round
2004 Red Sox Season
Sunny Days
A Big Sale
A Good Movie
Stradivarius
Einstein
11
Some Things You May Want To Replicate But Are
Afraid To
That Weekend in Las Vegas
Johnny Damon
Your Paycheck


Your Children
Jimmy Hendrix
Include Files
12
And Some Things Just Shouldnt Be Replicated
Genghis Khan
The Common Cold
White Zinfandel
The Previous 86 Years
Smart Appliances
Version 7.2A
Movie Sequels
The Yugo
13
The Value of Data
Decisions based on inaccurate or unreliable data
can adversely affect the decision making process.

LeRon E. Bielak, US Department of the Interior
December 2002
14
Types of Replication

• Log based replication
• Backup and restore
• After imaging
• Application triggers
• Vendor based options
• Fathom Replication
• 3rd party options
• EMC
• Veritas

15
Why Worry?
I have a small business and dont need to worry
about business continuity ? besides, I have
Progress.
Anonymous customer
16
Log-based OptionsOverview

• Backup and restore
• After imaging (AI) managed approach
• No set configuration, must be built
• Remote database cannot be used
• Never near real-time
• Licensing
• DBA level knowledge of AI processing

17
Log-based OptionsSetup

• After imaging must be enabled
• Restore Progress backup
• Apply AI files manually

18
Log-based OptionsMaintenance

• Script management
• Ongoing maintenance
• New enhancements
• DB out of sync - start over
• Complete AI management
• Backup, transfer, roll forward AI files
• Must monitor processes
• Failover requires last AI from production

19
The Value of Fathom Replication
The main reason for Replication is the
importance of the application to our business.
Denise MacDonald, Network and Support
Manager,Caledonian MacBrayne
20
Vendor-specific OptionsOverview

• Fathom Replication
• Near real-time database level replication
• Backup database accessible for reporting
• Fail over easily with little or no transaction
  loss

21
Vendor-specific OptionsSetup

• Install Fathom Replication on source and target
• Configure properties
• Enable AI on source
• Restore Progress backup
• Enable replication

22
Vendor-specific OptionsMaintenance

• AI management for backup purposes
• DBs out of sync
• Fathom Replication can re-sync the databases
• You might have to start over
• Must monitor log files and processes
• Failover might require last AI from source

23
Focus On Your Business
With Veritas, weve significantly improved IT
productivity and our IT staff can now focus more
of its time on supporting our patient care
resources .
Steven Vasquez, MIS network administrator Unity
Health Center, March 2005
24
3rd Party Doesnt Mean
Middleware
Another political party
Another Set of Contracts
Additional SW to Manage
A more complex environment
Loss of Maintainability
25
3rd Party OptionsOverview

• Vendor neutral
• Your choices depend on the vendor
• Periodic snapshot of disks, transfers to another
  disk set
• Real-time update at the block or bit level
• HW knowledge is required
• Backup database is not accessible
• Licensing

26
3rd Party OptionsSetup

• Install and configure HW SW (depends on
  solution)
• Begin copying process
• Configure processes to run
• Monitor processes

27
3rd Party Options Maintenance

• HW maintenance
• SW maintenance
• Patches, service packs
• Compatibility issues

28
Agenda Slide

• Introduction
• Why does a business need Replication?
• Exploring Replication Options
• Comparing the Alternatives
• Summary

29
The Price
93 of Companies that lose access to their data
center for more than 10 days file for bankruptcy.
Half file immediately.
Juniper Networks
30
Ease of Implementation
31
Implementation Expense
32
Meeting Business Objectives
Ease of Use
Log-based Replication
Hard
3rd Party Replication
Vendor Replication
Easy
Overall Cost
Inexpensive
Expensive
33
Agenda Slide

• Introduction
• Why does a business need Replication?
• Exploring Replication Options
• Comparing the Alternatives
• Summary

34
Summary

• Evaluate your business needs
• How much work do you want to do?
• There are many options
• Look at the complete scenario

35
Closing Thought
There are 10 types of people in the world...
those who understand binary and those who
don't.
36
Questions?
Brian Bowman bowman_at_progress.com
37
Thank you for your time!
38
(No Transcript)