DB12: Achieving High Availability with Clusters and OpenEdge Replication

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.

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

4
Why do we need this ?
You never know what can happen in your day.
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

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.
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
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
9
What is a Cluster ?
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
10
What is a Cluster ?
High-availability Components

• Cluster
• Manager
• Resources
• Monitors
• Heartbeat

Cluster Manager
Monitors
Resources
Node 2
Node 1
DB
DB
DB
Common Storage
11
What is a Cluster ?
Failover process
X
Node 1
DB
DB
DB
Common Storage
12

• What do we need to make Clusters work with an
  OpenEdge DB ?

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

14
How OpenEdge Enterprise works with a Cluster ?
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
15
How OpenEdge Enterprise works with a Cluster ?
Product requirements

• OpenEdge Enterprise DB 10.1A
• OpenEdge Enterprise DB 10.0B01 or higher

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.

17

• Now, lets see how OpenEdge Replication works

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

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.

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
21
Overview of OpenEdge Replication
Site A
Site B
Transition to Site B
X
Target DB
After Image
Source DB
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

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.

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.

25
Overview of OpenEdge 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
26

• How can we mix OpenEdge Enterprise DB, OpenEdge
  Replication and a Cluster ?

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

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
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
30
Combining OpenEdge Replication with Clusters
Common Storage or Site failure
DB Broker
Node 2
Node 1
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
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 DBs.

32

• How do we configure all this ?

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

34
Setting OpenEdge Enterprise for High Availability
Example

• Lets 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.

35
Setting OpenEdge Enterprise for High Availability
Configuring procedure flow diagram
Create Source DB
Backup DB
Enable AI
Enable Source Replication
Incremental Backup
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
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

38
Setting OpenEdge Enterprise for High Availability
Source Demo DB files
Demo.DB
Demo.b1
Demo DB
Demo.repl.properties Source DB Replication Propert
ies File
Demo.d1

Demo_7.d1
Demo_8.d1
Demo.a1
Demo.a1
Demo.a1
39
Setting OpenEdge Enterprise for High Availability
Demo Source DB Replication Properties File
Demo.repl.properties file

• Define the replication agent name.
• Define the target DB host name.
• Define target DB port number.

server control-agentsagent1
databaseDemo transitionmanual
transition-timeout600 control-agent.agent1
nameagent1 databasetarget
hostremotehost port4501
connect-timeout120 replication-methodasync
critical0
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

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
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

43
Setting OpenEdge Enterprise for High Availability
Demo Target DB Replication Properties File

• Define the replication agent name
• Define the target DB name

Demo.repl.properties file
agent nameagent1 databaseDemo
listener-minport4387 listener-maxport4500
44
Setting OpenEdge Enterprise for High Availability
Target DB Demo files
Demo.DB
Demo.b1
Demo.repl.properties Target DB Replication Propert
ies File
Demo DB

Demo.d1
Demo_7.d1
Demo_8.d1
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 -S 4501
• In the Cluster site A, where the Source is, run
• proserve -db Demo -DBService replserv

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)

47

• How do we start the replicated Source Demo DB as
  a clustered resource and keep the replication
  running?

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

49
Starting OpenEdge Replicated DB on the Cluster
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
50
Starting OpenEdge Replicated DB on the Cluster
Registering the source DB with the Cluster Manager

• Shut down Source and Target DBs
• 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

51
Starting OpenEdge Replicated DB on the Cluster
Starting the clustered Source DB
Procluster DB start
Cluster Manager
Cluster Manager Starts Protected Resource
DB is Started
_mprosrv
52
Starting OpenEdge Replicated DB on the Cluster
Registering the source DB with the Cluster Manager

• Start target DBs using
• proserve -db Demo -DBService replagent -S 4501
• Start source DBs using
• procluster e\DB\Demo start
• Verify replication synchronization in the log.

53
Starting OpenEdge Replicated DB on the Cluster
Now we take a look again to the source Demo.lg
to verify that replication has been accomplished.

• 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)

54
In Summary

• Working with OpenEdge Enterprise and Clusters
  offers quick recovery from hardware failures.
• OpenEdge Replication protects us in case of a
  site down situation.
• The combination of both allow protection from
  several disaster scenarios.

55
Questions?
56
Thank you foryour time
57
(No Transcript)