Symptom
This is an example configuration which is showing step by step how to configure SAP Hana Multitarget System Replication using SAP Hana Cockpit 2.0 as mentioned in our SAP HANA System Replication guide:
In a multitarget system replication, primary and secondary systems can replicate data changes to more than one system.
-
Update scenarios
-
Rearrangements of system replication multitier chains
-
Reaching higher availability (before stopping existing structures, new structures can be built and established)
The graphic shows a possible setup for multitarget system replication.
Primary system A in data center 1 replicates data changes to secondary system B in the same data center. Primary system A also replicates data changes to secondary system C in data center 2. Secondary system C is a source system for a further secondary system D located in the same data center with system C.
To understand how to handle different disaster recovery scenarios, see Disaster Recovery Scenarios for Multitarget System Replication. In a multitarget system replication, the secondary systems can be configured to automatically re-register to a new source system when the original source system unavailable.
For multitarget system replication either the logreplay or logreplay_readaccess mode is required.
In a multitarget system replication setup, you can configure multiple secondaries as Active/Active (read enabled). Only one of these secondaries can be accessed via hint-based statement routing; the others must be accessed via direct connection. For more information on Active/Active (read enabled), see Active/Active (Read Enabled).
Read more...
Environment
in this scenario there are 4 Hana nodes all preconfigured running as stand alone system with the same System ID. More details for General Prerequisites for Configuring SAP HANA System Replication can be read here.
At the time when this how to is created I'm using current available releases for SAP Hana DB and SAP Hana Cockpit 2.0.
SAP Hana Studio with all Hana DB host running without System Replication enabled.
Keywords
KBA , HAN-CPT-CPT2-ADM , SAP HANA Cockpit 2 (Administration Core) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.