1 / 57

DB-12: Achieving High Availability with Clusters and OpenEdge ® Replication

DB-12: Achieving High Availability with Clusters and OpenEdge ® Replication. Combining the two technologies. Hugo Loera Chávez Senior Tech Support Engineer. Presentation Goals. Combining the two technologies. To understand how OpenEdge ® Enterprise DB works with Clusters.

vidar
Télécharger la présentation

DB-12: Achieving High Availability with Clusters and OpenEdge ® Replication

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. DB-12: Achieving High Availability with Clusters and OpenEdge® Replication Combining the two technologies Hugo Loera Chávez Senior Tech Support Engineer

  2. Presentation Goals Combining the two technologies • To understand how OpenEdge® Enterprise DB works with Clusters. • To understand how OpenEdge Replication works. • To know how to combine Clusters and OpenEdge Replication. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  3. Agenda Combining the two technologies • Why do we need this ? • What is a Cluster ? • How OpenEdge Enterprise DB works with a Cluster? • Overview of OpenEdge Replication • Combining OpenEdge Replication with Clusters • Setting OpenEdge Enterprise DB for High Availability • Starting OpenEdge Replicated DB on the Cluster DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  4. Why do we need this ? You never know what can happen in your day…. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  5. Agenda Combining the two technologies • Why do we need this ? • What is a Cluster ? • How OpenEdge Enterprise DB works with a Cluster? • Overview of OpenEdge Replication • Combining OpenEdge Replication with Clusters • Setting OpenEdge Enterprise DB for High Availability • Starting OpenEdge Replicated DB on the Cluster DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  6. What is a Cluster ? One possible Cluster definition A group of loosely coupled computers that work together closely so they can be viewed as a single unit. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  7. What is a Cluster ? Clusters implementations • The most common implementations are: • High-availability Clusters • Load balancing Clusters • High-performance Clusters • Massively parallel Clusters Supported by Progress Using OpenEdge Enterprise RDBMS DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  8. What is a Cluster ? A typical High-availability Cluster setup Node 2 Node 1 Internal network connection Application Application NIC NIC Operating System Operating System SCSI connection Storage Cluster Manager Cluster Manager LAN connection NIC NIC Local Storage Local Storage DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  9. What is a Cluster ? Active Node DB DB DB Common Storage Cluster connectivity Node 2 Node 1 Application Application Operating System Operating System Cluster Manager Cluster Manager Cluster name or Cluster IP Address Local Storage Local Storage Node 1 IP Address Node 2 IP Address DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  10. What is a Cluster ? Heartbeat High-availability Components • Cluster Manager • Resources • Monitors • Heartbeat Cluster Manager Monitors Resources Node 2 Node 1 DB DB DB Common Storage DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  11. What is a Cluster ? New Active Node Cluster Manager Failover Node 2 Failover process X Node 1 DB DB DB Common Storage DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  12. What do we need to make Clusters work with an OpenEdge DB ? DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  13. Agenda Combining the two technologies • Why do we need this ? • What is a Cluster ? • How OpenEdge Enterprise DB works with a Cluster? • Overview of OpenEdge Replication • Combining OpenEdge Replication with Clusters • Setting OpenEdge Enterprise DB for High Availability • Starting OpenEdge Replicated DB on the Cluster DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  14. How OpenEdge Enterprise works with a Cluster ? DB DB DB Common Storage OpenEdge Enterprise installation requirements • It must be installed in each Cluster node. • The installation on each node must keep the same directory structure. • PSC_CLUSTER_PATH must point to the OpenEdge installation directory. Node 2 Node 1 Application Application Operating System Operating System Cluster Manager Cluster Manager Local Storage Local Storage OpenEdge Enterprise DB OpenEdge Enterprise DB DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  15. How OpenEdge Enterprise works with a Cluster ? Product requirements • OpenEdge Enterprise DB 10.1A • OpenEdge Enterprise DB 10.0B01 or higher DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  16. How OpenEdge Enterprise works with a Cluster ? Existing supported Cluster platforms • IBM • HACMP Cluster Manager. • HP • HP MC/ServiceGuard. • TruCluster. • SUN • SUN Cluster • Microsoft • Windows Server Enterprise. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  17. Now, let’s see how OpenEdge Replication works DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  18. Agenda Combining the two technologies • Why do we need this ? • What is a Cluster ? • How OpenEdge Enterprise DB works with a Cluster? • Overview of OpenEdge Replication • Combining OpenEdge Replication with Clusters • Setting OpenEdge Enterprise DB for High Availability • Starting OpenEdge Replicated DB on the Cluster DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  19. Overview of OpenEdge Replication Overview of OpenEdge Replication What is OpenEdge Replication used for ? • To have a hot spare DB. • To offload reporting from the production DB. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  20. Overview of OpenEdge Replication Site A Site B Replicated remote site Remote Link Replication Server Replication Agent AI Block AI Buffer R/O Target DB After Image Source DB DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  21. Overview of OpenEdge Replication Site A Site B Transition to Site B X Target DB After Image Source DB DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  22. Overview of OpenEdge Replication Product requirements • OpenEdge Enterprise DB 10.1A with: • OpenEdge Replication 10.1A • OpenEdge Replication plus 10.1A • OpenEdge Enterprise DB 10.0B01 or higher with: • Fathom Replication 10.0B • Fathom Replication plus 10.0B DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  23. Overview of OpenEdge Replication Overview of OpenEdge Replication Installation requirements • OpenEdge Enterprise and Replication must be installed together at: • The source DB host. • The target DB host. • The source DB host and the target must have the same OpenEdge Release. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  24. Overview of OpenEdge Replication Additional benefits when using OpenEdge Replication Plus • Allows to use the replicated data in read-only mode. • It allows to offload reporting from the production DB. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  25. Overview of OpenEdge Replication After Image Replication How will the DB backup strategy work with OpenEdge Replication ? • The regular backup routine is still required. • OpenEdge Replication adds another protection layer to the regular DB backup strategy. DB Backup DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  26. How can we mix OpenEdge Enterprise DB, OpenEdge Replication and a Cluster ? DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  27. Agenda Combining the two technologies • Why do we need this ? • What is a Cluster ? • How OpenEdge Enterprise DB works with a Cluster? • Overview of OpenEdge Replication • Combining OpenEdge Replication with Clusters • Setting OpenEdge Enterprise DB for High Availability • Starting OpenEdge Replicated DB on the Cluster DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  28. Combining OpenEdge Replication with Clusters High availability configuration diagram Replication Agent Replication Server Node 1 Node 2 Target DB OpenEdge Enterprise & Replication DB Broker Operating System Operating System Source DB Cluster Manager Cluster Manager Common Storage Site B Local Storage Local Storage OpenEdge Enterprise DB & Replication OpenEdge Enterprise DB & Replication Site A DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  29. Combining OpenEdge Replication with Clusters Hardware failure on Node 1 Replication Agent Replication Server Node 1 Node 2 X Target DB OpenEdge Enterprise & Replication DB Broker Operating System Operating System Source DB Cluster Manager Cluster Manager Common Storage Site B Local Storage Local Storage OpenEdge Enterprise DB & Replication OpenEdge Enterprise DB & Replication Site A DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  30. Combining OpenEdge Replication with Clusters Common Storage or Site failure DB Broker Node 1 Node 2 X X X DB OpenEdge Enterprise & Replication Operating System Operating System Source DB Cluster Manager Cluster Manager Common Storage Site B Local Storage Local Storage OpenEdge Enterprise DB & Replication OpenEdge Enterprise DB & Replication Site A DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  31. Combining OpenEdge Replication with Clusters Why integrate Clusters with OpenEdge Replication ? • Cluster offers: • Elimination of individual computer as a single point of failure. • Quick response in case of a hardware failure. • Replication offers: • Removal of the DB as a single point of failure. • Elimination of the central storage as a single point of failure. • Site failure protection. • Access to up to two replicated DB’s. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  32. How do we configure all this ? DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  33. Agenda Combining the two technologies • Why do we need this ? • What is a Cluster ? • How OpenEdge Enterprise DB works with a Cluster? • Overview of OpenEdge Replication • Combining OpenEdge Replication with Clusters • Setting OpenEdge Enterprise DB for High Availability • Starting OpenEdge Replicated DB on the Cluster DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  34. Setting OpenEdge Enterprise for High Availability Example • Let’s set a source and a target DB called Demo. • The source Demo DB will reside in the Cluster. • The target Demo DB will reside in a remote host. DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  35. Setting OpenEdge Enterprise for High Availability Create Target DB Stop Source DB Stop Target DB Restore DB and Incremental ProCluster enable Source DB Enable Target Replication Start Target DB Start Target DB Start Clustered Source DB Start Source DB Configuring procedure flow diagram Create Source DB Backup DB Enable AI Enable Source Replication Incremental Backup DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  36. Setting OpenEdge Enterprise for High Availability Creating the source Demo DB at the Cluster site A Node 1 Node 2 Source Demo Common Storage Local Storage Local Storage OpenEdge Enterprise DB & Replication OpenEdge Enterprise DB & Replication Site A DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  37. Setting OpenEdge Enterprise for High Availability Creating the source Demo DB • Create a DB in a directory within the shared storage device. • Add After Image extents as required. • Copy from %DLC%\properties: source.repl.properties into the DB directory. • Rename it as Demo.repl.properties DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  38. Setting OpenEdge Enterprise for High Availability Source Demo DB files Demo.DB Demo.b1 Demo DB Demo.repl.properties Source DB Replication Properties File Demo.d1 + Demo_7.d1 Demo_8.d1 Demo.a1 Demo.a1 Demo.a1 DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  39. Setting OpenEdge Enterprise for High Availability DemoSourceDB Replication Properties File • Define the replication agent name. • Define the target DB host name. • Define target DB port number. Demo.repl.properties file [server] control-agents=agent1 database=Demo transition=manual transition-timeout=600 [control-agent.agent1] name=agent1 database=target host=remotehost port=4501 connect-timeout=120 replication-method=async critical=0 DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  40. Setting OpenEdge Enterprise for High Availability Enabling Demo DB as the source • Perform a probkup of the Demo DB. • Run rfutil Demo -C aimage begin • Run proutil Demo -C enablesitereplication source • Perform incremental probkup of the DB DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  41. Setting OpenEdge Enterprise for High Availability Creating the target Demo DB at the remote site B Target Demo OpenEdge Enterprise DB & Replication Site B DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  42. Setting OpenEdge Enterprise for High Availability Creating Demo DB as the target • Create a structure for the target DB Demo into the DB directory. • Restore Source DB backup and incremental. • Copy from %DLC%\properties: target.repl.properties into the DB directory. • Rename it as Demo.repl.properties DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  43. Setting OpenEdge Enterprise for High Availability DemoTargetDB Replication Properties File • Define the replication agent name • Define the target DB name Demo.repl.properties file [agent] name=agent1 database=Demo listener-minport=4387 listener-maxport=4500 DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  44. Setting OpenEdge Enterprise for High Availability Incremental Backup Demo Backup Target DB Demo files Demo.DB Demo.b1 Demo.repl.properties TargetDB Replication Properties File + Demo DB Demo.d1 Demo_7.d1 Demo_8.d1 DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  45. Setting OpenEdge Enterprise for High Availability Starting the target and source DB Demo • Run: • proutil Demo -C enableSiteReplication target • Run: • proserve -db Demo -DBService replagent -S4501 • In the Cluster site A, where the Source is, run: • proserve -db Demo -DBService replserv DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  46. Setting OpenEdge Enterprise for High Availability Verifying that replication has been accomplished by viewing in the log file. • When the replication process starts, the source DB log shows: • The Fathom Replication Server has successfully connected to the Fathom Replication Agent agent1 on host remotehost. (10507) • When replication has been established the source DB log shows: • The source database Demo and the target database E:\DB\Demo on host remotehost are synchronized. (10436) DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  47. How do we start the replicated Source Demo DB as a clustered resource and keep the replication running? DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  48. Agenda Combining the two technologies • Why do we need this ? • What is a Cluster ? • How OpenEdge Enterprise DB works with a Cluster? • Overview of OpenEdge Replication • Combining OpenEdge Replication with Clusters • Setting OpenEdge Enterprise DB for High Availability • Starting OpenEdge Replicated DB on the Cluster DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  49. Starting OpenEdge Replicated DB on the Cluster Replication Agent Replication Server Enabling and Starting the Clustered source DB Node 1 Node 2 Target Demo OpenEdge Enterprise DB & Replication DB Broker Operating System Operating System Source Demo Cluster Manager Cluster Manager Common Storage Site B Local Storage Local Storage OpenEdge Enterprise DB & Replication OpenEdge Enterprise DB & Replication Site A DB-12 Achieving High Availability with Clusters and OpenEdge Replication

  50. Starting OpenEdge Replicated DB on the Cluster Registering the source DB with the Cluster Manager • Shut down Source and Target DB’s • Create a source .pf file (required for the Cluster) • Set the following parameters in Demo.pf : • -cluster protected • -DBService replserv • procluster e:\DB\Demo enable –pf Demo.pf DB-12 Achieving High Availability with Clusters and OpenEdge Replication

More Related