Google Cloud load balancing – SAP HANA Scale-out environment
Blog outlines setup to provide virtual hostname to HANA scale-out environment
via load balancing on google cloud. so even in case of failed-over to standby , application connections will divert automatically to available node.in short NO OUTAGE for applications due to failed-over scenario.
Google cloud load balancing use case
As per standard setup HANA scale-out comes with MASTER , WORKERS and standby role on severs. Application (SLT , BIA tools etc.) connects to one of MASTER OR WORKER node. but application connection fails once that node crashes and failed-over to standby. as per current scenario manual effort require to change all clients connection properties which is time consuming.
In case of SLT data transfer – during outage backlog increases and it might also impacts BIA reporting i.e. true business impact.
Cloud load balancing adds healthcheck feature which keep on checking HANA tenant index server ports and diverts connections only to active nodes. it keeps application connectivity healthy.
HANA statement routing – Concept behind load balancing
parameter client_distribution_mode –> statement
Configuration at google cloud layer
Configuration will add below components at google cloud level. they can be create in sequence as per diagram via command line OR directly from cloud console. ensure you have access at cloud console level.
Post-setup details at google cloud console
After setup health check will look like below at cloud console. it means group ig1 has standby node status where HANA index server and respective port is not open. so application connections will NOT go there.
Health check status will change if failed-over occurs and application connections goes according to active nodes.
Once setup is done configure virtual hostname with application connection.