Thursday 30 March 2017

Replication setup using HANA cockpit 2.0 and testing Active/Active Read Enable

Prerequisites:

  • You have installed and configured two identical, independently-operational SAP HANA systems – a primary system and a secondary system.
  • The required ports must be available.
  • The same instance number is used for primary and secondary systems. The instance number +1 must be free on both systems, because this port range is used for system replication communications.
  • You have added both systems in the SAP HANA cockpit.
  • You have verified that the log_mode parameter in the persistence section of the global.ini file is set to normal for both systems.
  • You have performed a data backup or storage snapshot on the primary system. In multiple-container systems, the system database and all tenant databases must be backed up. This is necessary to start creating log backups. Activated log backup is a prerequisite to get a common sync point for log shipping between the primary and secondary system.
  • You have stopped the secondary system.
The secondary system must meet the following criteria with respect to the primary system:
  • It must have a different host name, or host names in the case of a distributed system.
  • If the host names of the primary and the secondary systems are the same (for example, because two systems with identical host names are used) in the SAP HANA lifecycle management use the tool hdblcm(gui) to change the host name(s) of the secondary system.
  • It must have the same number of worker hosts. This implies that if there is a standby host on the primary system, it need not be available on the secondary system.
  • It must have the same software version or higher.
  • It must have the same SAP system ID (SID).
  • It should run on the same platform.

Replication Set up using Cockpit:


As per prerequisite, We have 3 Tier MDC landscape setup and added all resources (SYSTEMDB, Tenant DBs) to HANA 2.0 Cockpit and grouped them in Primary System, Secondary HA and Tertiary DR Group as shown below:

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Now First connect to SYSTEMDB of group ‘Primary system’: SYSTEMDB@ABH

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions
Click on ‘System Replication’ Tile:

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Configuring Replication from HANA cockpit is available only from SYSTEMDB@<SID>, though replication tile is available to Tenant DBs also but in Tenant DB you can also see information if Replication is configured or not.

It will provide information System Replication is not enabled for this system.

Click on ‘Configure System replication’

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

You can run it in Background Also and refresh later to check replication status

System replication is enabled for Primary system

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Shutdown the Secondary Database and go to ‘Secondary HA group’ and connect to SYSTEMDB@ABH and go to Replication tile.->Configure Replication

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

‘Cannot load data’ is because secondary system is not available but you are able to connect to Secondary Site

Click on Register Secondary System:

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

In secondary system in cockpit:

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

‘Primary System’ GroupàSYSTEMDB@ABH

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

You can check Replicated Services , Network SITE 1 to 2 and Log Replay on Tier 2

You can perform the take over also using HANA cockpit. In tenant , only tenant information is available

Now we will enable Replication for tertiary system for DR site. Shutdown the DR site first and then

Connect to Tertiary DR Group and SYSTEMDB@ABH–> Replication TileàRegister Secondary System

Testing if log replay – read access is allowed for 3rd site

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Error As expected as logreplay_readaccess is not allowed for 3rd level of replication.Configuring it with logrepaly Operation Mode

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Replication Enabled and start the system. Now we can’t connect to tertiary database as A/A read enable is not possible for tertiary site.

Checking SYSTEMDB@ABH in “Primary SYSTEM Group” after 3 tier Replication:

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Testing A/A read Enabled:


Import data into Tenant DB Primary System ABH:

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Testing data loading into Secondary system

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Delete the data from Secondary System

SAP HANA Tutorials and Materials, SAP HANA Guide, SAP HANA Certifictions

Active/Active read enabled works as designed.

No comments:

Post a Comment