SAP Knowledge Base Article - Preview

3744437 - How to route SELECT statements to the secondary site in HANA Active/Active (Read Enabled)

Symptom

You have configured SAP HANA System Replication (HSR) with the operation mode logreplay_readaccess.

You notice that by default, all SELECT queries are still being executed on the Primary site.

You want to offload read-only workloads to the Secondary site to balance the load.


    Read more...

    Environment

    • SAP HANA Platform 2.0
    • SAP HANA System Replication (HSR)
    • Operation Mode: logreplay_readaccess (Active/Active Read Enabled)

    Product

    SAP HANA, platform edition 2.0

    Keywords

    HSR; System Replication; logreplay_readaccess; Active/Active; Read Enabled; SQL Hint; ROUTE_TO_SECONDARY_REPLICA; Secondary Site; Performance; Offloading. , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , 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.