Sizing Guidelines
This section provides general guidelines for cluster sizing and node requirements for effective use of the Designer Cloud Powered by Trifacta platform.
Note
These guidelines are rough estimates of what should provide satisfactory performance. You should review particulars of the variables listed below in detail prior to making recommendations or purchasing decisions.
Requirements for the Alteryx node
See System Requirements.
Self-Managed Hadoop
All compute nodes on the cluster (Hadoop NodeManager nodes) should have identical capabilities. Avoid mixing and matching nodes of different capabilities.
Primary variables affecting cluster size:
Data volume
Number of concurrent jobs
In the following table, you can review the recommended number of worker nodes in the cluster based on the data volume and the number of concurrent jobs. Table data assumes that each compute node has 16 compute cores (2 x 8 cores), 128GB of RAM and 8TB of disk, with nodes connected via 10 gigabit Ethernet (GbE).
Data Volume \ Number of concurrent jobs | 1 | 5 | 10 | 25 |
|---|---|---|---|---|
1 GB or less | 1 | 1 | 1 | 2 |
10 GB | 1 | 1 | 2 | 5 |
25 GB | 1 | 2 | 5 | 10 |
50 GB | 1 | 5 | 10 | 25 |
100 GB | 2 | 10 | 20 | 50 |
250 GB | 5 | 25 | 50 | 125 |
500 GB | 10 | 50 | 100 | 250 |
1000 GB (1 TB) | 20 | 100 | 200 | 500 |
Additional variables affecting cluster size:
If you are working with compressed or binary formats, you should use the expanded sizes for your data volume estimates.
Some workloads are more compute- or memory-intensive and may increase the required number of nodes or capabilities of each node. These include:
Scripts with complex steps such as joins (particularly those between large datasets) and sorts
Lengthy scripts
In high availability mode, the total number of connections across all nodes should meet the appropriate requirements in the above table. For each node, please divide the number of connections by the number of Alteryx nodes.
Amazon
Amazon EMR
Note
The sizing guidelines listed for Enterprise Hadoop above provide a good estimate for sizing capacity and upper bounds for EMR-based cluster scaling.
For additional details on sizing your EMR cluster, please contact Alteryx Customer Success and Services.
Microsoft Azure
Microsoft Azure installations support a limited range of installation options, based on the type of cluster integration.
Cluster Type | Description |
|---|---|
Azure Databricks | Please review the Enterprise Hadoop guidelines with Alteryx Customer Success and Services. For more information on this integration, see Configure for Azure Databricks in the Configuration Guide. |