Alteryx Server Failover

paul_houghton

Is there any reason you cannot create a 2-node failover cluster for Alteryx Server?

In this example you would have the Controller, Gallery & Workers on both nodes (MongoDB being run externally on Mongo Atlas) with the MS Cluster Failover Roles configured to manage the Active Controller (following the HA instructions described here)

fmvizcaino

Hi @paul_houghton ,

Alteryx failover follows general failover theory where you need to have a cluster quorum with an odd number of nodes. I'm not really an expert on the field and I don't read enough to explain why it is important to have a cluster quorum, but here are more information about it.

https://techcommunity.microsoft.com/t5/failover-clustering/understanding-quorum-in-a-failover-cluster/ba-p/371678

https://learn.microsoft.com/en-us/windows-server/failover-clustering/manage-cluster-quorum

About the other components, you don't have to follow the instructions, it is ok to have your MongoDB with replica sets (3 nodes as well 😁) and the gallery and worker components in different servers if you want to. Of course, for each of the nodes, you would need an additional server license.

Best,

Fernando Vizcaino