Client Side Load Balancing for Distributed SAP HANA

[Former Member]

Hi Experts.

I set up Distributed SAP HANA System.

In indexserver.ini configuration file,

there's a parameter "client_distribution_mode"

[distribution]

# .short_desc

# Set the client distribution mode

# .full_desc

# This can change the client's distribution behavior.

# off: all distribution features are disabled.

# connection: client side load balancing is enabled.

# statement: statement routing is enabled.

# all: all distribution features are enabled.

# .type enum

# .range off,connection,statement,all

# .change online

client_distribution_mode = statement

Default setting shows "statement".

I changed this parameter to "connection" / "all",

and

connect from client with statement "...node1:30015; node2:30015; node3:30015...", but all clients always connnect node1.

How can I use client side load balancing function?

I already check the thread below.

(it says there's no load balancing, but I believe there's load balancing by using the parameter above)

http://scn.sap.com/thread/3144226

Best Regards.

[Former Member · Accepted solution]

solved.

[rindia · Accepted solution]

Dear Yoh,

Could you please share how you solved this problem so that if there is any similar issue then your answer would be of great help to others.

Regards

Raj

[Former Member · Accepted solution]

This message was moderated.

[rindia]

Dear Yoh Maekawa,

As part of setting up a distributed system you need to configure network parameters. The configuration of the network parameters should happen before you add additional hosts. This is done because one server needs to be available so that you can connect to the SAP HANA studio.

In the Configuration tab of the SAP HANA studio you edit the section internal_hostname_resolution in the global.ini file. This is where the mapping of hostnames to IP addresses takes place.

Have you done this configuration. If not then please refer to Administration Guide SPS 05 chapter 11.2 for more details.

By the way I cannot find the section internal_hostname_resolution in global.ini file. I am on revision 46.

Regards

Raj