Instance Sizes Guide
Before launching Matillion ETL it's worth understanding the available instance types and their limits, allowing you to choose the appropriate instance type for your team. The Matillion ETL client is limited by instance size in the following ways:
- Threads: The number of tasks that can execute simultaneously inside the Matillion ETL instance. Dictated by the number of vCPUs available on the instance.
- Concurrent users: The number of users that can be using the system at the same time. There is no limit on the number of registered users when security is enabled.
- Environments: The total number of environments across all projects that can be defined in a single instance of Matillion ETL. 1 Environment = 1 Project. Thus, the number of Max Environments is equal to the max number of Projects connected to a server.
- Enterprise Mode: Enterprise-only features are only available on certain instance sizes.
For more information, please consult documentation on instance sizes from your provider:
- Amazon Documentation on instance sizes
- Azure Documentation on Virtual Machine sizes
- Google Documentation on Virtual Machine sizes
|Instance Size||Max. Concurrent User||Max. Environments||Max Threads (vCPUs)||Suitable for||Enterprise Mode Available?|
|t2.medium||2||6||2 (Throttled)||Teams of 1 or 2 persons||No|
|t3.medium||2||6||2||Teams of 1 or 2 persons||No|
|m4.large||5||15||2||Teams of 2 to 5 persons||Yes|
|m4.xlarge||12||36||4||Teams of 6 to 12 persons||Yes|
|m5.large||5||15||2||Teams of 2 to 5 persons||Yes|
|m5.xlarge||12||36||4||Teams of 6 to 12 persons||Yes|
|m5.2xlarge||24||36||8||Teams of 6-24 or a highly-available production environment||Yes|
|r5.large||2||15||2||Production Environment. Low user count.||Yes|
|r5.xlarge||2||50||4||Production Environment. Low user count.||Yes|
|r5.2xlarge||2||200||8||Production Environment. Low user count.||Yes|
Google Cloud Platform Instances
All GCP Instances (both for BigQuery and Snowflake) use the n1-standard-2 instance type
|Instance Size||Max. Concurrent User||Max. Environments||Price||Cloud Launcher Link||Enterprise Mode Available?|
|2 User||2||6||$1.37 per hour||On Cloud Launcher||No|
|5 User (Enterprise)||5||15||$2.74 per hour||On Cloud Launcher||Yes|
|12 User (Enterprise)||12||36||$5.48 per hour||On Cloud Launcher||Yes|
The below is true for both Snowflake and Synapse Matillion ETL versions
|Instance Size||Max. Concurrent User||Max. Environments||Max Threads||Azure VM size||Enterprise Mode Available?|
|Large||5||15||8||D4s_v3 and D4_v3||Yes|
|XLarge||12||36||16||D8s_v3 and D8_v3||Yes|
Note: If you have different requirements or use cases that require different limits please contact Matillion Support