DB-2 Open Edge Replication How to get Home

DB-2: Open. Edge® Replication: How to get Home in Time … Brian Bowman Sr. Solutions Engineer Sandy Caiado Sr. Solutions Engineer

Open. Edge Protecting Your Future § Replication Overview § Open. Edge Replication Process § Failover, Secondary Replication and Failback Sample § details Questions Image: Please replace it (Insert, Picture, …) 2 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Open. Edge Business Continuity Solutions 3 DB-2: Open. Edge® Replication: How to get Home

Open. Edge Replication Plus 4 DB-2: Open. Edge® Replication: How to get Home in

Open. Edge Replication Continuous Availability With § Near real-time replication • Near zero-latency • No data loss • Guaranteed data integrity § Flexible database options • Multiple target databases • Read-only query access § Easy deployment § Automatic recovery 5 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Protecting Your Future § Replication Overview Sample § Open. Edge Replication Process Image: § Failover, Secondary Replication, and Failback § 6 details Summary DB-2: Open. Edge® Replication: How to get Home in Time … Please replace it (Insert, Picture, …) © 2007 Progress Software Corporation

Definitions § Source database • “Normal” production • Original source of updates § Target database • Standby database • Target location in Open. Edge Replication § Single point of failure – a bad thing. 7 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Definitions § Primary Replication • Normal processing • Primary machine performs updates • Secondary machine receives updates § Failover • Primary machine fails • Secondary machine becomes primary § No Backup – a bad thing 8 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Definitions § Secondary Replication • Failed over mode • Secondary machine performs updates • Primary machine receives updates § Failback • The process to get primary machine back to its original state and the secondary machine to take on its original role to be the backup § Failing to check your backup – a bad thing 9 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Definitions § Transition • Process where the databases change roles • Configured to be either manual or automatic § Synchronization • Process to make sure the database on primary and secondary are identical • This is performed – During database and replication startup – Failure recovery processing 10 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Open. Edge Replication Complete Configuration Primary Source Database Secondary Database Broker Processes AI Extents Database Broker Processes Repl Queue 11 Target Database Repl Server DB-2: Open. Edge® Replication: How to get Home in Time … Repl Agent © 2007 Progress Software Corporation

Open. Edge Replication Functionality Primary Source Database AI Extents 12 § § Database Broker Processes Repl Queue § Configures and manages remote agents Sends all database activity to its replication agents Controls replication agents Repl Server DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Open. Edge Replication Functionality § Receives database § § Secondary Database Broker Processes activity from replication server Performs continuous roll-forward to target database Types of Agents • Asynchronous • Synchronous Target Database Repl Agent 13 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Modes of Replication Asynchronous Primary Target One Target Database Repl Agent Source Database Target Two Target Database Repl Agent 14 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Modes of Replication Synchronous Primary Source Database 15 DB-2: Open. Edge® Replication: How to

Open. Edge Replication Failure Conditions Primary Secondary Source Database Broker Processes X AI Extents Database Broker Processes Repl Queue 16 X X Repl Server DB-2: Open. Edge® Replication: How to get Home in Time … Repl Agent Target Database © 2007 Progress Software Corporation

How Does it Work? § Plugs into after-image sub-system § TCP connection between server and agent § Queue for transfers on source § Agent periodically (every 10 blocks) polls § 17 server for heart beat (asynchronous mode) Agent will also communicate a synchronization point (ie. extent switch) back to the server DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Additional Considerations § Schema changes are replicated § AI extents must be managed • AI Management Utility!!! § Ensure that you have enough AI extents space - extents will remain “locked” until they are replicated in entirety PSDN Whitepaper – “Managing AI with and Open. Edge Replication” 18 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Machine Setup § Source and target machines must • Have identical architectures • Be running the same operating system • Be connected via TCP/IP § The target machine must have disk space comparable to the source machine 19 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Progress Requirements § Progress 9. 1 E for Fathom Replication 3. 0 A § Open. Edge 10. 0 B+ for Open. Edge Replication § 20 (failback capabilities enable in 10. 1 A) After-imaging must be enabled DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Replication Configuration Properties Primary Property File [server] … [control-agent. DELTA] … [transition] … [agent] … 21 Secondary Property File [agent] … [transition] … [server] … [control-agent. DELTA] … DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Protecting Your Future § Replication Overview Sample § Open. Edge Replication Process Image: § Failover, Secondary Replication, and Failback Please § Summary replace it (Insert, Picture, …) 22 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

23 DB-2: Open. Edge® Replication: How to get Home in Time … Primary Replication

Enabling Open. Edge Replication Secondary Primary Replication enabled 24 DB-2: Open. Edge® Replication: How

Failover Time Line Secondary Primary Replication enabled 25 DB-2: Open. Edge® Replication: How to

Primary Replication Configuration Properties Primary Property File [server] control-agents=DELTA database=ALPHA [control-agent. DELTA] name=DELTA database=BRAVO host=nb. Primary port=4501 [agent] name=DELTA database=BRAVO proserve ALPHA –S <DB Port> –DBService replserv 26 Secondary Property File proserve BRAVO –S 4501 –DBService replagent DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Additional Configuration Properties Primary Property File Secondary Property File [agent] [server] connect-timeout=600 transition=manual listener-minport=10024 transition-timeout=60 listener-maxport=20000 defer-agent-startup=720 agent-shutdown-action=recovery [control-agent. DELTA] replication-method=async critical=0 name=secondary 27 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Failover Time Line Secondary Primary Replication enabled 28 Source fails Transition to source DB-2:

