1 / 31

OPS-10: Managing multiple sites part time: Replication & OpenEdge Management Case Study

OPS-10: Managing multiple sites part time: Replication & OpenEdge Management Case Study. Brian Bowman. Sr. Solution Engineer. Try This…. What were you watching?. How many turned Red? How many were Yellow? How many disappeared altogether? Bonus Question: How many changed color?.

csavoy
Download Presentation

OPS-10: Managing multiple sites part time: Replication & OpenEdge Management Case Study

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. OPS-10: Managing multiple sites part time: Replication & OpenEdge Management Case Study Brian Bowman Sr. Solution Engineer

  2. Try This…

  3. What were you watching? • How many turned Red? • How many were Yellow? • How many disappeared altogether? • Bonus Question: • How many changed color?

  4. Maybe a bit slower?

  5. What if you could do this?

  6. Agenda • Company Overview • Business Problems IT Faced • OE Replication Overview • OE Management Overview • Challenges & Successes • Wrap-up & Questions

  7. Company Overview • Privately held company • Custom built application (mostly) • Currently between 800 & 1,000 users (CAGR: 25%) • One of the US’s largest technology distribution companies • First company to distribute • Color TV • Home PC • Gaming system

  8. Systems Overview • Windows-based servers • Windows GUI application • 8 distribution sites (with application) • Across North America • Corporate office does all reporting • One DBA

  9. Technology Overview • OpenEdge 10.1B • Approx. 50 developers in house • VMware used extensively at corporate • Peak AI updates: 15K blocks / Hour • 256K lines between sites and corporate PSDN Whitepaper: Determining Fathom Replication Network Bandwidth

  10. Technology Picture Corporate Office Distribution Center DB-Corp DB Network Reporting Client Customer Service, Order Entry Client Security System

  11. Agenda • Company Overview • Business Problems IT Faced • OE Replication Overview • OE Management Overview • Challenges & Successes • Wrap-up & Questions

  12. Business Problems IT Faces • Remote reporting • No local DR solution • 24 hour shipping guarantee • One DBA • No remote visibility • Changes happening rapidly

  13. Agenda • Company Overview • Business Problems IT Faced • OE Replication Overview • OE Management Overview • Challenges & Successes • Wrap-up & Questions

  14. What is OpenEdge Replication? • Automated data replication of your mission critical database to a hot stand-by. • Software that improves application availability with no application changes.

  15. Distribution Center Source Targ2 OE Replication Setup Corporate Office Network DB-Corp Source DB Targ1 Customer Service, Order Entry Client, etc. Replication DB-Corp Target Reporting Client

  16. Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Src Src Src Src Src Src Src Src Targ2 Targ2 Targ2 Targ2 Targ2 Targ2 Targ2 Targ2 OE Replication Completed Picture Corporate Office Targ1 Targ1 Targ1 Targ1 Targ1 Targ1 Targ1 Targ1 Corp Source Corp Target

  17. OE Replication – Solving Business Problems • Remote reporting - OpenEdge Replication • No Local DR solution - OpenEdge Replication • 24 hour shipping guarantee – OpenEdge Replication • One DBA • No remote visibility • Changes happening rapidly

  18. OE Replication – Solving Business Problems • Remote reporting - OpenEdge Replication • No Local DR solution - OpenEdge Replication • 24 hour shipping guarantee – OpenEdge Replication • One DBA • No remote visibility • Changes happening rapidly

  19. Agenda • Company Overview • Business Problems IT Faced • OE Replication Overview • OE Management Overview • Challenges & Successes • Wrap-up & Questions

  20. OpenEdge Management

  21. OpenEdge Management Console Trend DB OE Management Setup Corporate Office Dist. Center Corp Source Source Network AdminServer Targ2 Corp Target DB Targ1

  22. Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Dist. Center Source Source Source Source Source Source Source Source AdmSrv AdmSrv AdmSrv AdmSrv AdmSrv AdmSrv AdmSrv AdmSrv Targ2 Targ2 Targ2 Targ2 Targ2 Targ2 Targ2 Targ2 OpenEdge Management Console OE Management Completed Picture Corporate Office Corp Source Corp Target

  23. OE Management - Solving Business Problems • Remote reporting - OpenEdge Replication • No Local DR solution - OpenEdge Replication • 24 hour shipping guarantee – OpenEdge Replication • One DBA – OpenEdge Management • No remote visibility – OpenEdge Management • Changes happening rapidly – OpenEdge Management

  24. Agenda • Company Overview • Business Problems IT Faced • OE Replication Overview • OE Management Overview • Challenges & Successes • Wrap-up & Questions

  25. Challenges Faced in the Implementation • Bandwidth • 256K lines between sites and corporate • Video Surveillance shares the same line… • Backup transfers (California – Pennsylvania) • Backup is only available via overnight currier… • Logistics • 8 sites plus corporate • Very little down time available • Different sites on different releases

  26. OpenEdge Management OpenEdge Replication Security cameras Network overhead OpenEdge Replication Network Requirements Calculations • After Image Volume: • 10,000 8K AI blocks / Hr (81 megabytes) • + 50% safety factor (123 megabytes) • 2 megabytes / minute  36K / Second • Roughly 14% of network bandwidth required 100% Network Bandwidth 0%

  27. Successes in the Implementation • Proof of Concept enforced the value of Replication for Performance and HA • OpenEdge Management • Up and running in less than one week • OpenEdge Replication • Up and running within the same week • all but 3 sites (HW Problems)

  28. Wrap-up • OpenEdge Replication and Management helped solve business problems! • Tools provided the ability to do more with the same resources • Remote Management is critical in today’s business

  29. ? Questions

  30. Thank You

More Related