Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
bbbm
Frequent Visitor

Any reason *not* to enable load balancing for data gateways in a cluster?

I'm going to setup a seperate data gateway.  My primary concern at this point is failover support. 

But hey - simple load balancing is just a checkbox away. And assuming both of my servers are roughly equal, is there any reason *not* to select load balancing? 

Bonus Question: When installing the 2nd gateway in the cluster, I choose setup a new data gateway in install / choose the cluster. For recovery key, do I give it the recoery key from the 1st gateway? 

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @bbbm ,

 

Q1. Assuming both of my servers are roughly equal, is there any reason not to select load balancing? 

When the load balancing option is enabled, traffic will be evenly distributed among the gateways in the cluster. The purpose of this is to ensure that the cluster does not become overloaded and cause a failure. 

Offline gateway within a cluster will impact performance negatively. So if a gateway is offline and you are using Load balancing, you should either remove or disable it because you are distributing the load among all active gateways in that cluster. If one gateway is offline in the cluster there will be performance issues.

So you have to choose whether to turn on this option according to the actual situation. 

Monitor and optimize on-premises data gateway performance

Manage on-premises data gateway high-availability clusters and load balancing

 

Q2. When installing the 2nd gateway in the cluster, I choose setup a new data gateway in install / choose the cluster. For recovery key, do I give it the recoery key from the 1st gateway? 

Yes. After testing, you need to enter the same recovery key. When a different recovery key is entered, an error is reported.

 

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

View solution in original post

1 REPLY 1
v-cgao-msft
Community Support
Community Support

Hi @bbbm ,

 

Q1. Assuming both of my servers are roughly equal, is there any reason not to select load balancing? 

When the load balancing option is enabled, traffic will be evenly distributed among the gateways in the cluster. The purpose of this is to ensure that the cluster does not become overloaded and cause a failure. 

Offline gateway within a cluster will impact performance negatively. So if a gateway is offline and you are using Load balancing, you should either remove or disable it because you are distributing the load among all active gateways in that cluster. If one gateway is offline in the cluster there will be performance issues.

So you have to choose whether to turn on this option according to the actual situation. 

Monitor and optimize on-premises data gateway performance

Manage on-premises data gateway high-availability clusters and load balancing

 

Q2. When installing the 2nd gateway in the cluster, I choose setup a new data gateway in install / choose the cluster. For recovery key, do I give it the recoery key from the 1st gateway? 

Yes. After testing, you need to enter the same recovery key. When a different recovery key is entered, an error is reported.

 

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Helpful resources

Announcements