Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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?
Solved! Go to Solution.
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
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