Deployment – Fail Over § Manual • Transition target to production § § 29 dsrutil target -C transition agent Auto • Database is automatically transitioned to production Start target database server DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Failover Time Line Secondary Primary FR enabled Source fails Transition to source Updates begin Target shutdown and re-started 30 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Automated Failback Transition Configuration Properties Property File Transition Section Key: Agent Management After Image Management Database Management Backup Management [transition] transition-to-agent=BRAVO database-role=reverse auto-begin-ai=1 auto-add-ai-areas=1 ai-structure-file=primaryai. st restart-after-transition=1 source-startup-arguments= -pf primary. source. pf target-startup-arguments= -pf primary. target. pf backup-method=full-offline backup-arguments=secondary. bak incremental-backup-arguments=secondary. incr. bak 31 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Failover Time Line Secondary Primary Replication enabled Source fails Restore backup Online Transition backup to source Updates begin Target shutdown and re-started 32 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Secondary Replication Configuration Properties Primary Property File Secondary Property File [agent] name=ECHO database=ALPHA [server] control-agents=ECHO database=BRAVO [control-agent. ECHO] name=ECHO database=ALPHA host=nb. Secondary port=4501 proserve ALPHA –S 4501 –DBService replagent 33 DB-2: Open. Edge® Replication: How to get Home in Time … proserve BRAVO –S <DB Port> –DBService replserv © 2007 Progress Software Corporation

Additional Secondary Replication Properties Primary Property File [agent] listener-minport=10024 listener-maxport=20000 connect-timeout=600 34 Secondary Property File [server] transition=auto transition-timeout=60 name=primary defer-agent-startup=720 agent-shutdown-action=recovery [control-agent. ECHO] replication-method=async connect-timeout=600 critical=0 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Failover Time Line Secondary Primary Replication enabled Source fails Reverse roles Restore backup Online Transition backup to source Updates begin Target shutdown and re-started 35 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Failover Time Line Secondary Primary Replication enabled Source fails Reverse roles Restore backup Online Transition backup to source Updates begin Target shutdown and re-started 36 DB-2: Open. Edge® Replication: How to get Home in Time … Target & Source shutdown & re-started © 2007 Progress Software Corporation

Replication Failback Transition § Databases can be • • • § Synchronized shut down Transitioned to new roles AI added and enabled and restarted with a single command Process is initiated from the source database side DSRUTIL database –C transition [failover] 37 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Replication Failback Transition § Transition based on the properties files § Transition will occur based on the following criteria: • • 38 Source or target Online or offline Is Replication Server or Agent running? Has failure just occurred? DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

39 DB-2: Open. Edge® Replication: How to get Home in Time … Primary Replication

Open. Edge Replication Enables… § Online transitions § AI automation • Extent add • Start § Auto DB control • Shutdown after transition • Auto restart 40 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Replication also enables… § Scheduled system maintenance capabilities § Reporting on Target Database 41

In Summary § Protect your business § Protect your data § Protects your future with Open. Edge Replication 42 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Where to go from here § Other Exchange sessions: • COMP-10 Open. Edge Management and Replication – Divide et impera! (June 13, 8 am) • COMP-15 Disaster Recovery Planning (June 13, 3: 30 pm) § PSDN • http: //www. psdn. com/library/kbcategory. jspa? category. I D=555 • Whitepapers! § 43 Professional Services for assistance DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Questions? 44 DB-2: Open. Edge® Replication: How to get Home in Time … ©

Thank you for your time! 45 DB-2: Open. Edge® Replication: How to get Home

Open. Edge Replication Release 10 Failover Process 1. Primary database is Lost • Determine which ai extents to apply dsrutil target -C recovery • 2. Manually apply source AI extents on target (Optional) dsrutil db –C applyextent Secondary database transition • Source or normal / online or offline dsrutil db –C transition 3. AI extents added and AI started 4. [normal AI enablement process] Secondary restarted • Manual or automatic proserve … 5. Awaits communication to Primary 46 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Open. Edge Replication Release 10. 1 B Enable Secondary Replication § Primary machine repaired § Online backup of secondary db § Copy backup to primary machine § Make db on primary machine the target prorest primary bkupfile [–REPLTransition] § DB on secondary machine acting as source and replicating to target on primary 47 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Open. Edge Replication Release 10. 1 B Failback Specifics § Schedule time to get db on primary machine § § transitioned back to source No activity on either machine 2 methods: • Automated Failback • Controlled Transition § On secondary machine: dsrutil secondary –C transition failover 48 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Failback Automated Failback § § § § 49 Initiated on Source database (on Secondary machine) • <insert command> Ensures databases are in sync Backs up databases (periodically for recovery) Shuts down database Does AI management (if requested) Reverses Roles Finishes AI management (if requested) Restarts Databases DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation

Failback Controlled Transition § Controlled Transition • Verify synchronization: – Look at db log file or – Dsrutil source –C status –detail – Shutdown databases – On primary machine transition to source § Dsrutil primary –C transition – On secondary machine transition to target § Dsrutil secondary –C transition 50 DB-2: Open. Edge® Replication: How to get Home in Time … © 2007 Progress Software Corporation