n a Trino cluster, the coordinator represents a single point of failure. If the coordinator becomes unavailable, all running queries are lost, and the cluster cannot accept new queries until the coordinator is restored.
To address this limitation, deploy multiple Trino clusters behind a load-balancing layer.
Trino Gateway is a community-supported solution that provides load balancing, query routing, and proxy capabilities for Trino environments. Unlike a generic load balancer, Trino Gateway supports rule-based query routing, allowing queries to be directed to specific Trino clusters based on configurable criteria such as users, groups, or query patterns.
You can deploy multiple Trino Gateway instances within the Ambari cluster, all connected to the same backend Trino clusters. To expose a single endpoint for client connectivity and provide high availability for the gateway layer, place an external load balancer such as HAProxy or NGINX in front of the Trino Gateway instances.
