1

Application team requesting for 2 new servers (nodes) as in hardware to run Trino in docker container. Current Trino cluster running on 6 nodes, and current setup is as a mid-size setup. No much info is provided online though team put up some recommendations.

  • Will be running on ubuntu LTS

  • as much RAM as possible without breaking the bank, 256GB per node

  • Min 16 cores per CPU

anything else i need to worry about?

2 Spice ups
2

The team requesting this should be able to give you advice on what they need, no point you deciding what they need for them to tell you it’s not enough. They know what they’ll be doing with the data and what resources they should need.

See here though as an overview

https://stackoverflow.com/questions/19863857/hardware-requirements-for-presto

3

To ensure optimal performance while running Trino, a distributed SQL query engine, it’s crucial to consider the right server specifications. For a small cluster, begin with a minimum of three nodes, each equipped with a multicore CPU, 16GB to 32GB of RAM, and suitable storage.

In more substantial production environments, opt for high-performance CPUs, 64GB or more of RAM per node, and high-speed storage such as SSDs. Efficient networking and, in larger setups, a load balancer are essential for distributed query processing.

Additionally, carefully configure the Java Virtual Machine (JVM) settings and implement robust monitoring and logging. Trino’s dynamic scaling capabilities allow for flexibility in adding or removing nodes based on workload demands.

1 Spice up