1 / 37

Comp-02: Replication Options Explored

Comp-02: Replication Options Explored. Brian Bowman Product Manager, Data Management Group. Agenda Slide. Introduction Why does a business need Replication? Exploring Replication Options Comparing the Alternatives Summary. Fact.

landis
Download Presentation

Comp-02: Replication Options Explored

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Comp-02: Replication Options Explored Brian Bowman Product Manager, Data Management Group

  2. Agenda Slide • Introduction • Why does a business need Replication? • Exploring Replication Options • Comparing the Alternatives • Summary Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  4. ReplicationDoesn’t Have To Be Hard… Comp-02: Replication Options Explored

  5. There Are Many Choices Out There… Veritas SAN Providers Probkup & Prorest NetApp EMC 4GL Triggers HP Sonic Legato Fathom Replication After Imaging Solaris IBM Comp-02: Replication Options Explored

  6. Agenda Slide • Introduction • Why does a business need Replication? • Exploring Replication Options • Comparing the Alternatives • Summary Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  9. Agenda Slide • Introduction • Why does a business need Replication? • Exploring Replication Options • Comparing the Alternatives • Summary Comp-02: Replication Options Explored

  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 Einstein Stradivarius Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  12. And Some Things Just Shouldn’t Be Replicated… Genghis Khan The Common Cold White Zinfandel The Previous 86 Years “Smart” Appliances Version 7.2A Movie Sequels The Yugo Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  14. Types of Replication • Log based replication • Backup and restore • After imaging • Application triggers • Vendor based options • Fathom Replication • 3rd party options • EMC • Veritas Comp-02: Replication Options Explored

  15. Why Worry? “I have a small business and don’t need to worry about business continuitybesides, I have Progress.” Anonymous customer Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  17. Log-based OptionsSetup • After imaging must be enabled • Restore Progress backup • Apply AI files manually Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  21. Vendor-specific OptionsSetup • Install Fathom Replication on source and target • Configure properties • Enable AI on source • Restore Progress backup • Enable replication Comp-02: Replication Options Explored

  22. Vendor-specific OptionsMaintenance • AI management for backup purposes • DB’s 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 Comp-02: Replication Options Explored

  23. Focus On Your Business “With Veritas, we’ve 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 Comp-02: Replication Options Explored

  24. 3rd Party Doesn’t Mean… Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  26. 3rd Party OptionsSetup • Install and configure HW & SW (depends on solution) • Begin copying process • Configure processes to run • Monitor processes Comp-02: Replication Options Explored

  27. 3rd Party Options Maintenance • HW maintenance • SW maintenance • Patches, service packs • Compatibility issues Comp-02: Replication Options Explored

  28. Agenda Slide • Introduction • Why does a business need Replication? • Exploring Replication Options • Comparing the Alternatives • Summary Comp-02: Replication Options Explored

  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 Comp-02: Replication Options Explored

  30. Ease of Implementation Comp-02: Replication Options Explored

  31. Implementation Expense Comp-02: Replication Options Explored

  32. Meeting Business Objectives “Ease of Use” Log-based Replication Hard 3rd Party Replication Vendor Replication Easy “Cost” Inexpensive Expensive Comp-02: Replication Options Explored

  33. Agenda Slide • Introduction • Why does a business need Replication? • Exploring Replication Options • Comparing the Alternatives • Summary Comp-02: Replication Options Explored

  34. Summary • Evaluate your business needs • How much work do you want to do? • There are many options • Look at the complete scenario Comp-02: Replication Options Explored

  35. Questions? Brian Bowman bowman@progress.com Comp-02: Replication Options Explored

  36. Thank you for your time! Comp-02: Replication Options Explored

  37. Comp-02: Replication Options Explored

More Related