question Re: Load balancer for metastore in Support Questions

Load balancer for metastore

Daggers — Fri, 16 Sep 2022 14:10:39 GMT

Hi,

We have HA enabled for the metastore and have 2 instances running. Is it possible to configre a load balancer in front of these ? and if so is this normal practice ?

Thanks

Re: Load balancer for metastore

EricL — Wed, 06 Mar 2019 08:37:43 GMT

HMS does not currently support Load Balancing. You can only specify them in order in hive-site.xml and it will fall to the second HMS only when first HMS is not reachable.

Re: Load balancer for metastore

noamh — Mon, 25 Mar 2019 15:06:00 GMT

Hi,

So how do you scale Hive Metastore when you need to support more than 80 active connections?

According to Cloudera's documentation they only mention supporting up to 80 connections which needs 16-24GB.

Does passing 80 connection requires to continue extending the Heap Memory? How big can it be since 24GB is already too big isn't it?

Attaching Cloudera's memory setup recommendations:

https://www.cloudera.com/documentation/enterprise/5-15-x/topics/cdh_ig_hiveserver2_configure.html

Best, Eyal