330 likes | 476 Views
OpenEdge Management and Replication 18.3.2010 Scandi PUG. Jarmo Nieminen Senior Technical Account Manager Nordics jarmo.nieminen@progress.com. Who will you call if you lose service?. No one… Only you are responsible for data!!!. Data. Applications. AP, Progress?. Operating Systems.
E N D
OpenEdge Management and Replication18.3.2010 Scandi PUG Jarmo Nieminen Senior Technical Account Manager Nordics jarmo.nieminen@progress.com
Who will you call if you lose service? No one… Only you are responsible for data!!! Data Applications AP, Progress? Operating Systems Microsoft, HP, Sun, Redhat? Hardware Dell, IBM, Sun? Networking Provider, Telecoms'? Network / Communications
OpenEdge Replication • Native Progress Product • Zero Latency, near real-time replication • Managed failover processing • Simple setup • “Plug and play" technology with no application changes required • Allows read-only access to standby, reporting etc.
DB BI AI OpenEdge Replication Process Primary Machine DB Shared Memory DB Buffer Pool
DB BI AI OpenEdge Replication Process (2) Primary Machine Replication Server DB Shared Memory DB Buffer Pool
DB BI AI OpenEdge Replication Process (3) Primary Machine Replication Server DB Shared Memory DB Buffer Pool
DB BI AI OpenEdge Replication Process (4) Primary Machine Secondary Machine Replication Server Replication Agent DB Shared Memory DB Buffer Pool
DB DB BI AI BI AI OpenEdge Replication Process (5) Primary Machine Secondary Machine Replication Server Replication Agent DB Shared Memory DB Shared Memory DB Buffer Pool DB Buffer Pool
How Does it Work? • Plugs into AI sub-system • TCP connection between server and agent • Replication Server transfers blocks • Replication Agent receives blocks and updates database
Replication Server DB Shared Memory DB Buffer Pool DB DB BI AI BI AI Implementing OpenEdge ReplicationDealing with Failures Primary Machine Secondary Machine Replication Agent DB Shared Memory DB Buffer Pool
Demo • Replicationproperties (Primary and Secondary) • SetupPrimarymachine and backupmachine • Failover (Primary -> Secondary) • Failback (Secondary -> Primary) • OpenEdge Management
Enteringpretransition dsrutil target -C recovery dsrutil target -C applyExtentqualified-extent-name
Transitioning the target database to a source database dsrutil target -C transition
Replication fail back process cont.. dsrutil secondary -C transition failover