Operation mode | SAP HANA Version | Description | Advantages |
delta_datashipping | no restriction | Synchronization between primary and secondary site is implemented via regular delta data shippings from primary to secondary site. |
|
logreplay | >= 1.00.110 | Synchronization between primary and secondary site is implemented purely based on redo logs Column store generally has to be loaded into memory to provide reasonable delta merge speed |
|
logreplay_readaccess | >= 2.00 | Synchronization between primary and secondary site is implemented purely based on redo logs Column store generally has to be loaded into memory to provide reasonable delta merge speed See SAP Note 2391079 for restrictions. |
|
The operation mode can be checked from the following parameter:
global.ini -> [system_replication] -> operation_mode
They are defined by “hdbnsutil -sr_register –operationMode= …” command.
In 3-tier environments the following details can be considered for the logreplay mode:
- If the tertiary system is down, the logs are only saved on the secondary system, not on the primary system.
- If the secondary system is down and you want to use the tertiary system as secondary system, usually a full sync is required, because the logs retained on primary site are meant for the secondary site and so they may not be compatible with the tertiary system.
SAP Note 2661878 provides settings that can be used to optimize the performance of logreplay on secondary system replication site. These settings are a trade-off between logreplay performance and memory utilization and secondary site, so tests are required in order to identify an optimal compromise.