# Overview Trino (formerly known as [[Presto]]) is a fast, distributed [[SQL]] [[query engine]] designed to work with large, heterogeneous data sets. ## Architecture Diagram ![[Trino 2025-01-01 12.24.56.excalidraw.svg]] %%[[Trino 2025-01-01 12.24.56.excalidraw|🖋 Edit in Excalidraw]]%% A coordinator is a single server that handles incoming queries and provides query parsing and analysis, scheduling, and planning. It distributes processing tasks to worker nodes. A worker is a single server that executes tasks as directed by the coordinator, including retrieving data from the data source via the connector and processing data. In the typical Trino cluster, multiple workers operate in parallel to accomplish tasks quickly. # Key Considerations ## Pros and Cons ### Pros - Improved speed since queries can happen across distributed data ### Cons - Requires extensive resources for run successfully due to the below. [[Starburst]] builds on top of Trino to address these challenges. - No option for autoscaling - No built-in security integrations - Requires third-parties for [[Role-based Access Control (RBAC)]] - # Implementation Details # Useful Links # Related Topics ## Reference #### Working Notes #### Sources